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

From: "shreedhar" <shreedhar(at)lucidindia(dot)net>
To: "Postgre Admin" <pgsql-admin(at)postgresql(dot)org>, "Postgre General" <pgsql-general(at)postgresql(dot)org>, "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
Subject: Re: [GENERAL] How can I set postmaster as a service
Date: 2003-09-06 08:53:29
Message-ID: 008601c37454$58df9b30$1201a8c0@a4005
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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(dot)Thompson(at)ateb(dot)com>
To: "shreedhar" <shreedhar(at)lucidindia(dot)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(at)lucidindia(dot)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(dot)Thompson(at)ateb(dot)com>
> > To: "shreedhar" <shreedhar(at)lucidindia(dot)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(at)lucidindia(dot)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(at)postgresql(dot)org)
> > > >
> > >
> >
> >
>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Michel Chabanne 2003-09-06 09:09:37 Re: [GENERAL] How can I set postmaster as a service
Previous Message Mendola Gaetano 2003-09-05 21:08:54 New file system based on Postgres

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel Chabanne 2003-09-06 09:09:37 Re: [GENERAL] How can I set postmaster as a service
Previous Message Tom Lane 2003-09-06 04:11:14 Re: decrypted pwd