From: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
---|---|
To: | Andy Colson <andy(at)squeakycode(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Looking for professionals for a PG server move |
Date: | 2010-01-01 23:42:25 |
Message-ID: | e373d31e1001011542r15229c3el562396dd0e4a11f5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andy
Biggest problem is utf-8 crap. Some other databases are much more
forgiving of the data. PG takes utf-8 data but somehow gives problem
with backup/restore. I've tried everything, including iconv etc, but
this truly could be a lot better in the future versions I hope.
Thanks.
On Sat, Jan 2, 2010 at 12:06 AM, Andy Colson <andy(at)squeakycode(dot)net> wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-01-02 00:00:14 | Re: Looking for professionals for a PG server move |
Previous Message | benoît carpentier | 2010-01-01 20:30:09 | Benetl, a free ETL tool for files using postgreSQL, is out in version 3.3 |