Re: Database recovery.

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Database recovery.
Date: 2011-05-03 13:37:42
Message-ID: ipp0f6$83r$3@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2011-03-24, Waqar Azeem <waqarazeem(dot)private(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-05-03 13:42:02 Re: pervasiveness of surrogate (also called synthetic) keys
Previous Message raghu ram 2011-05-03 13:30:46 Re: Can we Flush the Postgres Shared Memory ?