[Desktop-packages] [Bug 920892] Re: pg_upgrade does not work with clusters created with Debian/Ubuntu tools
Current postgresql-common versions support pg_upgrade now (pg_upgradecluster --method upgrade). ** Changed in: postgresql-common (Ubuntu) Status: Fix Committed = Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/920892 Title: pg_upgrade does not work with clusters created with Debian/Ubuntu tools Status in “postgresql-common” package in Ubuntu: Fix Released Status in “postgresql-9.1” package in Debian: Fix Released Bug description: pg_upgrade is now the preferred mechanism for doing database major revision upgrades, and has been around for several major revisions. It allows major revision upgrades to take minutes, instead of hours or days for larger databases required by the traditional dump/restore process. The existing Debian pg_upgradecluster tool uses the traditional dump/restore process. Under Debian and Ubuntu, database clusters created using pg_createcluster put the configuration files in a non-standard location (from PostgreSQL's perspective), and the pg_upgrade tool provides no mechanism for specifying where this is. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: postgresql-9.1 9.1.2-0ubuntu0.11.10.2 ProcVersionSignature: Ubuntu 3.0.0-12.20-generic 3.0.4 Uname: Linux 3.0.0-12-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 1.23-0ubuntu4 Architecture: amd64 Date: Tue Jan 24 17:01:08 2012 ProcEnviron: LANGUAGE=en_AU:en PATH=(custom, user) LANG=en_AU.UTF-8 SHELL=/bin/bash SourcePackage: postgresql-9.1 UpgradeStatus: Upgraded to oneiric on 2011-11-11 (73 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/920892/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 920892] Re: pg_upgrade does not work with clusters created with Debian/Ubuntu tools
** Changed in: postgresql-9.1 (Debian) Status: New = Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/920892 Title: pg_upgrade does not work with clusters created with Debian/Ubuntu tools Status in “postgresql-common” package in Ubuntu: Fix Committed Status in “postgresql-9.1” package in Debian: Fix Released Bug description: pg_upgrade is now the preferred mechanism for doing database major revision upgrades, and has been around for several major revisions. It allows major revision upgrades to take minutes, instead of hours or days for larger databases required by the traditional dump/restore process. The existing Debian pg_upgradecluster tool uses the traditional dump/restore process. Under Debian and Ubuntu, database clusters created using pg_createcluster put the configuration files in a non-standard location (from PostgreSQL's perspective), and the pg_upgrade tool provides no mechanism for specifying where this is. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: postgresql-9.1 9.1.2-0ubuntu0.11.10.2 ProcVersionSignature: Ubuntu 3.0.0-12.20-generic 3.0.4 Uname: Linux 3.0.0-12-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 1.23-0ubuntu4 Architecture: amd64 Date: Tue Jan 24 17:01:08 2012 ProcEnviron: LANGUAGE=en_AU:en PATH=(custom, user) LANG=en_AU.UTF-8 SHELL=/bin/bash SourcePackage: postgresql-9.1 UpgradeStatus: Upgraded to oneiric on 2011-11-11 (73 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/920892/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 920892] Re: pg_upgrade does not work with clusters created with Debian/Ubuntu tools
Support for pg_upgrade recently landed in pg_upgradecluster. That won't go into raring any more, but will be available in raring+1, plus the PostgreSQL backports PPA. ** Package changed: postgresql-9.1 (Ubuntu) = postgresql-common (Ubuntu) ** Changed in: postgresql-common (Ubuntu) Status: Triaged = Fix Committed -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-common in Ubuntu. https://bugs.launchpad.net/bugs/920892 Title: pg_upgrade does not work with clusters created with Debian/Ubuntu tools Status in “postgresql-common” package in Ubuntu: Fix Committed Status in “postgresql-9.1” package in Debian: New Bug description: pg_upgrade is now the preferred mechanism for doing database major revision upgrades, and has been around for several major revisions. It allows major revision upgrades to take minutes, instead of hours or days for larger databases required by the traditional dump/restore process. The existing Debian pg_upgradecluster tool uses the traditional dump/restore process. Under Debian and Ubuntu, database clusters created using pg_createcluster put the configuration files in a non-standard location (from PostgreSQL's perspective), and the pg_upgrade tool provides no mechanism for specifying where this is. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: postgresql-9.1 9.1.2-0ubuntu0.11.10.2 ProcVersionSignature: Ubuntu 3.0.0-12.20-generic 3.0.4 Uname: Linux 3.0.0-12-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 1.23-0ubuntu4 Architecture: amd64 Date: Tue Jan 24 17:01:08 2012 ProcEnviron: LANGUAGE=en_AU:en PATH=(custom, user) LANG=en_AU.UTF-8 SHELL=/bin/bash SourcePackage: postgresql-9.1 UpgradeStatus: Upgraded to oneiric on 2011-11-11 (73 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/920892/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 920892] Re: pg_upgrade does not work with clusters created with Debian/Ubuntu tools
I've written a tutorial on PostgreSQL wiki for using pg_upgrade on Ubuntu, including the symlink trick: https://wiki.postgresql.org/index.php?title=Using_pg_upgrade_on_Ubuntu/Debian -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-9.1 in Ubuntu. https://bugs.launchpad.net/bugs/920892 Title: pg_upgrade does not work with clusters created with Debian/Ubuntu tools Status in “postgresql-9.1” package in Ubuntu: Triaged Status in “postgresql-9.1” package in Debian: New Bug description: pg_upgrade is now the preferred mechanism for doing database major revision upgrades, and has been around for several major revisions. It allows major revision upgrades to take minutes, instead of hours or days for larger databases required by the traditional dump/restore process. The existing Debian pg_upgradecluster tool uses the traditional dump/restore process. Under Debian and Ubuntu, database clusters created using pg_createcluster put the configuration files in a non-standard location (from PostgreSQL's perspective), and the pg_upgrade tool provides no mechanism for specifying where this is. ProblemType: Bug DistroRelease: Ubuntu 11.10 Package: postgresql-9.1 9.1.2-0ubuntu0.11.10.2 ProcVersionSignature: Ubuntu 3.0.0-12.20-generic 3.0.4 Uname: Linux 3.0.0-12-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 1.23-0ubuntu4 Architecture: amd64 Date: Tue Jan 24 17:01:08 2012 ProcEnviron: LANGUAGE=en_AU:en PATH=(custom, user) LANG=en_AU.UTF-8 SHELL=/bin/bash SourcePackage: postgresql-9.1 UpgradeStatus: Upgraded to oneiric on 2011-11-11 (73 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/920892/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
