Dimitri Fontaine wrote:
> Frank Church <voipfc@googlemail.com> writes:
>
>> Are there SQL commands that can do a backup over a client connection,
>> rather than from the command line like pgsql etc?
>>
>
> That's pg_dump ?
>
Dimitri has correctly pointed out the flaw behind the basic assumption
being made by asking this question. You do not have to use pg_dump from
the server's command line in order to dump a database. You can install
the same PostgreSQL version on whatever system you want to do the dump
from instead, have it connect to the server as a client, and then dump
your database on that remote system. pg_dump is already a client
application that only requires a network connection to the server and
sends it a series of SQL commands.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.us