dumping strategy

From: newsreader(at)mediaone(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: dumping strategy
Date: 2001-05-30 18:45:20
Message-ID: 20010530144520.A12004@dragon.universe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have many tables and don't want to
dump all of them. Of 30 tables
about two are really huge and I
actually don't mind losing those
tables and don't want to backup.
One of the reasons being that
I transfer the back up to another
host and wish to economize on
bandwidth.

pg_dump command cannot handle.
Ideally what I would like to
dump all but a few tables. Currently
I am dumping all but a few
tables to a directory and
then make a tar ball and then
bzip2 and transport to a machine
of my choice.

Can someone tell me a better
solution?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Aristide Aragon 2001-05-30 18:53:43 Indexes
Previous Message ak 2001-05-30 18:40:38 PostgreSQL and TPC benchmarks