Red Hat Bugzilla – Bug 57207
no information on how to add -i option for postgresql in 7.2
Last modified: 2007-04-18 12:38:36 EDT
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):
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
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
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