Re: [ADMIN] [GENERAL] How can I set postmaster as a service

[Jean-Michel Chabanne]

shreedhar a �crit :

I already had postgresql file in /etc/rc.d/init.d.
I run the following ln commands as specified.
if I boot my system it is opening database. But failing while opening
database by remote host.
May be -i option is missing.
If I use the following line in postgresql file
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -o '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null
I could able to start database but I could not able to connect through
remost host.
If I change the option -o to -i I am getting an error while starting
database itself.
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -i '-p ${PGPORT}' start > /dev/null 2>&1" < /dev/null
How can I rectify this error.

 

-o means options.  All options follow beetween quotes.

... -o  ' -p ${PGPORT} -i ' ...

----- Original Message -----
From: "Reid Thompson" <[EMAIL PROTECTED]>
To: "shreedhar" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 11:20 PM
Subject: RE: [GENERAL] How can I set postmaster as a service
 

basically, mod the start script as necessary for your system.
cp it to /etc/init.d as postgresqlscript or whatever you want to call it
cd to /etc/rc3.d
ln -s ../init.d/postgresqlscript S95postgresql
ln -s ../init.d/postgresqlscript K94postgresql
reid

   

-----Original Message-----
From: shreedhar [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 9:31 AM
To: Postgre Admin; Reid Thompson
Subject: Re: [GENERAL] How can I set postmaster as a service
It is RHLinux 7.3.

----- Original Message -----
From: "Reid Thompson" <[EMAIL PROTECTED]>
To: "shreedhar" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 6:49 PM
Subject: RE: [GENERAL] How can I set postmaster as a service
     

what operating system

reid

       

-----Original Message-----
From: shreedhar [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 7:26 AM
To: Postgre Admin; Postgre General
Subject: [GENERAL] How can I set postmaster as a service
How can I set postmaster (database on)  as a service and set
it while system booting  if self?
Regards
Sreedhar Bhaskararaju
---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the
         

unregister command
     

   (send "unregister YourEmailAddressHere" to
[EMAIL PROTECTED])
         

     



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org

 



--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly