On 2/15/2013 4:27 PM, Bruce Momjian wrote:
>
>do note this -k option only functions if the old and new cluster are on the
>same mount point, so the files can be mv'd
Actually, hard linked, not moved.
errr, that. right. ;)
--
john r pierce 37N 122W
s
On Fri, Feb 15, 2013 at 03:55:02PM -0800, John R Pierce wrote:
> On 2/15/2013 10:27 AM, Kevin Grittner wrote:
>
> You might want to try the utility which *is* supported by the
> PostgreSQL community, which is pg_upgrade. For speed, consider
> using the -k option. I've been able to up
On 2/15/2013 10:27 AM, Kevin Grittner wrote:
You might want to try the utility which*is* supported by the
PostgreSQL community, which is pg_upgrade. For speed, consider
using the -k option. I've been able to upgrade a 3 TB database in
just a few minutes with that. (Timing depends more on the
Hello,
r...@me.com [2013-02-15 17:41 +]:
> I have tried upgrading a database from 8.4 to 9.1 and pg_upgradecluster is
> terribly slow.
Please note that this is a Debian/Ubuntu specific bug,
pg_upgradecluster is not shipped by upstream PostgreSQL.
I admittedly don't have any first-hand experi
"r...@me.com" wrote:
> I have tried upgrading a database from 8.4 to 9.1 and
> pg_upgradecluster is terribly slow.
I had never heard of pg_upgradecluster sluster; a google search
suggests that there is an Ubuntu utility by that name, so you might
want to register a complaint there; this list is
The following bug has been logged on the website:
Bug reference: 7884
Logged by: Denys Rtveliashvili
Email address: r...@me.com
PostgreSQL version: 9.1.7
Operating system: Ubuntu 12.04
Description:
I have tried upgrading a database from 8.4 to 9.1 and pg_upgradecluste
