From: Suya Huang <shuang@connexity.com>
To: David Osborne <david@qcode.co.uk>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: how to downgrade Postgres in Ubuntu
Date: Thu, 2 Jun 2016 23:28:36 +0000
Message-ID: <3FD02618-1E34-4B00-87F2-B76A34DE199C@connexity.com> (raw)
In-Reply-To: <CAKmpXCfcrNsmMWgS+hKo1GVdTn1J6ur+_kV5Ados45o=-hkE6Q@mail.gmail.com>
References: <078538CC-EFAC-435C-9EF8-26EBF034DC3C@connexity.com>
<CABokaaMqwNvqc6ytijOHJ1OETgj7FQvHgF49STuWbbo7KOMRfQ@mail.gmail.com>
<78F3BE4A-04C1-4CD4-8D07-B4A7B335C7FA@connexity.com>
<CAKmpXCfcrNsmMWgS+hKo1GVdTn1J6ur+_kV5Ados45o=-hkE6Q@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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<mailto:david@qcode.co.uk>>
Date: Thursday, June 2, 2016 at 8:46 PM
To: Suya Huang <shuang@connexity.com<mailto:shuang@connexity.com>>
Cc: "pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>" <pgsql-admin@postgresql.org<mailto: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<mailto: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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: shuang@connexity.com, david@qcode.co.uk
Subject: Re: how to downgrade Postgres in Ubuntu
In-Reply-To: <3FD02618-1E34-4B00-87F2-B76A34DE199C@connexity.com>
References: <078538CC-EFAC-435C-9EF8-26EBF034DC3C@connexity.com> <CABokaaMqwNvqc6ytijOHJ1OETgj7FQvHgF49STuWbbo7KOMRfQ@mail.gmail.com> <78F3BE4A-04C1-4CD4-8D07-B4A7B335C7FA@connexity.com> <CAKmpXCfcrNsmMWgS+hKo1GVdTn1J6ur+_kV5Ados45o=-hkE6Q@mail.gmail.com> <3FD02618-1E34-4B00-87F2-B76A34DE199C@connexity.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox