From: | Scott Frankel <frankel(at)circlesfx(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: sql dump |
Date: | 2010-07-26 17:19:34 |
Message-ID: | 8A431878-CDF7-4395-87CE-EFB6C0301786@circlesfx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for all the suggestions. COPY may work for my purposes. The
SSH tunnel option for using pg_dump is very interesting.
Thanks!
Scott
On Jul 26, 2010, at 9:18 AM, David Fetter wrote:
> On Mon, Jul 26, 2010 at 08:58:59AM -0700, Scott Frankel wrote:
>>
>> Hi all,
>>
>> Is it possible to perform an SQL Dump without using pg_dump?
>
> No, but there may be more options for using pg_dump than you have
> looked at. One example would be to use pg_dump on one with an SSH
> tunnel to the other one's local PostgreSQL port (5432 by default, but
> check which yours is). For example:
>
> ssh -fNR 5432:localhost:5555 postgres(at)your(dot)host(dot)dom
>
> would let you connect to localhost:5555 with pg_dump and any other
> PostgreSQL tools.
>
> Cheers,
> David.
>> I have a special case situation wherein my application has access to
>> a remotely-hosted PG (8.3) database, but does not have access to its
>> admin tools. (There's a longer backstory here that I'm happy to
>> explain if necessary.) I'm looking for an efficient way to dump all
>> the data in the DB without having to SELECT * on each table.
>>
>> Thanks in advance!
>> Scott
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
> --
> David Fetter <david(at)fetter(dot)org> http://fetter.org/
> Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
> Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
> iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
>
> Remember to vote!
> Consider donating to Postgres: http://www.postgresql.org/about/donate
>
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2010-07-26 19:15:34 | Re: Re: What to do if space for database decrease and no additional hard drive is possible? |
Previous Message | Vincenzo Romano | 2010-07-26 16:28:35 | Re: Converting BYTEA from/to BIGINT |