| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: COPYable logs status |
| Date: | 2007-06-08 16:02:53 |
| Message-ID: | 46697DAD.9020507@zeut.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Andrew Dunstan wrote:
> The situation with this patch is that I now have it in a state where I
> think it could be applied, but there is one blocker, namely that we do
> not have a way of preventing the interleaving of log messages from
> different backends, which leads to garbled logs. This is an existing
> issue about which we have had complaints, but it becomes critical for a
> facility the whole purpose of which is to provide logs in a format
> guaranteed to work with our COPY command.
>
> Unfortunately, there is no solution in sight for this problem, certainly
> not one which I think can be devised and implemented simply at this
> stage of the cycle. The solution we'd like to use, LWLocks, is not
> workable in his context. In consequence, I don't think we have any
> option but to shelve this item for the time being.
I think this will get shot down, but here goes anyway...
How about creating a log-writing-process? Postmaster could write to the
log files directly until the log-writer is up and running, then all
processes can send their log output through the log-writer.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Pavlov | 2007-06-08 16:30:21 | Re: query log corrupted-looking entries |
| Previous Message | Alvaro Herrera | 2007-06-08 15:14:52 | Re: Autovacuum launcher doesn't notice death of postmaster immediately |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-06-08 16:22:02 | Re: Synchronized scans |
| Previous Message | Tom Lane | 2007-06-08 15:31:22 | Re: Synchronized scans |