Postgres Pro
Downloads
Home   >   mailing lists

Thread: How can I set postmaster as a service

How can I set postmaster as a service

From
"shreedhar"
Date:
How can I set postmaster (database on)  as a service and set it while system
booting  if self?

Regards
Sreedhar Bhaskararaju

Re: How can I set postmaster as a service

From
Jeffrey Melloy
Date:
shreedhar wrote:

>How can I set postmaster (database on)  as a service and set it while system
>booting  if self?
>
>
>
What operating system are you using?
Jeff

Re: How can I set postmaster as a service

From
"Darko Prenosil"
Date:
----- Original Message -----
From: "Jeffrey Melloy" <jmelloy@visualdistortion.org>
To: "shreedhar" <shreedhar@lucidindia.net>
Cc: "Postgre Admin" <pgsql-admin@postgresql.org>; "Postgre General"
<pgsql-general@postgresql.org>
Sent: Friday, September 05, 2003 7:32 PM
Subject: Re: [GENERAL] How can I set postmaster as a service


> shreedhar wrote:
>
> >How can I set postmaster (database on)  as a service and set it while
system
> >booting  if self?
> >
> >
> >
If this is linux, there is startup script in contrib dir. Copy the script to
/etc/init.d or something similar, depending on linux distribution, and do
the setup to activate postgres service on boot.

Regards !

Re: How can I set postmaster as a service

From
"shreedhar"
Date:
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)
> > > >
> > >
> >
> >
>

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

From
Jean-Michel Chabanne
Date:
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

Re: How can I set postmaster as a service

From
"Darko Prenosil"
Date:
----- Original Message -----
From: "shreedhar" <shreedhar@lucidindia.net>
To: "Postgre Admin" <pgsql-admin@postgresql.org>; "Postgre General"
<pgsql-general@postgresql.org>; "Reid Thompson" <Reid.Thompson@ateb.com>
Sent: Saturday, September 06, 2003 10:53 AM
Subject: 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.
>
You do not need to change startup script, becuause there is option for
enabling tcp/ip in the postgresql configuration file.

Regards !

Re: How can I set postmaster as a service

From
Paul Thomas
Date:
On 06/09/2003 09:53 shreedhar wrote:
> 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.


su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster '-p ${PGPORT}' start -o \" -i \" > /dev/null 2>&1" <
/dev/null

or in postgresql.conf

tcpip_socket = true


HTH


--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+