Re: Move database from Solaris to Windows

On 8/2/07, Barry C Dowell <barry(dot)c(dot)dowell(dot)1(at)gsfc(dot)nasa(dot)gov> 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