From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | Marc Eggenberger <me(at)ieo(dot)ch>, pgsql-admin(at)postgreSQL(dot)org |
Subject: | RE: [ADMIN] Moving postgre db's from a 6.3 to a 6.4 on a new mach ine |
Date: | 1999-01-04 23:34:21 |
Message-ID: | F10BB1FAF801D111829B0060971D839F5B06D4@cpsmail |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Have a look at pg_dump and pg_dumpall.
-DEJ
PS you might want to get a copy of 6.4.2
> -----Original Message-----
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | John Quinn | 1999-01-05 23:12:24 | unresolved symbol |
Previous Message | Satya Chauhan | 1999-01-04 17:17:30 |