Re: Restoring databases using only data/ dir

Afra <aa4@cse.buffalo.edu> writes:

We have run into some problems here which stops us from properly backing
up the databases using pg_dump. We do have a tarred version of the data
directory (/usr/local/pgsql/data) which contains databases that we need
to restore.

I found out that simply replacing the data/ directory does no good. Is
there another method in which I can restore databases with the data/
directory?

Restoring the *entire* data directory should work.

It seems to me that there's a great deal you haven't told us; if you
want useful help it's better to err on the side of too much info,
not too little. For starters, what happens when you try to pg_dump?

regards, tom lane