Re: Authentication to run pg_dump automatically
От | Neil Conway |
---|---|
Тема | Re: Authentication to run pg_dump automatically |
Дата | |
Msg-id | 1045810360.583.454.camel@tokyo обсуждение исходный текст |
Ответ на | Authentication to run pg_dump automatically ("Robert Fitzpatrick" <robert@webtent.com>) |
Ответы |
Re: Authentication to run pg_dump automatically
|
Список | pgsql-general |
On Wed, 2003-02-19 at 19:36, Robert Fitzpatrick wrote: > I would like to write a script to dump all the databases each night. The > only way I have figured out it can be done is to trust the 'postgres' > user in pg_hba.conf for local connections and run pg_dump with that user > in the script (is this safer than PGPASSWORD). > This is for a PostgreSQL v7.1 database, so I can't use .pgpass and I > don't want to use the environment variable PGPASSWORD. I believe PGPASSWORD may be secure on some platforms (I can't recall the security implications at the moment, but you might want to investigate it). Modern versions of pg_dump also have a '--use-set-session-authorization' that might be helpful -- see the 7.3 reference page for pg_dump for more info. Also, consider upgrading: 7.1 is quite old. Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
В списке pgsql-general по дате отправления: