Re: Postmaster

Started by Nils Zonneveldover 24 years ago3 messagesgeneral
Jump to latest
#1Nils Zonneveld
nils@mbit.nl

Laurent Mesur� wrote:

hi,

i'd like to start at boot the postmaster.

Actually it does that, but it start without the -i option and thus, i
can't connect via TCP/IP

What do i have to modify so the pg_ctl can start the postmaster with
this option at boot?

From pg_ctl --help:

Options for start or restart:
-o OPTIONS Command line options to pass to the postmaster
(PostgreSQL server executable)

So you can use -o to pass options such as -i to the postmaster.

But I advise you to take a look at
[/usr/src/]postgresql-7.1.2/contrib/start-scripts.

Regards,

Nils

--
Alles van waarde is weerloos
Lucebert

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Nils Zonneveld (#1)

Laurent Mesur� writes:

i'd like to start at boot the postmaster.
Actually it does that, but it start without the -i option and thus, i
can't connect via TCP/IP
What do i have to modify so the pg_ctl can start the postmaster with
this option at boot?

Edit postgresql.conf and set tcpip_socket = on.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

#3Ryan Mahoney
ryan@paymentalliance.net
In reply to: Peter Eisentraut (#2)

At 09:00 PM 7/16/01 -0400, Laurent Mesuré wrote:

Actually it does that, but it start without the -i option and thus, i
can't connect via TCP/IP

What do i have to modify so the pg_ctl can start the postmaster with
this option at boot?

I think the easiest way is to edit your postgresql.conf file (usually
located in /usr/local/pgsql/data/postgresql.conf). Your Connection
Parameters section should read like this:

#
# Connection Parameters
#
tcpip_socket = true
#ssl = false

Good Luck!

-Ryan Mahoney