Re: Is there a way to backup Postgres via SQL commands?

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