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!
Thanks in advance