Dimitri Fontaine wrote:
Frank Church <voipfc@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx www.2ndQuadrant.us
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
