How to use pg_upgrade for beta versions
От | René Leonhardt |
---|---|
Тема | How to use pg_upgrade for beta versions |
Дата | |
Msg-id | 53D3C18E.6050509@gmail.com обсуждение исходный текст |
Ответы |
Re: How to use pg_upgrade for beta versions
|
Список | pgsql-general |
It has been recommended to pg_upgrade from 9.4 beta 1 to 2: http://www.postgresql.org/message-id/20e710fd3e4790ee1051aa1e107d3708@postgresql.org How do I that on the Ubuntu 14.04.1 PPA? http://www.postgresql.org/download/linux/ubuntu/ Upgrading directly is not possible: $ sudo apt-get dist-upgrade Preparing to unpack .../postgresql-9.4_9.4~beta2-1.pgdg14.04+1_amd64.deb ... ERROR: The database format changed between beta 1 and 2. Please dump your 9.4 clusters first and remove them before upgrading the package. dpkg: error processing archive /var/cache/apt/archives/postgresql-9.4_9.4~beta2-1.pgdg14.04+1_amd64.deb (--unpack): subprocess new pre-installation script returned error exit status 1 Errors were encountered while processing: /var/cache/apt/archives/postgresql-9.4_9.4~beta2-1.pgdg14.04+1_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1) Executing apt-get install -f afterwards shows the same error. At least I am able to upgrade/install postgresql-contrib-9.4 (9.4~beta2-1.pgdg14.04+1), which gives me following tools: $ ls -1 /usr/lib/postgresql/9.4/bin/ clusterdb createdb createlang createuser dropdb droplang dropuser oid2name pg_archivecleanup pg_basebackup pgbench pg_dump pg_dumpall pg_isready pg_receivexlog pg_recvlogical pg_restore pg_standby pg_test_fsync pg_test_timing psql reindexdb vacuumdb vacuumlo /etc/postgresql/9.4/main/postgresql.conf data_directory still points to the Beta 1 cluster in /var/lib/postgresql/9.4/main
В списке pgsql-general по дате отправления: