From: | Alka Gupta <alka(dot)gupta(at)broadcom(dot)com> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: recovering database from a linux file system |
Date: | 2016-03-10 20:25:11 |
Message-ID: | 39cb59babc3b39ed712d4c450542c298@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you John!
Do you know if there is any encryption or security or will plainly copying
the files will work? Do I need to know any db usernames and passwords, which
obviously I don't have?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Thursday, March 10, 2016 12:10 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] recovering database from a linux file system
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_o
> n_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
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2016-03-10 20:36:05 | Re: Best approach for multi-database system |
Previous Message | Andy Colson | 2016-03-10 20:18:48 | Re: Best approach for multi-database system |