On Tue, Jul 29, 2008 at 04:24:08PM -0400, Rob Richardson wrote: > him. The only answers I've found on the Internet involve creating a > password-less account and using that to run pg_dump. What is the > official best way to automatically back up a PostGres database?
using pg_dump - yes. making it's account passwordless - not necessarily. you can use various methods of getting access to database without password. you can use "ident sameuser" authentication method in pg_hba.conf. you can use pgpass file, use can use PGPASSWORD environment variable. there are also another ways, but these look the best for me. depesz -- Linked in: http://www.linkedin.com/in/depesz jid/gtalk: [EMAIL PROTECTED] aim: depeszhdl skype: depesz_hdl -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general