Moving postgre db's from a 6.3 to a 6.4 on a new machine

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
=====================================

Browse pgsql-admin by date

  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