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
