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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general