Re: Migration of server

> Hi everybody, this is my first message in this list. 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.

Not, only bad thing is that the 9.3 is still in beta version.

Use 9.2.

Write list in spanish Too ;-)

Saludos,
Gilberto Castillo
La Habana, Cuba