Re: [GENERAL] Postgresql allow connections without password

2012-01-13 Thread Raymond O'Donnell
On 12/01/2012 05:16, debian nick wrote: I have postgresql 8.4.9 installed now, my problem is that from time to time my postgresql let psql version 8.4.9 access the database without asking for password (psql -d mydatabase -h myhost -U myuser), and the connection attempts from psql 8.3 are not

Re: [GENERAL] Postgresql allow connections without password [SOLVED]

2012-01-13 Thread debian nick
Thanks raymond, you were right, i never think that psql was using .pgpass file. When a delete it psql ask me for the password. THANKS I’ll never figure that out. 2012/1/13 Raymond O'Donnell r...@iol.ie On 12/01/2012 05:16, debian nick wrote: I have postgresql 8.4.9 installed now, my problem

Re: [GENERAL] Postgresql allow connections without password [SOLVED]

2012-01-13 Thread Adrian Klaver
On 01/13/2012 09:10 AM, debian nick wrote: Thanks raymond, you were right, i never think that psql was using .pgpass file. When a delete it psql ask me for the password. THANKS I’ll never figure that out. You still should check your pg_hba.conf file for trust and ident connection rules.

[GENERAL] Postgresql allow connections without password

2012-01-12 Thread debian nick
I have postgresql 8.4.9 installed now, my problem is that from time to time my postgresql let psql version 8.4.9 access the database without asking for password (psql -d mydatabase -h myhost -U myuser), and the connection attempts from psql 8.3 are not allowed no matter what i got time out

Re: [GENERAL] Postgresql allow connections without password

2012-01-12 Thread Adrian Klaver
On Wednesday, January 11, 2012 9:16:04 pm debian nick wrote: I have postgresql 8.4.9 installed now, my problem is that from time to time my postgresql let psql version 8.4.9 access the database without asking for password (psql -d mydatabase -h myhost -U myuser), and the connection attempts

Re: [GENERAL] Postgresql allow connections without password

2012-01-12 Thread Alan Hodgson
On Thursday, January 12, 2012 02:16:04 AM debian nick wrote: Any help will be really appreciate. Check your pg_hba.conf file for any entries with trust or ident. Remove them and restart the server. Also look for .pgpass files in the home directories of any user seeing this. -- Sent via