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

Re: Multiple logical databases

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Mark Woodward <pgsql(at)mohawksoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Multiple logical databases
Date: 2006-02-02 15:13:30
Message-ID: 1138893210.3105.7.camel@swithin (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Thu, 2006-02-02 at 10:23 -0500, Mark Woodward wrote:
> If one db is REALLY REALLY huge and doesn't change, and a few
> others are small and change often, pg_dumpall will spend most of its time
> dumping the unchanging data.
> 

My usual backup strategy does pg_dumpall -g to get the (tiny) global
data, and then pg_dump for each individual database. Quite apart from
anything else I prefer to have custom format dumps anyway, but I think
this should meet your need for less frequent dumping of some constant
database.

cheers

andrew


In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-02-02 15:19:04
Subject: Re: Multiple logical databases
Previous:From: Kim BisgaardDate: 2006-02-02 14:35:50
Subject: Re: Question about ALTER TABLE SET TABLESPACE locing

pgsql-patches by date

Next:From: Tom LaneDate: 2006-02-02 15:19:04
Subject: Re: Multiple logical databases
Previous:From: Joachim WielandDate: 2006-02-02 09:00:15
Subject: TODO-Item: TRUNCATE ... CASCADE

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