Thread: database backup...

database backup...

From
Jinsoo Hwang
Date:
Hi,
Our old(7.0.2) postgres base directory is, say /user3/local/pgsql
and new(7.0.3) postgres base directory is /usr/local/pgsql.

As the doc suggested I tried to backup the whole data(7.0.2), but
it was unsuccessful. Since the normal restoration is almost over, I was
thinking  about the other possibilities.
 Is it ok just by copying the directory, say /user3/local/pgsql/data to
/usr/local/pgsql/data and base/ directory also ?
Or tar-it the whole old data directory and untar it to new?
I haven't done anything to new database yet, except compile and
initializing.

Thanks.

Jinsoo