Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9A48E9FC21D for ; Fri, 26 Oct 2007 02:52:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 30890-09 for ; Fri, 26 Oct 2007 02:52:08 -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.181]) by postgresql.org (Postfix) with ESMTP id E5F389FC063 for ; Fri, 26 Oct 2007 02:52:07 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id u77so1387580pyb for ; Thu, 25 Oct 2007 22:52:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=7ic/MPWVN0ZMaEFQt7IzUZrraFsY+cFbGcQTsJw6/HQ=; b=af1gTX9Hjd4zTp7jGji5gpDnUkDZ2J3i8yTvLeohxzOgO/cYy84YVwWK9y3dw1J5cBxp3ZcLwR7sp0Qg1RiEtWWS7tRcfRkvIFqKCPwQISf9nKmBR+D49hCxH3Mv6DdavtLfmETPYY+8hXKxaXZKdYNSM5uQ3zBimPn0kNAGTsI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=l/tjSbde3RUvROja6YJkkfYdfE7xgYwL/8oVrBtltVy1o0zEAy3QjqalSCQcJDnOddZiSpFu3NWRYYgEzqs8cc0EliD3WCp08BmM/Q/CuLlGL/Fskj/7tZfwoO/vGAHUIYrdeET0WxgxbIivIu5gnvtpd7mRSWqqvMnGc06GrWg= Received: by 10.35.51.19 with SMTP id d19mr2989134pyk.1193377926756; Thu, 25 Oct 2007 22:52:06 -0700 (PDT) Received: by 10.35.106.19 with HTTP; Thu, 25 Oct 2007 22:52:06 -0700 (PDT) Message-ID: Date: Thu, 25 Oct 2007 22:52:06 -0700 From: "David Young" To: pgsql-admin@postgresql.org Subject: 32-bit to 64-bit migration screwup MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4805_8152437.1193377926747" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/259 X-Sequence-Number: 27173 ------=_Part_4805_8152437.1193377926747 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline All, I was hoping someone can help me fix a big blunder. I recently bought a new system to replace the old one. The new system is running 64bit linux and the old one 32bit. I installed PG 64-bit and tried to bring the old database back up. Even though I'm running the same version of PG, it is giving me an error when I try to start it back up. below is the message from pgstartup.log. It looks like it doesn't recognize the control file anymore. Am I screwed? I don't have the old system anymore and I didn't do a dump. I figure if I'm running the same version of PG, the data will come back up correctly. If someone can help me out of this jam, I would greatly appreciate it. Thanks, David ------------------pgstartup.log--------------- The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale en_US.UTF-8. The default database encoding has accordingly been set to UTF8. fixing permissions on existing directory /var/lib/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers/max_fsm_pages ... 24MB/153600 creating configuration files ... ok creating template1 database in /var/lib/pgsql/data/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating conversions ... ok setting privileges on built-in objects ... ok creating information schema ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok Success. You can now start the database server using: /usr/bin/postgres -D /var/lib/pgsql/data or /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start LOG: logger shutting down LOG: logger shutting down LOG: logger shutting down LOG: logger shutting down LOG: logger shutting down FATAL: incorrect checksum in control file FATAL: incorrect checksum in control file FATAL: incorrect checksum in control file ------=_Part_4805_8152437.1193377926747 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
All,
 
I was hoping someone can help me fix a big blunder.  I recently bought a new system to replace the old one.  The new system is running 64bit linux and the old one 32bit.  I installed PG 64-bit and tried to bring the old database back up.  Even though I'm running the same version of PG, it is giving me an error when I try to start it back up.  below is the message from pgstartup.log.  It looks like it doesn't recognize the control file anymore.
 
Am I screwed?  I don't have the old system anymore and I didn't do a dump.  I figure if I'm running the same version of PG, the data will come back up correctly.  If someone can help me out of this jam, I would greatly appreciate it.
 
Thanks,
David
 
------------------pgstartup.log---------------

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale en_US.UTF-8.
The default database encoding has accordingly been set to UTF8.

fixing permissions on existing directory /var/lib/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 24MB/153600
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

    /usr/bin/postgres -D /var/lib/pgsql/data
or
    /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

LOG:  logger shutting down
LOG:  logger shutting down
LOG:  logger shutting down
LOG:  logger shutting down
LOG:  logger shutting down
FATAL:  incorrect checksum in control file
FATAL:  incorrect checksum in control file
FATAL:  incorrect checksum in control file

------=_Part_4805_8152437.1193377926747--