Re: table move across databases

Andrew McMillan wrote on Tue July 23, at 20:49 +1200:
> What I do myself for a similar situation, is to:
>
> This gives me a separate table with the old records. I can then use
> pg_dump ... -t archive_YYMMDD to dump that table out, and finally drop
> it.
>
> I do this before the table gets too much in it, so that vacuuming it out
> is less of an issue, although that will be much less problematic when I
> upgrade to 7.2 in the next month or so.
>
> I hope this gives you some ideas,

Thanks Andrew, it does. Although it does frustrate me not being able
to keep the archived data online without copying all the data twice. At
least I get a backup out of one of them.

,dunc