Postgres Pro
Downloads
Home   >   mailing lists

Re: database migration question between different ubuntus and different postgresql server versions - Mailing list pgsql-general

From Octavi Fors
Subject Re: database migration question between different ubuntus and different postgresql server versions
Date
Msg-id CAJEYUR99Qz0-6yq7F2O7Kjy=D7bQs0KksSEcke5xEhR8RJsqBA@mail.gmail.com
Whole thread Raw
In response to Re: database migration question between different ubuntus and different postgresql server versions  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: database migration question between different ubuntus and different postgresql server versions
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: database migration question between different ubuntus and different postgresql server versions
Next
From: Geoff Speicher
Date:
Subject: Re: fillfactor and cluster table vs ZFS copy-on-write