Re: Database recovery. - Mailing list pgsql-general

From Jasen Betts
Subject Re: Database recovery.
Date
Msg-id ipp0f6$83r$3@reversiblemaps.ath.cx
Whole thread Raw
In response to Database recovery.  (Waqar Azeem <waqarazeem.private@gmail.com>)
List pgsql-general
On 2011-03-24, Waqar Azeem <waqarazeem.private@gmail.com> wrote:
> --0015174766a0ffbf86049f35206e
> Content-Type: text/plain; charset=ISO-8859-1
>
> 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 the data directory, and the service user "postgres" needs to
own it's contents.   consider using runas and xcopy.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: converting databases form SQL_ASCII to UTF8
Next
From: John R Pierce
Date:
Subject: Re: Bidirectional replication