Re: Database recovery.

From: Waqar Azeem <waqarazeem(dot)private(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Database recovery.
Date: 2011-03-24 12:39:48
Message-ID: AANLkTik0Z10PGG7jfNz_7k1WLspOHtJHPP8cuDaC-Gp_@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Karsten n' Raymond,

Finally, I change the logging in account to Local System account as
suggested in your URL. And then change it back to .\postgres
This magically worked for me.

I think ctrl+alt+del was a compulsory part of XP trouble shootings :)

-- Waqar

On Thu, Mar 24, 2011 at 5:10 PM, Waqar Azeem
<waqarazeem(dot)private(at)gmail(dot)com>wrote:

> my windows event viewer says:
>
> 2011-03-24 11:24:22 GMT FATAL: could not create lock file
> "postmaster.pid": Permission denied
>
> is this helpfull?
>
>
> On Thu, Mar 24, 2011 at 4:31 PM, Waqar Azeem <waqarazeem(dot)private(at)gmail(dot)com
> > wrote:
>
>> I copy the whole folder 'Data' to another PC where fresh postgresql 8.4 is installed (same as default config. that previous version have had)
>>
>>
>>
>> when i started the server got following ...
>>
>>
>> The postgresql-8.4 - PostgreSQL Server 8.4 service could not be started.
>>
>> The service did not report an error.
>>
>> More help is available by typing NET HELPMSG 3534.
>>
>> The start command returned an error (2)
>>
>> Press <return> to continue...
>>
>>
>> any clue?
>>
>>
>>
>> On 03/24/11 12:07 AM, Waqar Azeem wrote:
>>
>> My XP is crashed and now I have to take a full backup of my postgresql
>> 8.4
>>
>> I am used to get backup of ldf/mdf files in case of SQLServer
>>
>> Please let me know the right way of doing this for postgresql 8.4.
>>
>>
>> you need everything in the $PGDATA directory. On my system here, itsD:\Postgres\8.4\data
>> but of course, your mileage may vary.
>>
>>
>> On Thu, Mar 24, 2011 at 12:07 PM, Waqar Azeem <
>> waqarazeem(dot)private(at)gmail(dot)com> wrote:
>>
>>> My XP is crashed and now I have to take a full backup of my postgresql
>>> 8.4
>>>
>>> I am used to get backup of ldf/mdf files in case of SQLServer
>>>
>>> Please let me know the right way of doing this for postgresql 8.4.
>>>
>>> --
>>> Thanks & Best Regards,
>>> Waqar Azeem
>>>
>>
>>
>>
>> --
>> Thanks & Best Regards,
>> Waqar Azeem
>>
>
>
>
> --
> Thanks & Best Regards,
> Waqar Azeem
>

--
Thanks & Best Regards,
Waqar Azeem

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Harald Armin Massa 2011-03-24 13:05:32 Re: Database recovery.
Previous Message Pavel Stehule 2011-03-24 12:26:57 Re: DO Statement Body Parameters