Re: Upgrade Backup Issue

[Bruce Momjian <bruce(at)momjian(dot)us>]

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(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +