| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Losing data |
| Date: | 2008-06-19 22:15:06 |
| Message-ID: | 1213913706.8492.9.camel@jd-laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2008-06-19 at 20:29 +0100, Garry Saddington wrote:
> On Thursday 19 June 2008 19:03, Joshua D. Drake wrote:
> > On Thu, 2008-06-19 at 19:06 +0100, Garry Saddington wrote:
> > > On Thursday 19 June 2008 18:15, Alan Hodgson wrote:
> > > > On Thursday 19 June 2008, Garry Saddington
> <garry(at)schoolteachers(dot)co(dot)uk>
> >
> PS
> Could it be somethiing to do with libpq.so.4/5 required by psycopg and will
I think it certainly has something to do with psycopg and the way it
handles commits. Especially based on the description of what you say
above where some work and some don't. My guess (as I mentioned
previously) is there is a bit of code in your report generator that
doesn't call commit correctly.
> the WAL hold data to be replayed?
Only if you are pushing the logs off for standby operations and only if
you commit.
Sincerely,
Joshua D. Drake
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Thoen | 2008-06-19 22:54:34 | Importing undelimited files (Flat Files or Fixed-Length records) |
| Previous Message | Sam Mason | 2008-06-19 21:14:45 | Re: finding firstname + lastname groups |