Re: [ADMIN] Problem with .pgpass

2009-05-19 Thread Nicolas Michel
There was indeed a blank after the line (after the password)... ^^ To Scott : yes, I set the file with 0600 permissions ;) Thank you very much for your help. Le lundi 18 mai 2009 à 11:59 -0400, Tom Lane a écrit : > Nicolas Michel writes: > > I tried to put my password in a .pgpass file into th

Re: [ADMIN] Problem with .pgpass

2009-05-18 Thread Scott Mead
> > > > > I tried to put my password in a .pgpass file into the home directory of > > the root user (so /root/.pgpass). Here is a cat of that file : > > *:*:*:*:test > > > >psql: FATAL: authentification par mot de passe choue pour > ... > > When prompt for a password, I enter 'test' and it

Re: [ADMIN] Problem with .pgpass

2009-05-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I tried to put my password in a .pgpass file into the home directory of > the root user (so /root/.pgpass). Here is a cat of that file : > *:*:*:*:test > >psql: FATAL: authentification par mot de passe choue pour ... > When prompt for

Re: [ADMIN] Problem with .pgpass

2009-05-18 Thread Tom Lane
Nicolas Michel writes: > I tried to put my password in a .pgpass file into the home directory of > the root user (so /root/.pgpass). Here is a cat of that file : > *:*:*:*:test > (I tried only with stars to be sure my rule was not too strict). > So, il I try this command : > r...@pc:~ #

[ADMIN] Problem with .pgpass

2009-05-18 Thread Nicolas Michel
Hi here, I'm trying to make my dump script working but it is not. I tried to put my password in a .pgpass file into the home directory of the root user (so /root/.pgpass). Here is a cat of that file : *:*:*:*:test (I tried only with stars to be sure my rule was not too strict). So, il I try thi