Skip site navigation (1) Skip section navigation (2)

Re: Upgrade Backup Issue

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 (view raw or flat)
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. +

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-12-15 05:39:36
Subject: Re: Upgrade Backup Issue
Previous:From: Richard Broersma JrDate: 2006-12-15 02:30:22
Subject: Re: Upgrade Backup Issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group