| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Curt Sampson <cjs(at)cynic(dot)net>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PGXLOG variable worthwhile? |
| Date: | 2002-09-25 19:57:03 |
| Message-ID: | 3D92150F.7B82A532@Yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"scott.marlowe" wrote:
> [...]
> But, I have a few more questions about the signature file solution. Is
> the signature file going to be updated by date or something everytime the
> database is started up and shut down? If not, then it's quite possible
> that someone could copy the pg_xlog dir somewhere, run it for a while,
> then they change it back to the base pg_xlog will the database know that
> those xlogs are stale and not start up, or will it start up and corrupt
> the database with the old xlogs? As long as there's a time stamp in both
> places it should work fine.
Good question. Actually, I think it'd be a perfect place and use
for a copy of the controlfile.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me. #
#==================================================
JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paesold | 2002-09-25 20:10:30 | Insert Performance |
| Previous Message | Bruce Momjian | 2002-09-25 19:44:31 | Re: PGXLOG variable worthwhile? |