restore a database from file-only backup of /var/lib/pgsql/
I need to restore some data from yesterday into my postgres database. I only have a filesystem backup each night so I have the full contents of /var/lib/pgsql which contains data, base, global etc. etc.
How do I copy my backup database folder into my currently running or maybe a spare server so that I can query yesterdays data to export back into the current db?
I think my databse is /var/lib/pgsql/data/base/156814 and my backup is on /mnt/buffalo/daily.0/var/lib/pgsql/data/base/156814
Please please can someone help it's pretty urgent!
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.