Re: Looking for professionals for a PG server move - Mailing list pgsql-general

From Andy Colson
Subject Re: Looking for professionals for a PG server move
Date
Msg-id 4B3E1D8D.5030204@squeakycode.net
Whole thread Raw
In response to Looking for professionals for a PG server move  (Phoenix Kiula <phoenix.kiula@gmail.com>)
Responses Re: Looking for professionals for a PG server move  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-general
On 01/01/2010 02:01 AM, Phoenix Kiula wrote:
>  From 8.2.9 on a 32 bit Linux CentOS server to a different server
> (Cpanel/WHM) which is now running 8.4.2 with 64 bit CentOS.
>
> Truly appreciate any pointers or recommendations of good folks who can
> do this, or have done this.
>
> Thanks!
>

Ahh? Above a backup and restore?  Like Absolutely no down time?  Or its a 50 Terabyte database?  Or both?  What
problemsare you having? 

On the new box, pg_dump the database from the old box, then restore it on the new.  Did you try this?

-Andy

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Save MySQL? HA
Next
From: Andy Colson
Date:
Subject: Re: Error during make when installing geos for postgis install...still trying