Re: Moving DB data disk to a different machine

Поиск
Список
Период
Сортировка
От Eliot, Christopher
Тема Re: Moving DB data disk to a different machine
Дата
Msg-id 5C27B2F8693FA3458E71B4A81551253F03A3C75B@NSTAR-MAIL1.windows.nagrastar.com
обсуждение исходный текст
Ответ на Re: Moving DB data disk to a different machine  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-admin
Yes, in fact I installed postgreSQL, renamed the newly-created "data"
directory, and then copied over the old data directory.
When that didn't work I renamed my new data directory off to another
name and restored the data directory that was created as part of the
installation, and was able to successfully bring up the server.

I'll look in to the pg_controldata thing you suggested.

Topher Eliot
christopher.eliot@nagrastar.com
[]

> -----Original Message-----
> From: Scott Marlowe [mailto:scott.marlowe@gmail.com]


>
> You need to empty out the postgresql data directory, then
> copy everything in from the other disk.  What errors are you
> getting?  It's possible you're not using a compatible version.
>
> The major version numbers need to match (i.e. 8.2.4 to 8.2.7 is fine,
> 8.1.13 to 8.2.7 is not) and they need to be compiled the same way.
> I.e. if you had integer timestamps in one you need it in the other.
>

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

Предыдущее
От: Trent Pingenot
Дата:
Сообщение: Permissions Scenerio
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Permissions Scenerio