| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | "Pedro C(dot) Arias" <parias(at)agatha(dot)unr(dot)edu(dot)ar> |
| Cc: | <pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx>, PostgreSQL-GENERAL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Tool for BackUp |
| Date: | 2003-05-23 15:49:40 |
| Message-ID: | Pine.LNX.4.33.0305230946420.27073-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda pgsql-general |
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");
?>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-05-23 16:40:59 | Re: Tool for BackUp |
| Previous Message | Martin Marques | 2003-05-23 15:22:17 | Re: [Pgsql-ayuda] Instalando lenguajes procedurales |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-05-23 15:52:56 | Re: deadlocks problem |
| Previous Message | Johann Thoyer | 2003-05-23 15:09:32 | pg_connect() |