From: | Oscar Calderon <ocalderon(at)solucionesaplicativas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | About replacing PostgreSQL instance |
Date: | 2013-05-16 18:19:41 |
Message-ID: | CAOqBXCDgtB4c4K3AAvQVkAg-KE6uykZcRhjULpBeD93F-smT9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi to all, i wanna ask you a piece of advice. The company where i work is
bringing maintenance service of PostgreSQL to another company, and
currently they have installed PostgreSQL 9.1.1, and they want to move to
9.3 version when it will come out. So, because the difference of versions,
and because it was installed by compiling it (using source code), and
because the 9.1.1 installation is in a different directory than the
default, they decided to replace 9.1.1 version with 9.3 (no upgrade, but
replace it).
Currently, they only have one database in production of 2.2 GB with some
procedures and triggers. So, my plan to execute this database installation
is the next:
1. Install PostgreSQL 9.3 from postgresql repository (yum.postgresql.org)
with a different port to avoid interrupt the production PostgreSQL instance
operation
2. Tune the database parameters in postgresql.conf, also create the same
rules in pg_hba as the production instance, configure log and so on.
3. At the end of the operations day, create a backup of the production
database and then restore it into the new instance
4. Test the new instance with the PHP applications that use it and
verify that all is in order
5. Stop the old instance and change the port to another port, then
change the port of the new instance to 5432 in order to avoid change the
network configuration, permissions and so on.
But really is the first time that i do that, so i don't know if i'm missing
something or there's something wrong about i'm planning to do, so i will
appreciate very much if you can guide me about what steps i have to do
exactly and considerations during this process.
Regards.
***************************
Oscar Calderon
Analista de Sistemas
Soluciones Aplicativas S.A. de C.V.
www.solucionesaplicativas.com
Cel. (503) 7741 7850
From | Date | Subject | |
---|---|---|---|
Next Message | AI Rumman | 2013-05-16 18:21:16 | Re: pg_upgrade link mode |
Previous Message | Igor Neyman | 2013-05-16 18:03:14 | Re: pg_upgrade link mode |