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

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>