Re: PG_DUMP without asking password
| От | Matthias.Pitzl@izb.de |
|---|---|
| Тема | Re: PG_DUMP without asking password |
| Дата | |
| Msg-id | 11EC9A592C31034C88965C87AF18C2A70CFC66@m0000s61 обсуждение исходный текст |
| Ответ на | PG_DUMP without asking password ("Alain Roger" <raf.news@gmail.com>) |
| Список | 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-----Hi,
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Alain Roger
Sent: Friday, September 22, 2006 1:32 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PG_DUMP without asking password
is there a way to backup the database thanks a command script, without postgresql requesting the user password ?
thanks a lot,
Alain
В списке pgsql-general по дате отправления: