Re: database migration question between different ubuntus and different postgresql server versions

Поиск
Список
Период
Сортировка
От Octavi Fors
Тема Re: database migration question between different ubuntus and different postgresql server versions
Дата
Msg-id CAJEYUR99Qz0-6yq7F2O7Kjy=D7bQs0KksSEcke5xEhR8RJsqBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: database migration question between different ubuntus and different postgresql server versions  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: database migration question between different ubuntus and different postgresql server versions  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
Hi Adrian,

I didn't received any answer from Andrews.

Yes, sorry I didn't describe completely my migration plan.
Right now the database 'db' is in NAS1 mounted via nfs with computer 1 (running ubuntu 12.04 postgresql 9.2).
I want to migrate 'db' to a faster NAS2 mounted via nfs with computer 2 (running ubuntu 14.04 postgresql 9.3).

Any commands/help to migrate 'db' from comp1+NAS1 to comp2+NAS2 would be most than welcome.

Cheers,

Octavi.


On Thu, Apr 16, 2015 at 8:35 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 04/16/2015 03:14 PM, Octavi Fors wrote:
Hi Adrian,

at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?

Could you/someone please provide an example of commands which I could use?

 See Andrews answer.

There is the matter of the tablespace.

It was not clear in your first post what you plan to do with the tablespace?

Are you going to keep it on the NAS or put it somewhere else?


Thanks a lot,

Octavi.





--
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: database migration question between different ubuntus and different postgresql server versions
Следующее
От: Geoff Speicher
Дата:
Сообщение: Re: fillfactor and cluster table vs ZFS copy-on-write