Re: dumping strategy

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
>