[GENERAL] pg_connect troubles on localhost

using postgresql 8.1 on Ubuntu Breezy I cannot connect to a database I created - checking \du the username is listed. I also created a password with #ALTER ROLE WITH PASSWORD '' I tried without password but it calls for a password. Any ideas? Warning: pg_connect() [function.pg-co

Re: [GENERAL] pg_connect troubles on localhost

start over if I need to. Any ideas ? Jerry Sievers wrote: John Taber <[EMAIL PROTECTED]> writes: using postgresql 8.1 on Ubuntu Breezy I cannot connect to a database I created - checking \du the username is listed. I also created a password with #ALTER ROLE WITH PASSWORD &#

Re: [GENERAL] pg_connect troubles on localhost

Hmmm, I have no idea what the Apache daemon user is(root?) but not sure how to check. So what would be the workaround ? Should I setup users as different from OS user names ? Tom Lane wrote: John Taber <[EMAIL PROTECTED]> writes: # TYPE DATABASEUSERCIDR-A

[GENERAL] php + postgresql pg_connect problem

I am having trouble connecting php(5.1.1) and postgresql(8.1) running on Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and a database (tempdb). If I run psql -l it shows the database "tempdb" with the username "tempuser". But I get the following error using pg_connect: Wa

Re: [GENERAL] php + postgresql pg_connect problem

Richard Huxton wrote: John Taber wrote: I am having trouble connecting php(5.1.1) and postgresql(8.1) running on Ubuntu Breezy. Both run fine separately. I created a user (tempuser) and a database (tempdb). If I run psql -l it shows the database "tempdb" with the username "te