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

[Octavi Fors <octavi@xxxxxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxx