Обсуждение: Re: [GENERAL] How can I set postmaster as a service
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. ----- Original Message ----- From: "Reid Thompson" <Reid.Thompson@ateb.com> To: "shreedhar" <shreedhar@lucidindia.net> 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:shreedhar@lucidindia.net] > > 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" <Reid.Thompson@ateb.com> > > To: "shreedhar" <shreedhar@lucidindia.net> > > 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:shreedhar@lucidindia.net] > > > > 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 > > > > majordomo@postgresql.org) > > > > > > > > > > > >
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" <Reid.Thompson@ateb.com> >To: "shreedhar" <shreedhar@lucidindia.net> >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:shreedhar@lucidindia.net] >>>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" <Reid.Thompson@ateb.com> >>>To: "shreedhar" <shreedhar@lucidindia.net> >>>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:shreedhar@lucidindia.net] >>>>>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 >>>>>majordomo@postgresql.org) >>>>> >>>>> >>>>> >>> >>> > > >---------------------------(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