Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vdkwc-00059b-Or for pgsql-admin@arkaria.postgresql.org; Tue, 05 Nov 2013 18:01:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vdkwc-0003Vo-6y for pgsql-admin@arkaria.postgresql.org; Tue, 05 Nov 2013 18:01:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vdkwa-0003Uc-SH for pgsql-admin@postgresql.org; Tue, 05 Nov 2013 18:01:36 +0000 Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VdkwX-0003cs-Kr for pgsql-admin@postgresql.org; Tue, 05 Nov 2013 18:01:36 +0000 Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 20E69E00EC83; Tue, 5 Nov 2013 10:01:31 -0800 (PST) Message-ID: <5279327A.8010906@pinpointresearch.com> Date: Tue, 05 Nov 2013 10:01:30 -0800 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.1.0 MIME-Version: 1.0 To: "Bayan M. Almuqhim" , "pgsql-admin@postgresql.org" Subject: Re: Backup and restore postgreSQL References: <0EB54111E5F012439259BE380257F5D98F2388@ex-itu01-002> In-Reply-To: <0EB54111E5F012439259BE380257F5D98F2388@ex-itu01-002> Content-Type: multipart/alternative; boundary="------------080603060508020905060902" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------080603060508020905060902 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------080603060508020905060902 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
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

--------------080603060508020905060902--