-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 27 Feb 2008 18:26:54 -0800 "Tena Sakai" <tsakai@xxxxxxxxxxxxxx> wrote: > But in the meantime, maybe I will take a > bit different approach. Namely: > > Is there anyway I can pass the password to > pg_dumpall via crontab? You can use a pgpass file as the user calling the cron. http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html Or you can use PGPASSWORD="foo" But that can be dangerous. Joshua D. Drake - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHxh2tATb/zqfZUUQRAoTWAKCD7dgA5pSlDcu3xTWvei4K/KFqxACfQbVq dJvLDR1LKM6yt2RyewQfNQI= =y55x -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
