Re: Windows postgresql back using linux

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Windows postgresql back using linux
Date: 2009-11-06 20:39:56
Message-ID: hd21iq$c9k$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

ABBAS SHAKEEL wrote on 06.11.2009 18:51:
> Hello all
>
> Today due to some problems my windows crashed. I have unbuntu also
> installed on my system. I can access the C drive by mounting it in linux.
> I have tried to run windows in save mode and also many other options
> like replacing some dll files but none worked.
>
> Now some very important Databases was residing on my windows postgresql
> server. I dont want to loose them :(
>
> Can I take backup of those DB from Linux. As i can access the Postgresql
> folder from linux. Please suggest
>
No, you cannot just "copy" the data folder from Windows to Linux.

But if you can access the PG data directory, make a backup copy of it, re-install Windows and Postgres.

Then copy the backup of the data directory back to the Windows installation.

Thomas

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message raf 2009-11-07 00:44:13 Re: pg_stat_activity howto
Previous Message Alvaro Herrera 2009-11-06 18:18:40 Re: REINDEX disk space requirements