Re: Upgrading from 9.1.2 to 9.1.5

On Fri, Sep 7, 2012 at 3:20 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Thu, Sep 6, 2012 at 05:55:05PM -0500, Antoine Guidi wrote:
>> Is it possible to do a pg_upgrade from 9.1.2 to 9.1.5 just using pg_upgrade?
>> For what I could read, the only exception would be if I was using a
>> citext column (which I am not).
>
> You cannot use pg_upgrade for this. You just need to stop the server,
> install the binaries, and restart the server.

AFAIU it is not necessary to stop the server when updating binaries if
one is not going to create extensions, PLs or anything else that will
be dynamically linked after the binaries update and before the server
restart.

So with the process

1. update binaries
2. postgres restart

the downtime will be shorter.

Do I understand something wrong?

>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

--
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204