Thread

1. Problems with getting the postmaster to startup with -i option.

   Eric Naujock <naujocke@abacusii.com> — 2001-05-17T13:28:21Z

   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
   
   

2. RE: Problems with getting the postmaster to startup with -ioption.

   Chris Mulcahy <cmulcahy@cmulcahy.com> — 2001-05-17T14:09:03Z

   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
   
   
   
   

3. Re: Problems with getting the postmaster to startup with -i option.

   Nabil Sayegh <evolution@sayegh.de> — 2001-05-17T14:39:09Z

   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 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. 
   > 
   
   <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