Quick Links

Is there a way to backup Postgres via SQL commands?

From:	Frank Church <voipfc(at)googlemail(dot)com>
To:	pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject:	Is there a way to backup Postgres via SQL commands?
Date:	2010-06-14 11:28:13
Message-ID:	AANLkTikBwG1-QssyJUOhtw2BxBYYkue40IleJKttBemj@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

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?

/voipfc

Responses

Re: Is there a way to backup Postgres via SQL commands? at 2010-06-14 11:42:51 from A. Kretschmer
Re: Is there a way to backup Postgres via SQL commands? at 2010-06-14 13:01:07 from Alban Hertroys
Re: Is there a way to backup Postgres via SQL commands? at 2010-06-14 13:05:27 from Raymond O'Donnell
Re: Is there a way to backup Postgres via SQL commands? at 2010-06-14 15:29:09 from Merlin Moncure
Re: Is there a way to backup Postgres via SQL commands? at 2010-06-15 13:46:36 from Dimitri Fontaine

Browse pgsql-general by date

	From	Date	Subject
Next Message	A. Kretschmer	2010-06-14 11:42:51	Re: Is there a way to backup Postgres via SQL commands?
Previous Message	Alban Hertroys	2010-06-14 10:45:39	Re: How to show the current schema or search path in the psql PROMP