From: | Octavi Fors <octavi(at)live(dot)unc(dot)edu> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
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-16 22:14:20 |
Message-ID: | CAJEYUR__MbQSi7xG+k93TeJCY6kAVkz1UCLKf_h7axVBaHaMMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Thanks a lot,
Octavi.
On Thu, Apr 16, 2015 at 5:38 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 04/16/2015 02:01 PM, Octavi Fors wrote:
>
>> Dear all,
>>
>> I have one newbie question which I hope one kind soul of this list can
>> help me.
>>
>> The situation is that I have two postgresql servers:
>>
>> -9.2 running on Ubuntu 12.04 with a database 'db' already created and
>> populated with data,
>>
>> -9.3 running on Ubuntu 14.04.02 with no database created (no tables,
>> no data),
>>
>> I want to migrate the database 'db' (tablespace+tables+data) from
>> computer with 9.2 server to computer with 9.3 server.
>>
>> Note: database 'db' is living on a NAS mounted via NFS, with a
>> tablespace modification I was given in this list last week:
>>
>> CREATE TABLESPACE onNAS LOCATION '/NAS-box/pgsql-data';
>> CREATE DATABASE db TABLESPACE onNAS;
>>
>>
>> I would appreciate if you could provide commands I can type to make me
>> start with the process.
>>
>
> Well it is an upgrade from one major version to another, so you have the
> following options using Postgres core utilities:
>
> 1) Do a dump and restore:
> http://www.postgresql.org/docs/9.3/interactive/app-pgdump.html
> http://www.postgresql.org/docs/9.3/interactive/app-pgrestore.html
>
> 2) Use pg_upgrade:
> http://www.postgresql.org/docs/9.3/interactive/pgupgrade.html
>
>
>
>> Thanks in advance,
>>
>> Octavi Fors.
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Geoff Speicher | 2015-04-16 22:21:20 | Re: fillfactor and cluster table vs ZFS copy-on-write |
Previous Message | Qingqing Zhou | 2015-04-16 22:09:08 | Re: Waiting on ExclusiveLock on extension |