From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Octavi Fors <octavi(at)live(dot)unc(dot)edu>, 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 21:38:56 |
Message-ID: | 55302BF0.2000309@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Andomar | 2015-04-16 21:39:20 | Re: Waiting on ExclusiveLock on extension |
Previous Message | Qingqing Zhou | 2015-04-16 21:23:25 | Re: Waiting on ExclusiveLock on extension |