SQL alternative to pg_dump
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
On Wed, 2002-12-18 at 01:19, Envex Developments wrote:
However, since many of the servers hosting the software won't have
PostgreSQL installed locally, there'll be no pg_dump.
You can use pg_dump to dump a remote database; on the machine you're
running pg_dump from, you'll need to install libpq and pg_dump, but not
the rest of PostgreSQL.
Is there an alternate of pg_dump, which can be run as SQL statement(s)?
Not AFAIK.
Cheers,
Neil
you can launch your pg_dump via openssh
and store the output on a local file.
-> man ssh
Envex Developments wrote:
Show quoted text
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)