From: | Matthias(dot)Pitzl(at)izb(dot)de |
---|---|
To: | raf(dot)news(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PG_DUMP without asking password |
Date: | 2006-09-22 12:09:42 |
Message-ID: | 11EC9A592C31034C88965C87AF18C2A70CFC66@m0000s61 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 dump script under a privileged user. For
my machines here, the user postgres can dump all databases without entering
a password.
If you backup your database via a cron job started by root, you can simply
do a su postgres -c ... to run the backupjob under user postgres.
-- Matthias
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 1:32 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] PG_DUMP without asking password
Hi,
is there a way to backup the database thanks a command script, without
postgresql requesting the user password ?
thanks a lot,
Alain
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Sabino Mullane | 2006-09-22 14:24:51 | Re: Majordomo drops multi-line Subject: |
Previous Message | Terry Fielder | 2006-09-22 11:44:14 | Re: PG_DUMP without asking password |