Re: [GENERAL] PG_DUMP without asking password

2006-09-22 Thread Terry Fielder
If you run it on the same server, with a user who has permission to access the db using ident (e.g. user "postgres"), i.e. you have a pg_hba.conf entry like: local allpostgres ident sameuser Then pg_dump and pg_dumpall will not require a password. Alternatively, you can creat

Re: [GENERAL] PG_DUMP without asking password

2006-09-22 Thread Matthias . Pitzl
Title: Nachricht Hm, depends on how the security settings of the database are set. For local users you could set in the pg_hba.conf ident as authentication method. Then they won't need a password anymore. See the pg_hba.conf documentation for more infos. Another way could be to execute the d

[GENERAL] PG_DUMP without asking password

2006-09-22 Thread Alain Roger
Hi,is there a way to backup the database thanks a command script, without postgresql requesting the user password ?thanks a lot,Alain