Richard Broersma Jr wrote:
> > Okay, i've gotten far enough that i've taken backups
> > of my 8.1 db server from both 8.1's and 8.2's
> > pg_dumpall.
>
> > i had to enter my password in about 5 or 6 times,
> > which i thought was strange, but is probably due to
> > some fine grained password control that i'm not
> > familiar with.
> Ya, what happens is that you have to enter your password everytime
> pg_dumpall starts the next database. You need to update you pg_hba.conf
> to allow your user open all databases without a password. This could
> be done by your postgres os user account using sameuser or trust
> authentication. the other option is to set up a .pgpass file.
> althought this option is not recommended.
Actually, we do recommend .pgpass over changing pg_hba.conf.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +