Re: Move database from Solaris to Windows - Mailing list pgsql-general

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?

I have been assuming that the databases would be the same since they are
created by the same application in both environments.  Perhaps that is a
false assumption, but I would expect that the app developers wouldn't want
to work with different types of postgreSQL databases on different platforms.

I know that both platforms connect to the database and do their work through
Java (JDBC connections), but that's about the best of what I can tell you at
this point (though I'm willing to dig for more information to help get more
assistance of course).



Bcd


-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Erik Jones
Sent: Wednesday, August 01, 2007 4:22 PM
To: Steve Atkins
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Move database from Solaris to Windows

On Aug 1, 2007, at 2:34 PM, Steve Atkins wrote:

>
> On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
>
>> Please forgive me if this question is being asked in the wrong area
>> (and please suggest the proper one so I can ask there :-) ), but I'm
>> in search of assistance in moving a database from a Solaris system
>> over to a Windows system.
>>
>> Solaris 5.8, postgreSQL 8.01, to Windows Server 2003, postgreSQL
>> 8.0.13.
>>
>> Installing on the Windows Server has gone simple enough, and I've
>> actually experimented a little with pg_dump to dump the contents of
>> the database that I get by default when installing the application
>> that I'm working with which requires the db.
>>
>> I tried using pg_dump --format=t to dump the original database, and
>> then tried to restore into a database with the same name on the
>> Windows side but that restore has not been successful.
>
> I find it a lot easier to diagnose what's going on with plain format,
> generally.
>
>>
>> I've been trying to follow information found here:
>> http://www.postgresql.org/docs/8.0/static/app-pgrestore.html but have
>> not been successful yet.
>>
>> Any assistance that can be lent my way is greatly appreciated.
>
> You'll need to post a few more details (what commands you ran, what
> errors you got) before people will be able to help you much.

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?

Erik Jones

Software Developer | EmmaR
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



---------------------------(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