database backup...

From: Jinsoo Hwang <jshwang(at)stat(dot)inha(dot)ac(dot)kr>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: database backup...
Date: 2001-02-17 07:32:04
Message-ID: 3A8E28F4.FA30A4B3@stat.inha.ac.kr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Paul M Foster 2001-02-17 07:41:38 Re: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?
Previous Message Tom Lane 2001-02-17 06:33:05 Re: Are partial indicies supported?