Re: dumping strategy - Mailing list pgsql-general

From Mitch Vincent
Subject Re: dumping strategy
Date
Msg-id 004e01c0e93a$9fded610$1251000a@Mitch
Whole thread Raw
In response to dumping strategy  (newsreader@mediaone.net)
Responses Re: dumping strategy  (newsreader@mediaone.net)
List pgsql-general
Why wouldn't pg_dump work? You can do pg_dump -t <tablename> <databasename>
to dump just a single table.... If pg_dump fails for some reason, I'd say
the developers would like to know as I'm sure it's not supposed to :-)

Good luck!

-Mitch

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: Aristide Aragon
Date:
Subject: Indexes
Next
From: newsreader@mediaone.net
Date:
Subject: Re: dumping strategy