Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C36799FB664 for ; Tue, 26 Jun 2007 21:14:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 41965-04 for ; Tue, 26 Jun 2007 21:14:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 835739FA425 for ; Tue, 26 Jun 2007 21:14:28 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d32so1362pye for ; Tue, 26 Jun 2007 17:14:27 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=lU0+OqIu4Slhw99D3ZPqtRaTgYn4zfeDli9EP80/ptWSOq7ZnIBYe89OY8slWW5FZxoy22ODKjhpHlqce0F8T1Z9oi7LGl4UI+JCmSzSXq0jwwqoosVSQfGfocy15arnzPq23fqKLUcwFhMTpqm+MXGijDHSR6/ZUcJeEwlUfSc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=b4BbeJwSymbC3w0ReTfTjIz8ajm3+vQRAUbatO8S4puQcPcKBwUIxmpyweUIo9Qi9bHx5RzOwdoE121J8JImjWyO12nQoaKQZc4Y5TocI1mivFr6n+KABh8aZsgHuy1/wMUZuw1A1UDfsWKAXdSg28/DOEKBJndGaYND7wvcg94= Received: by 10.65.154.2 with SMTP id g2mr12202913qbo.1182903267006; Tue, 26 Jun 2007 17:14:27 -0700 (PDT) Received: from ?192.168.0.102? ( [66.168.24.69]) by mx.google.com with ESMTP id 5sm11367661nzk.2007.06.26.17.14.26 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 26 Jun 2007 17:14:26 -0700 (PDT) Message-ID: <4681ABDF.70305@gmail.com> Date: Tue, 26 Jun 2007 19:14:23 -0500 From: Peter Koczan User-Agent: Thunderbird 2.0.0.4 (X11/20070619) MIME-Version: 1.0 To: Tommy Gildseth CC: "Campbell, Lance" , pgsql-admin@postgresql.org Subject: Re: Load DB - Conversion from 8.1.4 to 8.2.4 References: <467ECEE2.9070701@usit.uio.no> In-Reply-To: <467ECEE2.9070701@usit.uio.no> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/275 X-Sequence-Number: 25943 Tommy Gildseth wrote: > Campbell, Lance wrote: >> >> I will be converting from PostgreSQL 8.1.4 to 8.2.4. Is it OK to do >> the following command in order to load the new database after install? >> >> pg_dump -h /host1/ –p 1234 /dbname/ | psql -h /host1 –p 56789/ >> /dbname/// >> >> Remember that port 1234 is PostgreSQL 8.1.4 and port 5678 is >> PostgreSQL 8.2.4. >> > > Should be fine, as long as you ensure that the pg_dump you use, is the > one from your 8.2.4 installation, and not the 8.1.4 version. > > Two quick addendums: - pg_dump doesn't dump large objects. You should use the following if you use large objects. pg_dump -h /host1/ –p 1234 -Fc /dbname/ | pg_restore -h /host1 –p 56789/ /dbname/// - There might be some other issues with the upgrade. I've run into permissions issues, data types that were checked more strictly, and a couple broken primary keys in my days as an admin. I'm not saying you'll run into these, but if you can, do a dry run of a dump/restore so you can solve the problems up front. Peter