From: | Marc Eggenberger <me(at)ieo(dot)ch> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Moving postgre db's from a 6.3 to a 6.4 on a new machine |
Date: | 1999-01-02 16:45:54 |
Message-ID: | 199901021544.QAA28309@linux1.ieo.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi there.
I have a Sun with postgres 6.3 installed on it and some db which run fine ... now I have new computers (faster ones) which run linux with postgres 6.4 installed ... how do I move the db's? which way this can be done? I tried to creatdb db and then copy the dir .. but then this comes up:
Connection to database 'postgres' failed.
FATAL 1: InitPostgres could not validate that the database version is compatible with this level of Postgres
even though the database system as a whole appears to be at a compatible level.
You may need to recreate the database with SQL commands DROP DATABASE and CREATE DATABASE.
Version number in file '/var/lib/pgsql/data/base/postgres/PG_VERSION' should be 6.4, not 6.3.
--
mit freundlichen Gruessen
=====================================
Inside Electronic Online www.ieo.ch
Eggenberger Marc me(at)ieo(dot)ch
Leimbachstr. 56 Tel 01/4802800
8041 Zuerich Fax 01/4802801
=====================================
From | Date | Subject | |
---|---|---|---|
Next Message | neko | 1999-01-02 19:29:51 | Log, via triggers. |
Previous Message | Vincent RUIZ | 1998-12-29 16:15:15 | odbc build help needed |