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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce Sent: Thursday, March 10, 2016 12:10 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
