pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Duplicating a large database.
2+ messages / 2 participants
[nested] [flat]

* Duplicating a large database.
@ 2004-10-06 00:26  Dan Hrabarchuk <dan@kwasar.biz>
  0 siblings, 1 reply; 2+ messages in thread

From: Dan Hrabarchuk @ 2004-10-06 00:26 UTC (permalink / raw)
  To: pgsql-admin

I need to move a large database to new machine. I'd also like to upgrade
my postgres server from 7.3 to 7.4 (at least).

My plan is to set up a query log on my current postgres server. Then I
will make a copy of the database using pg_dump. When the dump is done I
will to shut down the original server, then run the query log on the new
server. This should bring up to date, and reduce the space used.
(Vacuuming is to way too slow).

I've been trying to find the "query logger" portion of the plan. I've
found mini-projects like taillog
(http://gborg.postgresql.org/project/tablelog/projdisplay.php) but these
over complicate what I want. I simply want to reply all the inserts,
updates and deletes that happen on the orignal server while the new
server is dumping/restoring.

What can I use? A text file that I can pipe into psql would be AWESOME!
Any ideas? Any half finished projects that I can complete (or at least
get working enough :)?

Thanks for the help

Dan Hrabarchuk




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Duplicating a large database.
@ 2004-10-06 04:05  Robert Creager <Robert_Creager@LogicalChaos.org>
  parent: Dan Hrabarchuk <dan@kwasar.biz>
  0 siblings, 0 replies; 2+ messages in thread

From: Robert Creager @ 2004-10-06 04:05 UTC (permalink / raw)
  To: Dan Hrabarchuk <dan@kwasar.biz>; +Cc: pgsql-admin

When grilled further on (Tue, 05 Oct 2004 17:26:16 -0700),
Dan Hrabarchuk <dan@kwasar.biz> confessed:

> I need to move a large database to new machine. I'd also like to upgrade
> my postgres server from 7.3 to 7.4 (at least).
> 

I think Slony (http://www.slony.org) will do exactly what you desire...

Cheers,
Rob
-- 
 22:05:07 up 13 days, 31 min,  2 users,  load average: 3.26, 3.97, 3.95
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-10-06 04:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-06 00:26 Duplicating a large database. Dan Hrabarchuk <dan@kwasar.biz>
2004-10-06 04:05 ` Robert Creager <Robert_Creager@LogicalChaos.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox