Обсуждение: Problems with getting the postmaster to startup with -i option.
I am using the redhat RPM installation of postgresql. I would like to be able to use some of the IP based management toolsto 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.optsfile 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
Вложения
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
On 17 May 2001 09:28:21 -0400, Eric Naujock wrote: > I am using the redhat RPM installation of postgresql. I would like to be able to use some of the IP based management toolsto 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.optsfile but the database keeps reverting the file back to its old version without the -I option. > <FLAME_BAIT> If you want to hardcode it into the rc script su -l postgres -c "PGDATESTYLE=GERMAN LANG=de_DE LANGUAGE= LC_COLLATE=POSIX LC_CTYPE= LC_MESSAGES= LC_MONETARY= LC_NUMERIC= LC_TIME= /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o \"-D /usr/local/pgsql/data -i\" start >/dev/null 2>&1" </FLAME_BAIT> cu -- Nabil Sayegh