Re: recovering database from a linux file system

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: recovering database from a linux file system
Date: 2016-03-10 20:10:09
Message-ID: 56E1D4A1.3060602@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2016-03-10 20:14:22 Re: Best approach for multi-database system
Previous Message Alka Gupta 2016-03-10 20:05:18 recovering database from a linux file system