Re: Looking for professionals for a PG server move

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Looking for professionals for a PG server move
Date: 2010-01-01 16:06:37
Message-ID: 4B3E1D8D.5030204@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 problems are 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2010-01-01 16:13:55 Re: Error during make when installing geos for postgis install...still trying
Previous Message Chris McDonald 2010-01-01 16:04:36 Re: Query very slow when in plpgsql function