Postgres Pro
Downloads
Home   >   mailing lists

Thread: Tool for BackUp

Tool for BackUp

From
"Pedro C. Arias"
Date:
Hello, anybody know a tool to backup/restore remotely a Postgres database
like SQL Server, sorry for the comparasion.

Saludos
Pedro.

Re: Tool for BackUp

From
Richard Huxton
Date:
On Friday 16 May 2003 1:58 pm, Pedro C. Arias wrote:
> Hello, anybody know a tool to backup/restore remotely a Postgres database
> like SQL Server, sorry for the comparasion.

I just ssh to the server and run pg_dump. You could automate this if it's
something you do regularly, or have I misunderstood your question?
--
  Richard Huxton

Re: Tool for BackUp

From
"scott.marlowe"
Date:
On Fri, 16 May 2003, Pedro C. Arias wrote:

> Hello, anybody know a tool to backup/restore remotely a Postgres database
> like SQL Server, sorry for the comparasion.

pg_dump works a charm, as long as you can get to the port.  If you can
only get web access remotely, maybe ftp, then you could set up a
CGI/mod_perl/mod_php script that basically sends a text/plain header then
passes thru the output from pg_dump.

In PHP: (Note this script needs to have NO spaces or blank lines before
the opening <?php tag...

<?php
header("content-type: text/plain");
passthru("/usr/local/pgsql/bin/pg_dump dbname");
?>

Re: Tool for BackUp

From
Andrew Sullivan
Date:
On Fri, May 16, 2003 at 09:58:35AM -0300, Pedro C. Arias wrote:
> Hello, anybody know a tool to backup/restore remotely a Postgres database
> like SQL Server, sorry for the comparasion.

Use pg_dump.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110