remote dumping of databases - Mailing list pgsql-general

From Frank Nijenhuis
Subject remote dumping of databases
Date
Msg-id Pine.LNX.4.10.10103060950250.7940-100000@wnet.bos.nl
Whole thread Raw
Responses Re: remote dumping of databases  (dev@archonet.com)
Re: remote dumping of databases  ("Brent R. Matzelle" <bmatzelle@yahoo.com>)
List pgsql-general
hi,
got a question, i tried to find my answer in the documentation and mailing
list archives, till now with no luck.
I've got multiple virtuale webservers with customers using a remote pgsql
server where they don't have access to.
All access is done with clients and scripting languages from the
webserver.
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???


bye

Frank



pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: max(field) vs select field .. order by desc limit 1
Next
From: Renaud Tthonnart
Date:
Subject: Re: libpq++ : Disconnect a DB