Bug 57207 - no information on how to add -i option for postgresql in 7.2
Summary: no information on how to add -i option for postgresql in 7.2
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Red Hat Linux
Classification: Retired
Component: postgresql
Version: 7.2
Hardware: i386
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Trond Eivind Glomsrxd
QA Contact: David Lawrence
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2001-12-06 20:32 UTC by Need Real Name
Modified: 2007-04-18 16:38 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2001-12-06 20:32:05 UTC
Embargoed:


Attachments (Terms of Use)

Description Need Real Name 2001-12-06 20:32:01 UTC
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.

Comment 1 David Lawrence 2001-12-06 20:49:32 UTC
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.

Comment 2 Need Real Name 2001-12-06 21:24:44 UTC
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.

Comment 3 Trond Eivind Glomsrxd 2001-12-06 21:40:17 UTC
These packages are not what we ship - we ship postgresql 7.1 with RHL 7.2


Note You need to log in before you can comment on or make changes to this bug.