From Bugzilla Helper: User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Description of problem: postgresql's package on redhat7.2 by default does not listen on tcp ports. This is confusing to people with 7.1 experience, because the -i option is enabled there by default. The postgresql service startup process is not documented at all, which makes this problem hard to troubleshoot for someone new to LINUX. The difference between the packages is that /var/lib/pgsql/data/postmaster.opts.default file is not created in the 7.2 distribution (on 7.1 it is). This is very confusing to people migrating from 7.1 to 7.2. Version-Release number of selected component (if applicable): How reproducible: Always Steps to Reproduce: 1. install postgresql 2. type service postgresql start 3. type fuser -n tcp 5432 4. (no process will be listening) 5. type vi /var/lib/pgsql/data/postmaster.opts.default 6. in the text file add the line -i 7. save the file 8. 9. postgresql is now properly enabled to listen on incoming TCP connections Actual Results: postgresql was not listening on port 5432 Expected Results: postgresql had tcp connections enabled with -i switch in 7.1 Additional info: The postgresql startup process is complicated and involves several files: /etc/rc.d/init.d/postgresql and /usr/bin/pg_ctl you should document somewhere how to properly add -i to the startup options in the documentation. This is very hard to find for a new user, even with a howto.
You enable networking support by uncommenting the proper lines in /var/lib/pgsql/data/postgresql.conf. You can also enable SSL support as well as custom port number.
the /var/lib/pgsql/data/postgresql.conf you mention does not exist in this location on my machine. I'm using redhat 7.2 with ximian gnome desktop and installed the postgresql-7.0.3-8 rpm through redcarpet.
These packages are not what we ship - we ship postgresql 7.1 with RHL 7.2