Skip site navigation (1) Skip section navigation (2)

Re: How can I backup database from database itself

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dragan Matic <mlists(at)panforma(dot)co(dot)yu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How can I backup database from database itself
Date: 2004-06-24 17:56:57
Message-ID: 20040624175657.GB32506@wolff.to (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Jun 24, 2004 at 13:56:58 +0200,
  Dragan Matic <mlists(at)panforma(dot)co(dot)yu> wrote:
> Is there a way to backup a database by issuing an SQL statement from the 
> database?
> I would like user to be able to create a backup from database itself, 
> and not by telnetting to server and typing 'pg_dump' or 'pg_dumpall'.
> Tnx in advance

They don't have to telnet to the server to run pg_dump or pg_dumpall.
Those can be run from their machine. (Though they should be running a
version as least as recent as the server version.) Take a look at the
man page, in particular the -h option.

In response to

pgsql-admin by date

Next:From: Eduardo S. FontanettiDate: 2004-06-24 19:16:40
Subject: Insert binary data on postgre
Previous:From: Tom LaneDate: 2004-06-24 15:21:55
Subject: Re: Database, Table Names are resulting in lowercase

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group