Re: recovering database from a linux file system - Mailing list pgsql-general

From John R Pierce
Subject Re: recovering database from a linux file system
Date
Msg-id 56E1D4A1.3060602@hogranch.com
Whole thread Raw
In response to recovering database from a linux file system  (Alka Gupta <alka.gupta@broadcom.com>)
Responses Re: recovering database from a linux file system
Re: recovering database from a linux file system
List pgsql-general
On 3/10/2016 12:05 PM, Alka Gupta wrote:
> The vendor won't give us any way to access the machine and retrieve
> the DB, so I removed the HDD and connected it to my Linux laptop.  I
> was able to grab all the DB files and copy them to my Windows desktop,
> where I then installed PostgreSQL 9.0 (to match the version that was
> on the server) with pgAdmin III.  I changed the default directory to
> the folder containing the DB files using this tutorial:
> https://wiki.postgresql.org/wiki/Change_the_default_PGDATA_directory_on_Windows


I would try installing postgres on linux, and try running it with a copy
of this data directory.   skip the pgadmin thing entirely as its just
another layer of obfuscation, stick with CLI tools.



--
john r pierce, recycling bits in santa cruz



pgsql-general by date:

Previous
From: Alka Gupta
Date:
Subject: recovering database from a linux file system
Next
From: Edson Richter
Date:
Subject: Re: Best approach for multi-database system