Re: Postmaster with -i

From: Chris <csmith(at)squiz(dot)net>
To: Faudzy Sulaiman <faudzy(at)um(dot)edu(dot)my>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postmaster with -i
Date: 2002-03-07 04:00:11
Message-ID: 5.1.0.14.0.20020307145539.025e8b90@cooee.cybersydney.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

>How to run Postmaster with the -i option to allow remote connections?

If you're running v7.2, in the $PGDATA/postgresql.conf file (usually either
/usr/local/pgsql/data or /var/lib/pgsql/data), there's a line with:

tcpip_socket = false

change the false to true, restart postgresql and away you go :)

If you have an older version, you'll have to edit the startup script, and
change it to something like:

pg_ctl -D $PGDATA -p /usr/bin/postmaster start -o "-i"

(I think that's right, I use the first way so I'm guessing a little bit).

HTH,

Chris.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Yannick ALLUSSE 2002-03-07 07:56:49 Size of the empty database
Previous Message Faudzy Sulaiman 2002-03-07 03:49:41 Postmaster with -i