Thread: Postmaster

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?

--
Laurent Mesuré
France

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

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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01

hi,
just edit /etc/postgreql/postmaster.init
and change
PGALLOWTCPIP=no to PGALLOWTCPIP=yes
that's all folks

> 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?
>
> --
> Laurent Mesuré
> France
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



PS: Si tu veux du français académique relis ta feuille d'impots.

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