Moving a PostgreSQL database from one server to another

Scot L. Harris webid at cfl.rr.com
Fri Jan 14 20:40:46 UTC 2005


On Fri, 2005-01-14 at 10:19, Rodolfo J. Paiz wrote:
> On Thu, 2005-01-13 at 18:59 -0500, Scot L. Harris wrote:
> > Since pg_dumpall reads tables from all databases you will  most  likely
> > have  to connect as a database superuser in order to produce a complete 
> > dump. 
> 
> I think you would be correct. However, in this case I'm only trying to
> dump *one* database with "pg_dump". The user owns the database, so
> permissions should not be a problem.
> 
> Note that the database does have a password on it (which I need to
> change and don't yet know how, but that's another issue). When I use
> psql to access the database manually, I am prompted for a password; but
> pg_dump does not prompt me for the password, even if I add the "-W"
> parameter to force it. Could this have something to do with the problem?

That sounds like a good place to start.  If you don't have permissions
then it probably won't run.

-- 
Scot L. Harris
webid at cfl.rr.com

A witty saying proves nothing, but saying something pointless gets
people's attention. 




More information about the users mailing list