From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Newbie <ketedfordspam@mailcity.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Log File?
Date: Fri, 13 Apr 2001 20:56:42 -0400 (EDT)
Message-ID: <200104140056.UAA19125@candle.pha.pa.us> (raw)
In-Reply-To: <eyKHhJvwAHA.200@cpmsnbbsa07>
You are asking for point-in-time recovery. That should be in 7.2.
> Our company is deciding whether to choose Postgresql or not and
> have a question. Say we back up our database every night and the
> next day at 11am, the hard drive crashes. We then have data from
> our back up from last night, but, is there a way to have a log file sitting
> somewhere
> other than the hard drive that will allow us to retrieve all data
> from that morning and add that data to the back up? Therefore, we
> will have only lost the trasaction that we would have been working
> on because it has not been commited. Any answer would be extremely helpful.
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: pgman@candle.pha.pa.us, ketedfordspam@mailcity.com
Subject: Re: Log File?
In-Reply-To: <200104140056.UAA19125@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox