Thanks that tip pointed me in the right direction.
I had to add the following line to the startup script in the inet.d folder.
-o '-i'
was added to the startup line with the "pg_sql start" command. Note the single quotes around the -i are needed. The
docsshow double quotes but since the script uses them you can't use double quotes.
Also you have to add them in with the -o option since the startup script uses pg_ctl to start up postgresql. At least
the7.1 version.
>>> "Chris Mulcahy" <cmulcahy@cmulcahy.com> 05/17/01 10:09AM >>>
Eric:
Try putting the -i (lowercase) into the startup file. You can also specify
the -p PORT option should you want to change from the default 5432.
The postmaster.opts file is just listing the options that were used to start
the currently running postmaster. It is not intended to set options, but
instead just information about the options used.
Try editing the /etc/rc.d/init.d/postgresql file instead.
Good luck.
Chris Mulcahy
(Formerly from the Toledo area and
worked with you on several occasions)
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Eric Naujock
Sent: Thursday, May 17, 2001 8:28 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Problems with getting the postmaster to startup with
-ioption.
I am using the redhat RPM installation of postgresql. I would like to be
able to use some of the IP based management tools to work with the database
and to do this I need the IP options working.
How do I get the redhat RPM installation to start up in TCP/IP mode. I have
tried to add the -I 5432 to the postmaster.opts file but the database keeps
reverting the file back to its old version without the -I option.
----------------------------------------------------------------------------
----
Eric Naujock CCNA, CCDA, A+, Network +, I-Net +
Abacus II
5610 Monroe St.
Sylvania, Ohio 43560
<http://www.abacusii.com>
E-mail - naujocke@abacusii.com
Phone - 419-885-0082 X 241
Fax : 419-885-2717
AOL IM: erlic
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--------------------------------------------------------------------------------
Eric Naujock CCNA, CCDA, A+, Network +, I-Net +
Abacus II
5610 Monroe St.
Sylvania, Ohio 43560
<http://www.abacusii.com>
E-mail - naujocke@abacusii.com
Phone - 419-885-0082 X 241
Fax : 419-885-2717
AOL IM: erlic