| 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: | Whole Thread | Raw Message | 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.
| 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 |