remote dumping of databases

From: Frank Nijenhuis <fnijen(at)bos(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: remote dumping of databases
Date: 2001-03-06 08:55:05
Message-ID: Pine.LNX.4.10.10103060950250.7940-100000@wnet.bos.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Renaud Tthonnart 2001-03-06 09:28:40 Re: libpq++ : Disconnect a DB
Previous Message Renaud Tthonnart 2001-03-06 08:21:48 libpq++ : Disconnect a DB