From smp762001@yahoo.co.in Thu Mar 20 04:43:57 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 082AB2E00A6 for ; Thu, 20 Mar 2008 01:43:57 -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 63740-09 for ; Thu, 20 Mar 2008 01:43:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web7910.mail.in.yahoo.com (web7910.mail.in.yahoo.com [202.86.4.86]) by postgresql.org (Postfix) with SMTP id B01182E00AB for ; Thu, 20 Mar 2008 01:43:53 -0300 (ADT) Received: (qmail 64932 invoked by uid 60001); 20 Mar 2008 04:37:11 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=AvbravvGkV16ctZ8Tj9PqSeEopdBg4FbhBNZFkvdOmShu9WxQGCb5eLT6rPR9/IthGZ05WabwNh+rTOn3pY6d5HtAwb3UVi+zcJQraQn3yRs/DDbOn7kmMS4kEY8QWhn2clhz1PbOLU1u0seSAMaLrSeguSLtRM0BHoC7TynSJs=; Received: from [203.199.114.33] by web7910.mail.in.yahoo.com via HTTP; Thu, 20 Mar 2008 10:07:10 IST X-Mailer: YahooMailRC/902.38 YahooMailWebService/0.7.185 Date: Thu, 20 Mar 2008 10:07:10 +0530 (IST) From: smp Subject: Cannot start PGSQL To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1508919751-1205987830=:64599" Message-ID: <245626.64599.qm@web7910.mail.in.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/154 X-Sequence-Number: 28637 --0-1508919751-1205987830=:64599 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I'm a novice & I'm trying to start posgtres by doing /etc/init.d/postgresql= start.=0A=0AIt starts.=0ABut the next min if i try to check the process by= doing ps -auwx | grep post, I dont see any process.=0A=0AMy installation i= s in /var/lib/pgsql/data.=0A=0AThere is nothing in serverlog.=0A=0AWhat can= be the reason?=0A=0AHow do i enable logging to serverlog=0A=0ATnx & regard= s,=0ASachin=0A=0A=0A Did you know? You can CHAT without downloading me= ssenger. Go to http://in.messenger.yahoo.com/webmessengerpromo.php/ --0-1508919751-1205987830=:64599 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I'm a novice & I'm trying to start posgtres by doi= ng /etc/init.d/postgresql start.
=0A
 
=0A
It starts= .
=0A
But the next min if i try to check the process by doing ps -= auwx | grep post, I dont see any process.
=0A
 
=0A
= My installation is in /var/lib/pgsql/data.
=0A
 
=0AThere is nothing in serverlog.
=0A
 
=0A
What can b= e the reason?
=0A
 
=0A
How do i enable logging to s= erverlog
=0A
 
=0A
Tnx & regards,
=0A
S= achin

=0A=0A=0A
Save all you= r chat conversations. Find them online.= --0-1508919751-1205987830=:64599-- From smp762001@yahoo.co.in Thu Mar 20 04:43:26 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0AB152E00A1 for ; Thu, 20 Mar 2008 01:43:26 -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 63740-08 for ; Thu, 20 Mar 2008 01:43:21 -0300 (ADT) X-Greylist: delayed 00:06:07.489048 by SQLgrey-1.7.5 Received: from web7907.mail.in.yahoo.com (web7907.mail.in.yahoo.com [202.86.4.83]) by postgresql.org (Postfix) with SMTP id 738A82E0051 for ; Thu, 20 Mar 2008 01:43:22 -0300 (ADT) Received: (qmail 82285 invoked by uid 60001); 20 Mar 2008 04:43:20 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=eSn2OY/OsOTH3SfBioidvjy2dCpeM8qg8+iAHHSFpINSsVA/wJT+kYyX5nDj+HT2cmXg7jzyJf5yWHVLgagUajbqTdCzIYl1gSHrCMnfVaIrUp7W8bOl1TKPu6p/vhy2eTC/yHcPkd+ZADDSM7pvsTKPoJ9L0rHnddXydxH1ZoA=; X-YMail-OSG: cTXU_cIVM1l5S6oVkUHKhSoZcy6q7I2ek8i5KTqIfsgOPdRBipdjJRJCodsPrzfc40PguO96gv5f1sOfV6GPmJOuH4z0MHVQa73X8elubk_3Bf4uIyLX3e0GmefWSA-- Received: from [203.199.114.33] by web7907.mail.in.yahoo.com via HTTP; Thu, 20 Mar 2008 10:13:20 IST X-Mailer: YahooMailRC/902.38 YahooMailWebService/0.7.185 Date: Thu, 20 Mar 2008 10:13:20 +0530 (IST) From: smp Subject: Cannot start PGSQL To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2056795378-1205988200=:81257" Message-ID: <306463.81257.qm@web7907.mail.in.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/153 X-Sequence-Number: 28636 --0-2056795378-1205988200=:81257 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I'm a novice & I'm trying to start posgtres by doing /etc/init.d/postgresql= start.=0A =0AIt starts.=0ABut the next min if i try to check the process b= y doing ps -auwx | grep post, I dont see any process.=0A =0AMy installation= is in /var/lib/pgsql/data.=0A =0AThere is nothing in serverlog.=0A =0AWhat= can be the reason?=0A =0AHow do i enable logging to serverlog=0A =0ATnx & = regards,=0ASachin=0A=0A=0A Share files, take polls, and discuss your p= assions - all under one roof. Go to http://in.promos.yahoo.com/groups --0-2056795378-1205988200=:81257 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
=0A
I'm a novice & I'm trying to start po= sgtres by doing /etc/init.d/postgresql start.
=0A
 
=0A<= DIV>It starts.
=0A
But the next min if i try to check the process = by doing ps -auwx | grep post, I dont see any process.
=0A
 <= /DIV>=0A
My installation is in /var/lib/pgsql/data.
=0A
 =
=0A
There is nothing in serverlog.
=0A
 
=0AWhat can be the reason?
=0A
 
=0A
How do i enable= logging to serverlog
=0A
 
=0A
Tnx & regards,=0A
Sachin

=0A=0A=0A
Now you can chat without downloading messenger. Click here to know how. --0-2056795378-1205988200=:81257-- From devrim@CommandPrompt.com Thu Mar 20 04:55:31 2008 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C7BCA2E0054 for ; Thu, 20 Mar 2008 01:55:31 -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 35500-01 for ; Thu, 20 Mar 2008 01:54:46 -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 852932E00A2 for ; Thu, 20 Mar 2008 01:49:14 -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 m2K4nhXB027150 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 19 Mar 2008 21:49:44 -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: <245626.64599.qm@web7910.mail.in.yahoo.com> References: <245626.64599.qm@web7910.mail.in.yahoo.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-uUJFz9CyMOUPb60qDtFR" Organization: Command Prompt, Inc. Date: Wed, 19 Mar 2008 21:49:06 -0700 Message-Id: <1205988546.16612.177.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 21:49:44 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/155 X-Sequence-Number: 28638 --=-uUJFz9CyMOUPb60qDtFR Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi, On Thu, 2008-03-20 at 10:07 +0530, smp wrote: >=20 > There is nothing in serverlog. >=20 > What can be the reason? Check /var/lib/pgsql/pgstartup.log , if it exists. 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/ --=-uUJFz9CyMOUPb60qDtFR 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) iD8DBQBH4ey/pme12CBXnxERAq6TAJoDex1FN1CONMnb+G+90UkDZ2K9nwCdFNZP GSJ6JnC6lMyAMSLh3p1r2bo= =7JPc -----END PGP SIGNATURE----- --=-uUJFz9CyMOUPb60qDtFR-- From smp762001@yahoo.co.in Thu Mar 20 05:24:15 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D44392E0073 for ; Thu, 20 Mar 2008 02:24:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06992-05 for ; Thu, 20 Mar 2008 02:24:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web7908.mail.in.yahoo.com (web7908.mail.in.yahoo.com [202.86.4.84]) by postgresql.org (Postfix) with SMTP id A16842E0067 for ; Thu, 20 Mar 2008 02:24:12 -0300 (ADT) Received: (qmail 60302 invoked by uid 60001); 20 Mar 2008 05:24:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID; b=XFTPR4Xzb9B0GGHqzs3TPrGPCMrqi2zZBTl+5nS5qmB3e8Qbin0ZdxAYD2i3TEOoWz5sMAVWKqMmSpbgcmO9NTKWEHAcveLhKrhZxI5ndxeOimdroMj0xssxfACJZHv6CBnBFIVPdXbyT4t5jDt5AhLiPsfyqrPUF9Ihj/NF8K0=; X-YMail-OSG: Yg_q._wVM1k1ROhelI98z0wvhMAdCtYyEKWd3RtT68eMhzTcE0QiQfCa2g4YYLFTS115P5aj0Ov1DPosJiBB7eCEWw-- Received: from [203.199.114.33] by web7908.mail.in.yahoo.com via HTTP; Thu, 20 Mar 2008 10:54:10 IST X-Mailer: YahooMailRC/902.38 YahooMailWebService/0.7.185 Date: Thu, 20 Mar 2008 10:54:10 +0530 (IST) From: smp Subject: Re: Cannot start PGSQL To: =?iso-8859-1?Q?Devrim_G=DCND=DCZ?= Cc: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-714137553-1205990650=:59939" Message-ID: <212510.59939.qm@web7908.mail.in.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200803/156 X-Sequence-Number: 28639 --0-714137553-1205990650=:59939 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable i get message as below=0A=0AFATAL: database files are incompatible with se= rver=0ADETAIL: The database cluster was initialized with PG_CONTROL_VERSIO= N 71, but the server was compiled with PG_CONTROL_VERSION 812.=0AHINT: It = looks like you need to initdb.=0A=0A=0A=0A=0A----- Original Message ----=0A= From: Devrim G=DCND=DCZ =0ATo: smp =0ACc: pgsql-admin@postgresql.org=0ASent: Thursday, 20 March, 2008= 10:19:06 AM=0ASubject: Re: [ADMIN] Cannot start PGSQL=0A=0AHi,=0A=0AOn Thu= , 2008-03-20 at 10:07 +0530, smp wrote:=0A> =0A> There is nothing in server= log.=0A> =0A> What can be the reason?=0A=0ACheck /var/lib/pgsql/pgstartup.l= og , if it exists.=0A=0ARegards,=0A-- =0ADevrim G=DCND=DCZ , RHCE=0APostgre= SQL Replication, Consulting, Custom Development, 24x7 support=0AManaged Ser= vices, Shared and Dedicated Hosting=0ACo-Authors: plPHP, ODBCng - http://ww= w.commandprompt.com/=0A=0A=0A Download prohibited? No problem. CHAT fr= om any browser, without download. Go to http://in.messenger.yahoo.com/webme= ssengerpromo.php/ --0-714137553-1205990650=:59939 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
i get message as below
=0A
 =0A
FATAL:  database files are incompatible with serverDETAIL:  The database cluster was initialized with PG_CONTROL_VERSIO= N 71, but the server was compiled with PG_CONTROL_VERSION 812.
HINT:&nbs= p; It looks like you need to initdb.
=0A



 =0A
----- Original Message ----
From: Devrim G=DCND=DCZ <= ;devrim@CommandPrompt.com>
To: smp <smp762001@yahoo.co.in>
C= c: pgsql-admin@postgresql.org
Sent: Thursday, 20 March, 2008 10:19:06 AM=
Subject: Re: [ADMIN] Cannot start PGSQL

Hi,

On Thu, 2008-= 03-20 at 10:07 +0530, smp wrote:
>
> There is nothing in serve= rlog.
>
> What can be the reason?

Check /var/lib/pgsql/= pgstartup.log , if it exists.

Regards,
--
Devrim G=DCND=DCZ ,= RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 suppo= rt
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, = ODBCng - http://w= ww.commandprompt.com/
=0A


=0A=0A= =0A
5, 50, 500, 5000 - Store N number of ma= ils in your inbox. Click here.= --0-714137553-1205990650=:59939-- From devrim@CommandPrompt.com Thu Mar 20 05:29:12 2008 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--