Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AD82B9FB2B6 for ; Wed, 17 Jan 2007 14:48:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 06473-01-2 for ; Wed, 17 Jan 2007 14:47:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web34212.mail.mud.yahoo.com (web34212.mail.mud.yahoo.com [66.163.178.127]) by postgresql.org (Postfix) with SMTP id 134D19FB2B3 for ; Wed, 17 Jan 2007 14:47:41 -0400 (AST) Received: (qmail 98817 invoked by uid 60001); 17 Jan 2007 18:47:40 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Z2384Q3VL6V+Gb9eelPKPjY0tcBy3cvN0EP1YWjUTljec8MK6tUTLjRSaXWLrfrShRE30FtF9cHeuAb+Lztzcd952BcB0In5psQ6H5E+j1qT0J1mec0wKoIzy2Bhn2Dss2UMWM6J9E+ygrM524BDY64lYXYqkRePMkv82x5UgaI=; X-YMail-OSG: gvu8VQ0VM1kCBI377RZrXR5u0wrgR_CyezxEy0mJZX3g2.4ELpz3VUxzVw5L_OlYDYo79LkQ_g1o1SerPK7sVWk5C0h1Spc_1Rl0AGpKNq377GaQ0WQzqZFzBy.VwHt3xz0HqtfD6P.v_bPa04cKRv2zZUKWGvJwkJcHr4Tl.9XYF0vcRd3O7wvC2BOt Received: from [216.180.132.69] by web34212.mail.mud.yahoo.com via HTTP; Wed, 17 Jan 2007 10:47:39 PST Date: Wed, 17 Jan 2007 10:47:39 -0800 (PST) From: Andrew Edson Subject: Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-638816350-1169059659=:98529" Content-Transfer-Encoding: 8bit Message-ID: <704577.98529.qm@web34212.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/136 X-Sequence-Number: 24292 --0-638816350-1169059659=:98529 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I was requested to load data (a full copy of the db in question) from one postgres database into another (empty) db on another system. Both of these systems are running SuSE 9.2 Linux, for the record. It turned out that the two systems were running different versions of postgres; the first system (the one that needed the data) was running version 7.4.9, while the other system was (and is) running 8.1.3. I copied the 8.1.3 installation packet over to the first computer, and tried to install it. Originally, when starting the (supposed) 8.1.3 pg_ctl, I got an error about tcpip_socket. A search on the postgres site lead me to believe I could remedy the problem by uninstalling the older version of postgres. I proceded in the following order: swap to the installation directory for 8.1.3, make uninstall, make distclean, swap to the 7.4.9 installation directory, make uninstall, make distclean, swap back to 8.1.3, configure, make, make install. I still got the error, though. I finally found it mentioned in the postgres.conf file, and commented out the line. Next, I was told that my data files were initialized in 7.4, despite my earlier efforts, and after renaming the old folder, I went back and repeated the steps of (8.1.3)make uninstall, make distclean, configure, make, make install. However, there is no data directory in the base postgres directory now, only the older renamed one. If anyone can tell me what to do to get this system back up and running, I would appreciate it greatly. If more information is needed, I will be happy to supply as much as I can. Thank you for your consideration. --------------------------------- Access over 1 million songs - Yahoo! Music Unlimited. --0-638816350-1169059659=:98529 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
I was requested to load data (a full copy of the db in question) from one postgres database into another (empty) db on another system.  Both of these systems are running SuSE 9.2 Linux, for the record.  It turned out that the two systems were running different versions of postgres; the first system (the one that needed the data) was running version 7.4.9, while the other system was (and is) running 8.1.3.  I copied the 8.1.3 installation packet over to the first computer, and tried to install it.
 
Originally, when starting the (supposed) 8.1.3 pg_ctl, I got an error about tcpip_socket.  A search on the postgres site lead me to believe I could remedy the problem by uninstalling the older version of postgres.  I proceded in the following order: swap to the installation directory for 8.1.3, make uninstall, make distclean, swap to the 7.4.9 installation directory, make uninstall, make distclean, swap back to 8.1.3, configure, make, make install.  I still got the error, though.  I finally found it mentioned in the postgres.conf file, and commented out the line.  Next, I was told that my data files were initialized in 7.4, despite my earlier efforts, and after renaming the old folder, I went back and repeated the steps of (8.1.3)make uninstall, make distclean, configure, make, make install.  However, there is no data directory in the base postgres directory now, only the older renamed one.
 
If anyone can tell me what to do to get this system back up and running, I would appreciate it greatly.  If more information is needed, I will be happy to supply as much as I can.
 
Thank you for your consideration.


Access over 1 million songs - Yahoo! Music Unlimited. --0-638816350-1169059659=:98529--