Re: Database recovery.

[Waqar Azeem <waqarazeem.private@xxxxxxxxx>]

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@xxxxxxxxx> 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