Re: remote dumping of databases

On 3/6/01, 8:55:05 AM, Frank Nijenhuis <fnijen@bos.nl> wrote regarding
[GENERAL] remote dumping of databases:

[snip]
> Now I want them to be able to dump their own database. And when I use the
> command without piping the result to a file everything works.
> (pg_dump -h <remote pgsqlserver) -u <dbname>.
> You get the user prompt and password prompt..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???

You could look at wrapping pg_dump in something like "expect" or "chat"
which are designed to deal with interactive programs. You might find
useful examples relating to changing passwords since passwd has a similar
problem.

- Richard Huxton