I have come across 3 files that need to be configured so far:
pg_hba.conf
postmaster.opts
postgresql.conf
Are there any other ones? What should be changed on these?
thanks.
Joel
P.S. I am a real newbie. thank you very much for your help.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Joel Lopez
Sent: Wednesday, February 12, 2003 9:31 AM
To: [EMAIL PROTECTED]
Subject: RE: PHP and PostgreSQL
I don't have a data/postgresql.conf file.
But I do have a /usr/share/pgsql/postgresql.conf.sample file.
should I copy and rename this file with out the .sample or should I place a copy in a
/data directory somewhere?
thanks.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Marius Andreiana
Sent: Wednesday, February 12, 2003 9:16 AM
To: redhat-list
Subject: Re: PHP and PostgreSQL
On Mi, 2003-02-12 at 18:50, Joel Lopez wrote:
> Hi,
>
> I have installed Red Hat 8. I have been trying to use PostgreSQL with PHP
> but I can't seem to connect to the DB.
for all db admin tasks login as the user postgres, don't use root.
Don't set a password for postgres ( the default doesn't allow login ),
use root to become postgres: su - postgres
Now, logged in as postgres, edit data/postgresql.conf and change
#tcpip_socket = false
to
tcpip_socket = true
You may need to change data/pg_hba.conf too.
When creating users ( postgres: createuser username ), I allow them to
create databases, and then I create what I need with that user so he's
the owner of db, not postgres.
--
SoluĊ£ii informatice bazate pe Linux / Linux-based IT solutions
www.galuna.ro
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list