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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: voipfc(at)gmail(dot)com
Cc: Frank Church <voipfc(at)googlemail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is there a way to backup Postgres via SQL commands?
Date: 2010-06-14 13:05:27
Message-ID: 4C162917.7020808@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14/06/2010 12: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, not that I'm aware of.

> 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?

What exactly are you trying to do? If you're building database backup
functionality into an application, you're better off just spawning a
sub-process with pg_dump.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Amiel 2010-06-14 13:05:53 Advice on contingency plan for DAS array with separate local WAL drives
Previous Message Alban Hertroys 2010-06-14 13:01:07 Re: Is there a way to backup Postgres via SQL commands?