Обсуждение: how to downgrade Postgres in Ubuntu
Hi,
Good day all.
I’ve upgraded PG from 9.3.4 to 9.3.13 using apt-get install postgresql-9.3. I’m wondering as a blackout plan, how to downgrade it back to 9.3.4?
Thanks,
Suya
Hi,
You can follow below steps:
1. Stop the cluster .
2. If you have backup of old bin and postgresql.conf revert it and start .
2. If you have backup of old bin and postgresql.conf revert it and start .
3. Or uninstall and reinstall old binaries again.
On Thu, Jun 2, 2016 at 9:39 AM, Suya Huang <shuang@connexity.com> wrote:
Hi,Good day all.I’ve upgraded PG from 9.3.4 to 9.3.13 using apt-get install postgresql-9.3. I’m wondering as a blackout plan, how to downgrade it back to 9.3.4?Thanks,Suya
Thanks JD for the response. My question is more specific on how to reinstall old binary using apt-get install.
Thanks,
Suya
From: JD <venkijd@gmail.com>
Date: Thursday, June 2, 2016 at 2:42 PM
To: Suya Huang <shuang@connexity.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] how to downgrade Postgres in Ubuntu
Date: Thursday, June 2, 2016 at 2:42 PM
To: Suya Huang <shuang@connexity.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] how to downgrade Postgres in Ubuntu
Hi,
You can follow below steps:
1. Stop the cluster .
2. If you have backup of old bin and postgresql.conf revert it and start .
2. If you have backup of old bin and postgresql.conf revert it and start .
3. Or uninstall and reinstall old binaries again.
On Thu, Jun 2, 2016 at 9:39 AM, Suya Huang <shuang@connexity.com> wrote:
Hi,Good day all.I’ve upgraded PG from 9.3.4 to 9.3.13 using apt-get install postgresql-9.3. I’m wondering as a blackout plan, how to downgrade it back to 9.3.4?Thanks,Suya
You can sometimes do "apt-get install postgresql-9.3=9.3.4-1"
But often the OS cannot work out where to get hold of the requested version.
Alternatively you can check in /var/cache/apt/archives.
If the .deb file for the downlevel version is still there (copy it out so it's not cleaned up in future), and you can do "dpkg -i postgres-9.3_9.3.4-1.deb"
Failing that, you can download the downlevel deb file from somewhere.
(perhaps here? https://launchpad.net/ubuntu/+source/postgresql-9.3 )
On 2 June 2016 at 10:45, Suya Huang <shuang@connexity.com> wrote:
Thanks JD for the response. My question is more specific on how to reinstall old binary using apt-get install.Thanks,Suya
On 06/02/2016 12:46 PM, David Osborne wrote: > You can sometimes do "apt-get install postgresql-9.3=9.3.4-1" > > But often the OS cannot work out where to get hold of the requested version. > > Alternatively you can check in /var/cache/apt/archives. > If the .deb file for the downlevel version is still there (copy it out > so it's not cleaned up in future), and you can do "dpkg -i > postgres-9.3_9.3.4-1.deb" > > Failing that, you can download the downlevel deb file from somewhere. > (perhaps here? https://launchpad.net/ubuntu/+source/postgresql-9.3 ) On Debian we have snapshots (http://snapshot.debian.org/), not sure if Ubuntu provides a similar service, but the Postgres packages are similar enough that you could try that as a last resort. Regards Markus
Hi David,
This is the most complete solution I’ve got so far.
With apt-get install, OS says it cannot find the version, as you said.
sh@preview-db-1:~$ sudo apt-get -s install postgresql-9.3=9.3.4-1
[sudo] password for sh:
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Version '9.3.4-1' for 'postgresql-9.3' was not found
Looked at the archives directory, there’s no postgresql packages, probably get cleaned up…
The last option does work! I found the deb file in launchpad http://launchpadlibrarian.net/170211692/postgresql-9.3_9.3.4-1_amd64.deb and will download it as a backout plan for the upgrade.
Thanks a lot for the very useful suggestion!
Thanks,
Suya
From: David Osborne <david@qcode.co.uk>
Date: Thursday, June 2, 2016 at 8:46 PM
To: Suya Huang <shuang@connexity.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] how to downgrade Postgres in Ubuntu
Date: Thursday, June 2, 2016 at 8:46 PM
To: Suya Huang <shuang@connexity.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] how to downgrade Postgres in Ubuntu
You can sometimes do "apt-get install postgresql-9.3=9.3.4-1"
But often the OS cannot work out where to get hold of the requested version.
Alternatively you can check in /var/cache/apt/archives.
If the .deb file for the downlevel version is still there (copy it out so it's not cleaned up in future), and you can do "dpkg -i postgres-9.3_9.3.4-1.deb"
Failing that, you can download the downlevel deb file from somewhere.
(perhaps here? https://launchpad.net/ubuntu/+source/postgresql-9.3 )
On 2 June 2016 at 10:45, Suya Huang <shuang@connexity.com> wrote:
Thanks JD for the response. My question is more specific on how to reinstall old binary using apt-get install.Thanks,Suya
Thank you Markus, good to know that Debian has the snapshot service which is very handy. I’m not a Ubuntu fan, I prefer CentOSover Ubuntu… Thanks, Suya On 6/2/16, 10:38 PM, "Markus Wanner" <markus@bluegap.ch> wrote: >On 06/02/2016 12:46 PM, David Osborne wrote: >> You can sometimes do "apt-get install postgresql-9.3=9.3.4-1" >> >> But often the OS cannot work out where to get hold of the requested version. >> >> Alternatively you can check in /var/cache/apt/archives. >> If the .deb file for the downlevel version is still there (copy it out >> so it's not cleaned up in future), and you can do "dpkg -i >> postgres-9.3_9.3.4-1.deb" >> >> Failing that, you can download the downlevel deb file from somewhere. >> (perhaps here? https://launchpad.net/ubuntu/+source/postgresql-9.3 ) > >On Debian we have snapshots (http://snapshot.debian.org/), not sure if >Ubuntu provides a similar service, but the Postgres packages are similar >enough that you could try that as a last resort. > >Regards > >Markus >