database migration question between different ubuntus and different postgresql server versions

From: Octavi Fors <octavi(at)live(dot)unc(dot)edu>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: database migration question between different ubuntus and different postgresql server versions
Date: 2015-04-16 21:01:34
Message-ID: CAJEYUR9YgSX6F_nUNcB00i=XogrWbq=p75TT9QS61DNH5x_fOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks in advance,

Octavi Fors.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Qingqing Zhou 2015-04-16 21:23:25 Re: Waiting on ExclusiveLock on extension
Previous Message Qingqing Zhou 2015-04-16 20:56:10 Re: fillfactor and cluster table vs ZFS copy-on-write