Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9D2A8633A8A for ; Sun, 8 Mar 2009 01:39:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 67217-08 for ; Sun, 8 Mar 2009 01:39:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc2-s27.bay0.hotmail.com (bay0-omc2-s27.bay0.hotmail.com [65.54.246.163]) by mail.postgresql.org (Postfix) with ESMTP id 699DC63375E for ; Sun, 8 Mar 2009 01:39:22 -0400 (AST) Received: from BAY108-W50 ([65.54.162.150]) by bay0-omc2-s27.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Sat, 7 Mar 2009 21:39:21 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_031ae4e5-1578-4eff-85e2-67badfab2987_" X-Originating-IP: [122.169.242.82] From: venkat ramana To: CC: PG Admin Subject: Re: Application Error on setting archive_mode to on Date: Sun, 8 Mar 2009 11:09:20 +0530 Importance: Normal In-Reply-To: <49B2785C.5060206@gmx.de> References: <49B2785C.5060206@gmx.de> MIME-Version: 1.0 X-OriginalArrivalTime: 08 Mar 2009 05:39:21.0321 (UTC) FILETIME=[3B35C590:01C99FB0] 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: 200903/106 X-Sequence-Number: 31606 --_031ae4e5-1578-4eff-85e2-67badfab2987_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using postgres 8.3 on windows The original issue i mentioned below got resolved=2C but encountered a new = issue and here too with postgres service. =20 Details of the Scenario: ----------------------- 1. Took base backup of the database and then set the archive parameters in = postgres.conf file. Verified that WAL files are backedup to the set destina= tion. 2. Now i am trying to recover the database. I stopped the postgres service.= Updated the recovery.conf file with recovery_command details and copied i= t to the data directory.=20 3. Started postgres service. After a while=2C recovery config file name got= changed to recovery.done but i found that database is not restored. 4. Went to pg_log and verified that log files=2C the log file says=2C recov= ery is succesful. 5. After this i tried to stop the postgres service=2C the service is not st= opping. I tried this after rebooting the machine also=2C still facing the s= ame problem. =20 Any help towards this is highly appreciated. =20 Thanks Venkat. =20 > Date: Sat=2C 7 Mar 2009 14:36:28 +0100 > From: Jan-Peter.Seifert@gmx.de > To: venkat_uppala@hotmail.com > CC: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Application Error on setting archive_mode to on >=20 > Hello Venkat=2C >=20 > > After setting the archive parameter 'archive_mode' to on in > > postgres.conf file=2C i started the posgres service. On starting the > > service=2C getting error with message "The application failed to > > initialize properly (0x0000142). Click on OK to terminate the > > application". After this error=2C postgres service is not starting even > > after restarting windows. > > Any help on this is highly appreciated. >=20 > does the service start after setting archive_mode to off again? Which > version of PostgreSQL? There was problem with fragmented RAM/virtual > memory that prevented PostgreSQL from (re-)starting sometimes. So if you > don't have an actual PostgreSQL try rebooting the system ... > What do the Windows system logs say? Do you have anti-virus software > running? Google for the error code ... >=20 > Good luck=2C >=20 > Peter _________________________________________________________________ So many new options=2C so little time. Windows Live Messenger. http://www.microsoft.com/india/windows/windowslive/messenger.aspx= --_031ae4e5-1578-4eff-85e2-67badfab2987_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using postgres 8.3 on windows
The original issue i mentioned below got resolved=2C but encountered a new = issue and here too with postgres service.
 =3B
Details of the Scenario:
-----------------------
1. Took base backup of the database and then set the archive parameters in = postgres.conf file. Verified that WAL files are backedup to the set destina= tion.
2. Now i am trying to =3Brecover the database. I stopped the postgres s= ervice. =3B =3BUpdated the recovery.conf file with recovery_command= details and copied it to the data directory.
3. Started postgres service. After a while=2C recovery =3Bconfig file n= ame got changed to recovery.done but i found that database is not restored.=
4. Went to pg_log and verified that log files=2C the log file says=2C recov= ery is succesful.
5. After this i tried to =3Bstop the postgres service=2C the service is= not stopping. I tried this after rebooting =3Bthe machine also=2C stil= l facing the same problem.
 =3B
Any help towards this is highly appreciated.
 =3B
Thanks
Venkat.
 =3B
>=3B Date: Sat=2C 7 Mar 2009 14:36:28 +0100
>= =3B From: Jan-Peter.Seifert@gmx.de
>=3B To: venkat_uppala@hotmail.com<= BR>>=3B CC: pgsql-admin@postgresql.org
>=3B Subject: Re: [ADMIN] App= lication Error on setting archive_mode to on
>=3B
>=3B Hello Ven= kat=2C
>=3B
>=3B >=3B After setting the archive parameter 'arc= hive_mode' to on in
>=3B >=3B postgres.conf file=2C i started the po= sgres service. On starting the
>=3B >=3B service=2C getting error wi= th message "The application failed to
>=3B >=3B initialize properly = (0x0000142). Click on OK to terminate the
>=3B >=3B application". Af= ter this error=2C postgres service is not starting even
>=3B >=3B af= ter restarting windows.
>=3B >=3B Any help on this is highly appreci= ated.
>=3B
>=3B does the service start after setting archive_mod= e to off again? Which
>=3B version of PostgreSQL? There was problem wi= th fragmented RAM/virtual
>=3B memory that prevented PostgreSQL from (= re-)starting sometimes. So if you
>=3B don't have an actual PostgreSQL= try rebooting the system ...
>=3B What do the Windows system logs say= ? Do you have anti-virus software
>=3B running? Google for the error c= ode ...
>=3B
>=3B Good luck=2C
>=3B
>=3B Peter

So many new options=2C so little time. Windows= Live Messenger. = --_031ae4e5-1578-4eff-85e2-67badfab2987_--