On 14 Jun 2010, at 13:28, Frank Church wrote:

> Are there SQL commands that can do a backup over a client connection,
> rather than from the command line like pgsql etc?

No.

> By that I mean some kind of SELECT commands that can retrieve the
> database's content as SQL commands that can be replayed to a server to
> restore it, rather than something that saves directly to file, or
> passes it through a pipe?


That sounds quite a bit like replicating the DB to a warm standby, is that what 
you're after? There are several solutions for that.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4c16281d286215086519202!



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to