As said in the topic I need some help restoring a database to a new server.
There is a production database on one server - I do a daily automated backup of that database to a remote location: pgdump, binaries, and bzipped logs.
Now I want to create a test environment on the other server running a copy of that database.
Could you please tell step by step me how to recover it?
I read http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html but I have some problems understanding it since I've been using Postgres for a short period of time.