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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Octavi Fors <octavi(at)live(dot)unc(dot)edu>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: database migration question between different ubuntus and different postgresql server versions
Date: 2015-04-17 00:35:47
Message-ID: 55305563.1070904@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Octavi Fors 2015-04-17 00:52:12 Re: database migration question between different ubuntus and different postgresql server versions
Previous Message Andrew Sullivan 2015-04-16 22:22:49 Re: database migration question between different ubuntus and different postgresql server versions