From: venkat ramana <venkat_uppala@hotmail.com>
To: jan-peter.seifert@gmx.de
Cc: PG Admin <pgsql-admin@postgresql.org>
Subject: Re: Application Error on setting archive_mode to on
Date: Sun, 8 Mar 2009 11:09:20 +0530
Message-ID: <BAY108-W50A90C2AA4D5E19154A17F8AA30@phx.gbl> (raw)
In-Reply-To: <49B2785C.5060206@gmx.de>
References: <BAY108-W5585A5353DF0C25762AF0E8AA20@phx.gbl>
<49B2785C.5060206@gmx.de>
I am using postgres 8.3 on windows
The original issue i mentioned below got resolved, but encountered a new issue and here too with postgres service.
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 destination.
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 it to the data directory.
3. Started postgres service. After a while, 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, the log file says, recovery is succesful.
5. After this i tried to stop the postgres service, the service is not stopping. I tried this after rebooting the machine also, still facing the same problem.
Any help towards this is highly appreciated.
Thanks
Venkat.
> Date: Sat, 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
>
> Hello Venkat,
>
> > After setting the archive parameter 'archive_mode' to on in
> > postgres.conf file, i started the posgres service. On starting the
> > service, getting error with message "The application failed to
> > initialize properly (0x0000142). Click on OK to terminate the
> > application". After this error, postgres service is not starting even
> > after restarting windows.
> > Any help on this is highly appreciated.
>
> 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 ...
>
> Good luck,
>
> Peter
_________________________________________________________________
So many new options, so little time. Windows Live Messenger.
http://www.microsoft.com/india/windows/windowslive/messenger.aspx=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: venkat_uppala@hotmail.com, jan-peter.seifert@gmx.de
Subject: Re: Application Error on setting archive_mode to on
In-Reply-To: <BAY108-W50A90C2AA4D5E19154A17F8AA30@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox