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

Re: Pg_upgrade speed for many tables

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Pg_upgrade speed for many tables
Date: 2012-11-06 02:37:30
Message-ID: 509877EA.8090702@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On 11/05/2012 08:52 PM, Bruce Momjian wrote:
> On Mon, Nov  5, 2012 at 05:39:40PM -0800, Josh Berkus wrote:
>>> Sorry, I should've said psql --single-transaction.  Although that isn't
>>> going to work either given the presence of \connect commands in the
>>> script.  I wonder whether pg_dumpall ought to have some sort of "one
>>> transaction per database please" option.
>> pg_dumpall ought to support -Fc output ...
> That is already a TODO:
>
> 	Add pg_dumpall custom format dumps?


That '?' isn't an accident. Custom format is currently inherently 
single-database. Unless you're going to make pg_dumpall produce multiple 
custom format archives, that would involve a major change that nobody 
has designed AFAIK.


cheers

andrew


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2012-11-06 03:11:56
Subject: Re: Logical to physical page mapping
Previous:From: Bruce MomjianDate: 2012-11-06 01:52:13
Subject: Re: Pg_upgrade speed for many tables

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