Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL alternative to pg_dump

SQL alternative to pg_dump

From
"Envex Developments"
Date:
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

Re: SQL alternative to pg_dump

From
Neil Conway
Date:
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

Re: SQL alternative to pg_dump

From
frbn
Date:
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)
>