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");
?>