| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Norberto Dellê <betodelle(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: WAL Archiving problem |
| Date: | 2007-09-01 17:17:13 |
| Message-ID: | 21918.1188667033@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
=?ISO-8859-1?Q?Norberto_Dell=EA?= <betodelle(at)gmail(dot)com> writes:
> I have a PostgreSQL 8.2.4 installation running under Windows XP with WAL
> archiving activated.
> But at some point Postgres began to ask to archive a WAL segment that
> isn't in the pg_xlog directory. I thought that a segment that isn't
> succesfully
> archived should remain in the pg_xlog directory, or am i wrong?
Do you have the postmaster log from around the time that this started
happening? I'm wondering about a file rename() failing, or some such.
What files do you have, exactly, in pg_xlog and pg_xlog/archive_status?
It'd be useful to see their modification timestamps as well as their
names.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2007-09-01 19:27:48 | Re: Export data to MS Excel |
| Previous Message | Tom Lane | 2007-09-01 17:09:32 | Re: JOIN issues (Left vs Right for sorting), and "Nested Loop" problem |