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

Dimitri Fontaine wrote:
> Frank Church <voipfc(at)googlemail(dot)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(at)2ndQuadrant(dot)com www.2ndQuadrant.us