gais <gais(at)alpenjodel(dot)de> wrote:
> I'm running a caldav server with postgresql backend. For some
> reason a user removed his agenda, I want to revert to a state
> before 20th of August in order to restore this. I have a
> configuration with archive_mode = on in postgresql.conf and a
> timeout of 24h. I have a dump from the original database and all
> WAL files from the last 18 months. I want to restore the database
> and run all WAL to restore to it's last working state.
>
> I've tried two options based on the documentation:
>
http://www.postgresql.org/docs/8.3/static/continuous-archiving.html
> option one:
> [code]initdb -d /var/lib/postgresql/8.3/main[/code]
> second option:
> [code]initdb -d /var/lib/postgresql/8.3/main[/code]
Not based very closely on the documentation. Please read the
"Recovering using a Continuous Archive Backup" subsection closely
and follow the directions there. In particular, initdb is not run
as part of the recovery. If you follow the directions step by step,
you should get farther. If you still have problems, feel free to
post again.
-Kevin