| From: | Joe Lester <joe_lester(at)sweetwater(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | restoring a backup, incompatible with server |
| Date: | 2006-08-08 16:32:46 |
| Message-ID: | C1C85038-4B47-45FB-A63C-F90C0D98162D@sweetwater.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm having a little trouble restoring a backup (from the production
server to our development server).
I recently updated both production and development servers to
postgres 8.1.4 from 8.0.x. When I updated production, I did a fresh
initdb and imported from a previous dump. This server is running well.
Then I did my normal restore-from-backup routine... I copied the
$PGDATA folder on production over to development (making sure that
the necessary log file was copied over as well into the pg_xlog
folder). However, when I tried to start the development server I got
this message.
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with PG_CONTROL_VERSION
738394112, but the server was compiled with PG_CONTROL_VERSION 812.
HINT: It looks like you need to initdb.
I'm a little confused since the $PGDATA folder from production was a
fresh initdb on 8.1.4... and I'm copying it to the development
server, which is also 8.1.4.
Any advise would be appreciated. Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-08-08 16:47:26 | Re: Practical maximums (was Re: PostgreSQL theoretical |
| Previous Message | Steve Peterson | 2006-08-08 16:25:23 | Re: DROP TABLESPACE fails |