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 11:31:19
Message-ID: AANLkTi==Z85kYHmSVd2zto=mjfCcbL0q=LmL2N_KO3x9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2011-03-24 11:37:25 Re: Database recovery.
Previous Message Altmann, Sebastian 2011-03-24 11:26:30 Re: [RMX:#] Re: Strange loss of data during INSERT