you can launch your pg_dump via openssh
and store the output on a local file.
-> man ssh
Envex Developments wrote:
> Hey there,
>
> Quick question for you... Currently developing a software program, which
> will be distributed to many people, hence, hosted on many different servers.
> Since PostgreSQL is quite rare in the main-stream hosting business, many
> people will most likely host the PostgreSQL database on a remote server, and
> their local server won't have PostgreSQL installed.
>
> I need a backup function for the software. I've found "pg_dump", and the
> COPY statement. I would very much like to use pg_dump, as it dumps
> everything... tables, functions, sequences, triggers, ect...
>
> However, since many of the servers hosting the software won't have
> PostgreSQL installed locally, there'll be no pg_dump.
>
> Just wondering, any way around this? Is there an alternate of pg_dump,
> which can be run as SQL statement(s)?
>
> Thanks,
> Matt
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>