How to restore a file system level copy of a PostgreSQL database (not dump) to a different PC

Posted by user782224 on Server Fault See other posts from Server Fault or by user782224
Published on 2011-12-01T15:31:23Z Indexed on 2012/11/04 5:06 UTC
Read the original article Hit count: 452

Filed under:

postgresql

|

recovery

I am new to PostgreSQL. I have to recover a database which was running in widows XP machine.

I have the zip folder of postgres.

I have extracted postgres installation in a different PC and started a using initDB and created a new database, I was able to login, but I am not able to see any old tables.

Would you please post the steps you have used to start server in another windows XP machine and how to recover tables and data in the old data folder?

© Server Fault or respective owner

Related posts about postgresql

Postgresql fails to start on Ubuntu 10.04.4 LTS

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I installed postgresql 9.2 from add-apt-repository ppa:pitti/postgresql using apt-get install postgresql-9.2 At the end of the install and every time I try to launch postgresql by using the following command /etc/init.d/postgresql start or service postgresql start I get this error: Error:… >>> More
can't install psycopg2 in my env on mac os x lion

as seen on Server Fault - Search for 'Server Fault'
I tried install psycopg2 via pip in my virtual env, but got this error: ld: library not found for -lpq (full log here: http://pastebin.com/XdmGyJ4u ) I tried install postgres 9.1 from .dmg and via port, (gksks)iMac-Alexander:~ lorddaedra$ locate libpq /Developer/SDKs/MacOSX10.7.sdk/usr/include/libpq /Developer/SDKs/MacOSX10… >>> More
Postgresql has broken apt-get on Ubuntu

as seen on Super User - Search for 'Super User'
On ubuntu 12.04, whenever I try to install a package using apt-get I'm greeted by: The following packages have unmet dependencies: postgresql-9.1 : Depends: postgresql-client-9.1 but it is not going to be instal led E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a so lution)… >>> More
Installing PostgreSQL on FreeBSD (with ports)

as seen on Server Fault - Search for 'Server Fault'
Hey everyone, I am trying to install (using ports) PostgreSQL on a virtual server, running FreeBSD. My one question is this: Which of the following should I install? postgresql-contrib postgresql-docs postgresql-jdbc postgresql-libpgeasy postgresql-libpq++ postgresql-libpqxx postgresql-odbc … >>> More
Strange permission errors in new PostgreSQL installation

as seen on Server Fault - Search for 'Server Fault'
A freshly installed PostgreSQL (with configuration overwritten) won't start: $ sudo service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not read /etc/postgresql/9.1/main/postgresql.conf: Permission denied Looks like it should be able to read it though: $ ls -l postgresql… >>> More

Related posts about recovery

Crash/Instance Recovery?Media Recovery?????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Crash/Instance Recovery?Media Recovery???????: Crash/Instance Recovery???????????????(incremental checkpoint)??apply redo??????????????????????????logfile switch checkpoint,?????????????????????,????crash/instance recovery???????????????????????(online redo logfile)? ????Media Recovery… >>> More
HP Recovery options: System Recovery not showing

as seen on Super User - Search for 'Super User'
I am using HP Pavilion dv4 notebook. Previously, there were following options in Recovery Manager(using f11 during boot): +System Recovery +Factory Restore +Minimized Image Recovery The System Recovery option allows me to restore only Operating system drive e.g. C:\ drive, keeping all other user… >>> More
Eee PC - Create USB Recovery Drive w/ Files Copied From Recovery Partition

as seen on Super User - Search for 'Super User'
I have an Eee PC 1005HAB whose hard disk has failed. I have no recovery CD/DVD, but I did previously back up the contents of the recovery partition, and would like to use them to create a bootable USB to reinstall the factory settings on the new hard drive. Since I simply copied all the files… >>> More
Macrium Reflect Recovery Linux Recovery Disc hangs up on booting

as seen on Super User - Search for 'Super User'
I created an image of my system with macrium reflect freeware program and stored the image on an usb external hard drive. However the macrium reflect linux recovery disc on startup hangs up of the first three lines of instructions and therefore I cannot access the image on the usb external hard drive… >>> More
Understanding Windows 8 Recovery options

as seen on Super User - Search for 'Super User'
Background: I am preparing a PC that I am sending to a relative abroad, who has little or no internet access, and next to no sensible options for getting IT support should anything go wrong. As such I am trying to provide a full set of recovery options such that they are able to reinstall the OS… >>> More