Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7A7079FB298 for ; Wed, 17 Jan 2007 16:42:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 76921-07 for ; Wed, 17 Jan 2007 16:41:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web34210.mail.mud.yahoo.com (web34210.mail.mud.yahoo.com [66.163.178.125]) by postgresql.org (Postfix) with SMTP id 13B789FB228 for ; Wed, 17 Jan 2007 16:41:56 -0400 (AST) Received: (qmail 41672 invoked by uid 60001); 17 Jan 2007 20:41:55 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=MUvFOPF/QhFjs3Wi6Zr2P/0YK3NBRQoTyysjh4/UdOpv1PGYdCC0i/TjPtYanBTDUfeJwGhoN0VhZkInQqrwh0XaqNueiYsT17U6gryIY3yifbshyGuMS2SyotZLV6I5CFrB3okuquG2z91+3XmtgYo6FgIBNTUqQ541/CDOSVI= ; Message-ID: <20070117204155.41670.qmail@web34210.mail.mud.yahoo.com> X-YMail-OSG: I82V..8VM1kqKqYmT2wF_iHTfgiMZq6fWvLrsok8sGrF5jEC0w3mmqG4RrHXyweW4of3rso_YPLwJC69BeW_cx0Obr4ENpE87CGJjCgPKRcTrOjXyK.VAnLd7o.1E8wxFU2tv4EpjzLw6VVz3IefzN_gEgh1MovX6mkl.htqIZiE9WBXfbSBR04tuxHj Received: from [216.180.132.69] by web34210.mail.mud.yahoo.com via HTTP; Wed, 17 Jan 2007 12:41:55 PST Date: Wed, 17 Jan 2007 12:41:55 -0800 (PST) From: Andrew Edson Subject: Re: Upgrade/Installation problem: Version 7.4.9 to version To: Jeff Frost Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1376797102-1169066515=:41549" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/138 X-Sequence-Number: 24294 --0-1376797102-1169066515=:41549 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Please clear something up for me. The database I'm trying to upgrade was/is empty; only the original installation was present, no tables. Exactly what is it I'm supposed to be dumping? If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment. Please enlighten me. Jeff Frost wrote: Andrew, If you're moving between major versions, a dump/restore is necessary. The proper procedure is: 1) pg_dump the old database by using the new version of pg_dump (8.1.x) against the old db server (7.4.9 in your case) 2) stop the old database server (and possibly move/rename the old data dir) 3) initdb the new database server 4) edit postgresql.conf, etc 5) start the new database server 6) pg_restore the old database into the newly initialized data directory So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server. --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. --0-1376797102-1169066515=:41549 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Please clear something up for me.  The database I'm trying to upgrade was/is empty; only the original installation was present, no tables.  Exactly what is it I'm supposed to be dumping?  If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment.  Please enlighten me.

Jeff Frost <jeff@frostconsultingllc.com> wrote:
Andrew,

If you're moving between major versions, a dump/restore is necessary. The
proper procedure is:

1) pg_dump the old database by using the new version of pg_dump (8.1.x)
against the old db server (7.4.9 in your case)
2) stop the old database server (and possibly move/rename the old data dir)
3) initdb the new database server
4) edit postgresql.conf, etc
5) start the new database server
6) pg_restore the old database into the newly initialized data directory

So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.


It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar. --0-1376797102-1169066515=:41549--