Thread: postgresql.conf file help.

postgresql.conf file help.

From
Matthew Stanfield
Date:
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

Re: postgresql.conf file help.

From
"Gyorgy Molnar"
Date:
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
> 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