Thread: Windows XP to Win 10 migration issue

I have a database in Windows XP (old PC), postgresql 8.4.5 which needs 
to be migrated to Windows 10 Pro (new PC).

Now, for the bad news, the XP PC, when I powered down, before doing any 
backup or database unload, would not power back up.  I will be 
attempting to get the PC fixed for that.  In the meantime, I removed the 
old PC HD, installing in a SATA to USB box and I installed the same 
version of Postgresql (8.4.5) on the Win 10 machine, thinking I could 
simply copy the data folder from the XP's HD to the Win 10's HD into the 
appropriate folder (C:/.../8.4.5/).  I did the copy of the data folder, 
after renaming the new, unused data folder to preserve it).  I stopped 
the postgres service, made the copy, and attempted to restart the 
postgres service.  No Go!  Would not start.  As a double-check, I 
renamed the copied data folder to something else and renamed the 
preserved data folder back to it's original name, and the service 
restarted just fine.

So, without being able to backup or unload (dump?) the original database 
on the original PC, what would be the best way to move data to the new 
PC?  Or, IS there any way to do this, without reviving the old XP, PC?

Dale

> On Dec 9, 2017, at 11:11, Dale Seaburg <kg5lt@verizon.net> wrote:
>
> I have a database in Windows XP (old PC), postgresql 8.4.5 which needs to be migrated to Windows 10 Pro (new PC).
>
> Now, for the bad news, the XP PC, when I powered down, before doing any backup or database unload, would not power
backup.  I will be attempting to get the PC fixed for that.  In the meantime, I removed the old PC HD, installing in a
SATAto USB box and I installed the same version of Postgresql (8.4.5) on the Win 10 machine, thinking I could simply
copythe data folder from the XP's HD to the Win 10's HD into the appropriate folder (C:/.../8.4.5/).  I did the copy of
thedata folder, after renaming the new, unused data folder to preserve it).  I stopped the postgres service, made the
copy,and attempted to restart the postgres service.  No Go!  Would not start.  As a double-check, I renamed the copied
datafolder to something else and renamed the preserved data folder back to it's original name, and the service
restartedjust fine. 
>
> So, without being able to backup or unload (dump?) the original database on the original PC, what would be the best
wayto move data to the new PC?  Or, IS there any way to do this, without reviving the old XP, PC? 

I’m guessing that the old machine was 32 but and the New is 64?  They have to match. You could always setup a 32 bit
VM.It must be 32 bit windows (if that’s what the original was )  


>
> Dale
>

On 12/9/2017 1:03 PM, Scott Mead wrote:
> I’m guessing that the old machine was 32 but and the New is 64?  They have to match. You could always setup a 32 bit
VM.It must be 32 bit windows (if that’s what the original was )
 

you should be able to run 32 bit postgresql on 64 bit windows.

its a bit trickier than just the same version, however...  they should 
be from the same distribution too... a version built with GCC and Cygwin 
might not be binary compatible with a version built with Microsoft 
Visual C (such as the EnterpriseDB versions) due to differences in 
runtime libraries.


-- 
john r pierce, recycling bits in santa cruz

On Sat, 9 Dec 2017 10:11:42 -0600
Dale Seaburg <kg5lt@verizon.net> wrote:

>   No Go!  Would not start. 

Any error message in your logs?

I would certainly second Scott's suggestion to check the processors. I've had to do what you describe once, and it took
mefour machines before I got one that would start postgresql with my rescued data folder. 

You might have better luck finding an old XP machine similar to your deceased one, installing postgresql on it, and
usingthat to start your cluster. 


--
                    Bien à vous, Vincent Veyron
https://marica.fr/
Logiciel de gestion des sinistres assurances, des dossiers contentieux et des contrats pour le service juridique

Il 11/12/2017 14:37, Vincent Veyron ha scritto:
> On Sat, 9 Dec 2017 10:11:42 -0600
> Dale Seaburg <kg5lt@verizon.net> wrote:
>
>>    No Go!  Would not start.
> Any error message in your logs?
>
> I would certainly second Scott's suggestion to check the processors. I've had to do what you describe once, and it
tookme four machines before I got one that would start postgresql with my rescued data folder.
 
>
> You might have better luck finding an old XP machine similar to your deceased one, installing postgresql on it, and
usingthat to start your cluster.
 
>
>
I'd take a peek into logs (maybe EventLog), it happened to me that the 
postgres user in windows 10 did not have the permission to access data 
directory. Setting the right permissions could make it start. Obviously 
the processor architecture (32/64 bit) must be honored.

My 2 cent