Re: remote dumping of databases - Mailing list pgsql-general

From Brent R. Matzelle
Subject Re: remote dumping of databases
Date
Msg-id 20010309213630.23438.qmail@web13002.mail.yahoo.com
Whole thread Raw
In response to remote dumping of databases  (Frank Nijenhuis <fnijen@bos.nl>)
List pgsql-general
>How ever..how do
> you get the
> content of the dump to a file??? Every pipe action will result
> in endless
> waiting, pg_dumps waits for the username/password.......
>
> Is there an solution of do I overlook something here???

Give the user who is performing the dump read access on all
tables, indices, etc on the database(s) you wish to dump.  Then
you can run a pg_dump without the password prompt coming up.

% pg_dump database_name > file.dump

Brent


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: what's going on here?
Next
From:
Date:
Subject: Re: How to use locks, for DB noivces?