Re: Database recovery.

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.private@gmail.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.private@gmail.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.private@gmail.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