pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to downgrade Postgres in Ubuntu
7+ messages / 4 participants
[nested] [flat]
* how to downgrade Postgres in Ubuntu
@ 2016-06-02 04:09 Suya Huang <shuang@connexity.com>
0 siblings, 1 reply; 7+ messages in thread
From: Suya Huang @ 2016-06-02 04:09 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: how to downgrade Postgres in Ubuntu
@ 2016-06-02 04:42 JD <venkijd@gmail.com>
parent: Suya Huang <shuang@connexity.com>
0 siblings, 1 reply; 7+ messages in thread
From: JD @ 2016-06-02 04:42 UTC (permalink / raw)
To: Suya Huang <shuang@connexity.com>; +Cc: pgsql-admin
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
.
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
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: how to downgrade Postgres in Ubuntu
@ 2016-06-02 09:45 Suya Huang <shuang@connexity.com>
parent: JD <venkijd@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Suya Huang @ 2016-06-02 09:45 UTC (permalink / raw)
To: JD <venkijd@gmail.com>; +Cc: pgsql-admin
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<mailto:venkijd@gmail.com>>
Date: Thursday, June 2, 2016 at 2:42 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
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 .
3. Or uninstall and reinstall old binaries again.
On Thu, Jun 2, 2016 at 9:39 AM, Suya Huang <shuang@connexity.com<mailto: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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: how to downgrade Postgres in Ubuntu
@ 2016-06-02 10:46 David Osborne <david@qcode.co.uk>
parent: Suya Huang <shuang@connexity.com>
0 siblings, 2 replies; 7+ messages in thread
From: David Osborne @ 2016-06-02 10:46 UTC (permalink / raw)
To: Suya Huang <shuang@connexity.com>; +Cc: pgsql-admin
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
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: how to downgrade Postgres in Ubuntu
@ 2016-06-02 12:38 Markus Wanner <markus@bluegap.ch>
parent: David Osborne <david@qcode.co.uk>
1 sibling, 1 reply; 7+ messages in thread
From: Markus Wanner @ 2016-06-02 12:38 UTC (permalink / raw)
To: David Osborne <david@qcode.co.uk>; Suya Huang <shuang@connexity.com>; +Cc: pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: how to downgrade Postgres in Ubuntu
@ 2016-06-02 23:28 Suya Huang <shuang@connexity.com>
parent: David Osborne <david@qcode.co.uk>
1 sibling, 0 replies; 7+ messages in thread
From: Suya Huang @ 2016-06-02 23:28 UTC (permalink / raw)
To: David Osborne <david@qcode.co.uk>; +Cc: pgsql-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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: how to downgrade Postgres in Ubuntu
@ 2016-06-02 23:33 Suya Huang <shuang@connexity.com>
parent: Markus Wanner <markus@bluegap.ch>
0 siblings, 0 replies; 7+ messages in thread
From: Suya Huang @ 2016-06-02 23:33 UTC (permalink / raw)
To: Markus Wanner <markus@bluegap.ch>; David Osborne <david@qcode.co.uk>; +Cc: pgsql-admin
Thank you Markus, good to know that Debian has the snapshot service which is very handy. I’m not a Ubuntu fan, I prefer CentOS over 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
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2016-06-02 23:33 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-06-02 04:09 how to downgrade Postgres in Ubuntu Suya Huang <shuang@connexity.com>
2016-06-02 04:42 ` JD <venkijd@gmail.com>
2016-06-02 09:45 ` Suya Huang <shuang@connexity.com>
2016-06-02 10:46 ` David Osborne <david@qcode.co.uk>
2016-06-02 12:38 ` Markus Wanner <markus@bluegap.ch>
2016-06-02 23:33 ` Suya Huang <shuang@connexity.com>
2016-06-02 23:28 ` Suya Huang <shuang@connexity.com>
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