Re: remote dumping of databases

>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/