Re: Recovery - transaction logs - Mailing list pgsql-admin

From Andy Marden
Subject Re: Recovery - transaction logs
Date
Msg-id a3r1nj$dp2$1@news.tht.net
Whole thread Raw
Responses Re: Recovery - transaction logs
Re: Recovery - transaction logs
Re: Recovery - transaction logs
List pgsql-admin
Does no one consider this to be a problem? You kinda wonder about PostgreSQL
being used as serious commercial database then don't you?

Me again.

"Andy Marden" <amarden@usa.net> wrote in message
news:a3dpjt$1l1s$1@news.tht.net...
> Putting together a system at the moment with a combination of batch loads
> and user online modification of data, with PostgreSQL version 7.1.3. I'm
> looking at recovery aspects at the moment. All I can see is pg_dump and
> pg_restore at the moment, which is fine for batch loads once a day, but if
> the database crashes halfway through the day then user modifications will
be
> lost.
>
> Is there the equivalent of Oracle's archived redo logs in PostgreSQL and
> commands to allow recovery up to the last (or any) point in time. I've
seen
> pg_xlog files mentioned.
>
> The recovery section of the manuals is 'under construction' it seems.
>
> Thanks for your help.
>
> Cheers
>
> Andy Marden
>
>



pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Two tables with same name in different user not allowed
Next
From: Manuel Trujillo
Date:
Subject: starting log problems