Re: Postgresql startup script on RH9

I see... However, I'm not sure where this file belongs. Should I put it
in /etc? There is a sample config file under
/usr/share/pgsql/postgresql.conf.sample, should I simply rename this
file and leave it where it is?

I can't find an actual postgresql.conf file anywhere.

Thanks again for your help.

Balazs



-----Original Message-----
From: Oliver Fromme [mailto:olli@lurza.secnetix.de]
Sent: Friday, September 19, 2003 4:27 PM
To: Balazs Wellisch
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Postgresql startup script on RH9


Moin,

Balazs Wellisch wrote:
 > Can anyone please tell me how to modify the postgresql startup script
to
 > accept TCP/IP connections? This is on a Redh Hat 9 machine running
 > Postgresql 7.3.4 RPM installation. The RPMs were compiled from the
SRPM
 > available at postgresql.org.

I would recommend not to modify that script, if possible.
Instead, you should enable the appropriate option in your
postgres.conf file:  tcpip_socket = on

For details on the configuration file, see the official docs
(look for "TCPIP_SOCKET"):
http://www.postgresql.org/docs/7.3/static/runtime-config.html

Note that you should also have a look at the pg_hba.conf
file, which controls access to databases by hosts and
usernames.

Regards
   Oliver

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

cat man du : where Unix geeks go when they die