Re: fine tuned database dump/reload?

From: Doug Bloebaum <blabes(at)gmail(dot)com>
To: Bricklen Anderson <BAnderson(at)presinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: fine tuned database dump/reload?
Date: 2005-10-11 18:37:39
Message-ID: caa2de8a0510111137p5331d33ek544bd3e7a79fd27a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/11/05, Dan Armbrust wrote::
>
> > Now I'm just filling the mailing list with mis-information. It actually
> > ignores all but the last -t flag - so this only allows me to specify one
> > table at a time, rather than several tables.

There's always the low-tech option of:

for table in `cat /tmp/table_list.txt`
do
pg_dump -t $table my_db >> /tmp/my_tables.dmp
done

It's far from elegant, but it does allow you to dump a specific list of
tables.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-11 18:39:24 Re: user privilages for executing pg_autovacuum?
Previous Message Dan Armbrust 2005-10-11 18:33:25 Re: fine tuned database dump/reload?