Re: How can I backup database from database itself - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: How can I backup database from database itself
Date
Msg-id 20040624175657.GB32506@wolff.to
Whole thread Raw
In response to How can I backup database from database itself  (Dragan Matic <mlists@panforma.co.yu>)
List pgsql-admin
On Thu, Jun 24, 2004 at 13:56:58 +0200,
  Dragan Matic <mlists@panforma.co.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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Database, Table Names are resulting in lowercase
Next
From: "Eduardo S. Fontanetti"
Date:
Subject: Insert binary data on postgre