Обсуждение: PostgreSQL backup script

I want to make a backupscript that uses pg_dump, but if do a:

pg_dump test > test.dmp

It gives me:

Connection to database 'test' failed.
fe_sendauth: no password supplied

What am I missing here, I need this to work without passwords, so it can
work automatic in my script?

Med venlig hilsen/Best regards
Søren Neigaard
System Architect
................................
Mobilethink A/S
Arosgaarden
Åboulevarden 23, 4.sal
DK - 8000 Århus C
Telefon: +45 86207800
Direct: +45 86207810
Fax: +45 86207801
Email: s.neigaard@mobilethink.dk
Web: www.mobilethink.dk
................................

=?iso-8859-1?Q?S=F8ren_Neigaard?= <s.neigaard@mobilethink.dk> writes:
> I need this to work without passwords

Then don't use a password-based authentication mechanism.
If you are on an OS that supports IDENT over Unix-socket connections,
that's often a pretty good alternative for verifying local connections.

If you are on PG 7.3 you could also consider keeping passwords in
~/.pgpass.

            regards, tom lane