From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
Cc: | operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Upgrade Backup Issue |
Date: | 2006-12-15 02:37:03 |
Message-ID: | 200612150237.kBF2b3X22537@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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. +
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-12-15 05:39:36 | Re: Upgrade Backup Issue |
Previous Message | Richard Broersma Jr | 2006-12-15 02:30:22 | Re: Upgrade Backup Issue |