Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Yannick ALLUSSEDate: 2002-03-07 07:56:49
Subject: Size of the empty database
Previous:From: Faudzy SulaimanDate: 2002-03-07 03:49:41
Subject: Postmaster with -i

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group