On Fri, Sep 7, 2012 at 3:20 AM, Bruce Momjian <bruce@xxxxxxxxxx> 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@xxxxxxxxxx> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It's impossible for everything to be true. + > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > 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.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
