From: Steve Crawford <scrawford@pinpointresearch.com>
To: Bayan M. Almuqhim <balmuqhim@kacst.edu.sa>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Backup and restore postgreSQL
Date: Tue, 05 Nov 2013 10:01:30 -0800
Message-ID: <5279327A.8010906@pinpointresearch.com> (raw)
In-Reply-To: <0EB54111E5F012439259BE380257F5D98F2388@ex-itu01-002>
References: <0EB54111E5F012439259BE380257F5D98F2388@ex-itu01-002>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 11/05/2013 04:17 AM, Bayan M. Almuqhim wrote:
> Dear all,
>
>
> I have 8.4 postgreSQL on Ubuntu 11.10 and I would like to upgrade my
> server to Ubuntu 12.04 and use 9.1 postgreSQL.
> I have Slony-| replication cluster in my database, also there is a
> table with many partitions.
Question one: did you use the *new* version of pg_dump and psql or the
old one? You should always do your dump and restore using the client
tools from the new version, i.e. use the 9.1 pg_dump to dump the 8.4
database.
As long as you are going through the effort of upgrading why not go
straight to 9.3 and get all the newer features, fixes and improvements
along with two more years of support before EOL?
Cheers,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, balmuqhim@kacst.edu.sa
Subject: Re: Backup and restore postgreSQL
In-Reply-To: <5279327A.8010906@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox