RE: [ADMIN] Moving postgre db's from a 6.3 to a 6.4 on a new mach ine

Поиск
Список
Период
Сортировка
От Jackson, DeJuan
Тема RE: [ADMIN] Moving postgre db's from a 6.3 to a 6.4 on a new mach ine
Дата
Msg-id F10BB1FAF801D111829B0060971D839F5B06D4@cpsmail
обсуждение исходный текст
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: khansen
Дата:
Сообщение: Re: Error starting postmaster
Следующее
От: "Satya Chauhan"
Дата:
Сообщение: ...