Skip site navigation (1) Skip section navigation (2)

Re: table move across databases

From: Duncan Sargeant <dunc-postgres(at)rcpt(dot)to>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: table move across databases
Date: 2002-07-25 03:57:42
Message-ID: 20020725035741.GD22945@circe.rcpt.to (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: denisDate: 2002-07-25 07:17:11
Subject: Trigger question
Previous:From: Ron JohnsonDate: 2002-07-25 00:07:52
Subject: Re: extract text and store in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group