Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 46A812E009B for ; Thu, 20 Mar 2008 02:29:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 35704-04 for ; Thu, 20 Mar 2008 02:29:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 9D3DA2E0095 for ; Thu, 20 Mar 2008 02:29:09 -0300 (ADT) Received: from [192.168.1.44] (S010600a08330057a.ok.shawcable.net [24.67.72.171]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m2K5TcWl029872 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 19 Mar 2008 22:29:39 -0700 Subject: Re: Cannot start PGSQL From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: smp Cc: pgsql-admin@postgresql.org In-Reply-To: <212510.59939.qm@web7908.mail.in.yahoo.com> References: <212510.59939.qm@web7908.mail.in.yahoo.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-ofF8YWgktrfFhZ6qmcl8" Organization: Command Prompt, Inc. Date: Wed, 19 Mar 2008 22:29:00 -0700 Message-Id: <1205990941.16612.181.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.12.3 (2.12.3-3.fc8) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 19 Mar 2008 22:29:39 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/157 X-Sequence-Number: 28640 --=-ofF8YWgktrfFhZ6qmcl8 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi, On Thu, 2008-03-20 at 10:54 +0530, smp wrote: > FATAL: database files are incompatible with server > DETAIL: The database cluster was initialized with PG_CONTROL_VERSION > 71, but the server was compiled with PG_CONTROL_VERSION 812. > HINT: It looks like you need to initdb. You have an old (7.1) version installed on that directory. If you took backups, you need to remove /var/lib/pgsql/data directory, recreate it with postgres user, and initdb that directory before you can start PostgreSQL. Probably: service postgresql initdb service postgresql start will do the work for you. Regards, Regards, --=20 Devrim G=C3=9CND=C3=9CZ , RHCE PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/ --=-ofF8YWgktrfFhZ6qmcl8 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQBH4fYbpme12CBXnxERAqEtAJ9xJFDXd1jQ/2JFhqxvNUCiqPt1fACgp1uj s1f/yjR93/P9CBoUU6yNKEQ= =99ff -----END PGP SIGNATURE----- --=-ofF8YWgktrfFhZ6qmcl8--