LinuxSA Mailing list archives

  From: Jarrod Sayers <Jarrod.Sayers@unisa.edu.au>
  To  : Daryl Tester <Daryl.Tester@iocane.com.au>
  Date: Wed, 01 Jan 2003 14:44:47 +1030 (CST)

Re:

On Wed, 1 Jan 2003, Daryl Tester wrote:

[snip]

> Having said that, is -I the correct option?  I'm unsure which version
> of Postgres you're using, but for 7.1.3 it looks like "-i" to enable
> TCP operation (after also modifying the pg_hba.conf file).

Daryl is correct, its -i, not -I.

Check ~pgsql/data/postgresql.conf.  The default for tcpip_socket is false.
Change it to true and set virtual_host to 'localhost' so 5432 isn't bound
to an external interface (unless thats what you want).  You should also
edit the default pg_hba.conf as it trusts all TCP localhost connections.

Thats how we do it :)  I don't think its a FreeBSD'ism so it should work
the same way on Linux.

J.

Jarrod Sayers
Information Strategy and Technology Services
University of South Australia
Phone: +61 8 8302 4809

"There are only 10 types of people in the world:
 Those who understand binary, and those who don't"




-- 
LinuxSA WWW: http://www.linuxsa.org.au/ IRC: #linuxsa on irc.openprojects.net
To unsubscribe from the LinuxSA list:
  mail linuxsa-request@linuxsa.org.au with "unsubscribe" as the subject