Search Postgresql Archives

Unsubscribe

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



________________________________________
From: pgsql-general-owner@xxxxxxxxxxxxxx [pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Merlin Moncure [mmoncure@xxxxxxxxx]
Sent: Wednesday, August 01, 2007 11:14 PM
To: barry.c.dowell.1@xxxxxxxxxxxxx
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  Move database from Solaris to Windows

On 8/2/07, Barry C Dowell <barry.c.dowell.1@xxxxxxxxxxxxx> wrote:
> Ok, if you can forgive the possible stupid answer and help pull me a long a
> bit more, in answer to this:
>
> >> Yes, dump/restore is pretty much the standard to move dbs across
> architectures so we'll need more to work with.  One thing to check, did you
> make sure that your dump was in the same encoding as the database you
> created on your Windows server?
>
> How do I know what encoding was used on one database (on one OS) versus the
> other?

psql -l

lists the encoding.  postgresql on windows iirc defaults to sql_ascii
which is actually the most forgiving but not a great choice.  linux
defaults to utf-8.

can you post the exact text of the error?

merlin

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux