postgresql.conf file help.
Hi,
I've just installed postgresql on linux and it's working on the linux
system. However I still need to set up the network connections so the other
machines on our lan can access the database.
I believe these details are set in the postgresql.conf file. Could a few
people email me a copy of this file so I can get the idea what network
settings I must set and what to set them to. Alternatively someone could
just give me a 'generic' setting of just the relevent settings.
Many thanks and regards,
Matthew
Hi,
I think you have this file:-))
Try:
ps -ax | grep post
The replay will be something like this.
/usr/bin/postmaster -D /var/lib/pgsql/data
If you cannot see the line above, you may want to start the PostgreSQL
daemon.
If you go to the /var/libpgsql/data directory you will find the file you are
loking for.
Set the tcpip_socket to true. You will find it in the "Connection
Parameters" section at the beginning of the file.
You may aslo want to check the pg_hba.conf file to set up some access rigth
for your local subnet.
Kind Regards,
Yuri
----- Original Message -----
From: "Matthew Stanfield" <matthew@propertyknowledge.com>
To: "PostgreSQL General Mailing List" <pgsql-general@postgresql.org>
Sent: Sunday, April 07, 2002 12:06 PM
Subject: [GENERAL] postgresql.conf file help.
Hi,
I've just installed postgresql on linux and it's working on the linux
system. However I still need to set up the network connections so the
other
Show quoted text
machines on our lan can access the database.
I believe these details are set in the postgresql.conf file. Could a few
people email me a copy of this file so I can get the idea what network
settings I must set and what to set them to. Alternatively someone could
just give me a 'generic' setting of just the relevent settings.Many thanks and regards,
Matthew
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster