Postgresql v6.5.2 - postgresql.jar
The ResultSet metadata function getColumnDisplaySize() is returning the number of
characters in the column's name.
I don't THINK SO.
1. The JavaDocs say it's supposed to be the "the column's normal max width in chars".
I take this as the DATA width, not
Z20:20 0:00 (postmaster
> )
> postgres 6701 0.0 0.1 840 352 p4 S20:21 0:00 grep postmaster
>
> [postgres@postgres data]$ more pg.stderr
> ERROR: postmaster: StreamConnection: accept: Invalid argument
>
> I think that to understand this error could be v
en start up the system, shut it down. Revert to the old
startup script and send the pg.stdout and pg.stderr files.
regards,
Tim Holloway
Lucio Andres Perez wrote:
>
> Hi everyone,
>
> Maybe this could be a newbie trouble for somebody, but I´ve tried all I
> can and I hav
intelligent operation, like RAID. The ultimate
test, though, is whether anyone would notice which of the two database
copies were being used.
What you're proposing is something like what I'd call
"transaction cloning", except that it sounds like you're using the DBMS's
external processes instead of having the work being done by internal processes
invisible to the user (?)
regards,
Tim Holloway
nt.
In that regard, you might want to check out the pgsql-patches for the
"Industrial-Strength Logging" preview. Should this ever be integrated
onto PostgreSQL, I'd expect (in fact, I RESERVED) a couple of log messages
to be used to track SQL requests with the ability to determine what user
made them.
regards,
Tim Holloway
I believe what you want is:
psql> \i filename
psql> \? will list the meta-commands for you
Regards,
Tim Holloway
MTS Associates, Inc.
"Aaron J. Seigo" wrote:
>
> On Mon, 25 Oct 1999, Tim Holloway wrote:
> > hal Lynch wrote:
> > > Is it possible that someday there will be a need for more than 99 "items"
> > > in log classes 1-9?
> > >
> > > hal
> > >
hal Lynch wrote:
>
> >
> >Logging classes:
> >---
> >1xz - The PostgreSQL server
> >2xx - User-related information
> >3xx - Transaction information
> >4xx - EXPLAIN results (???)
> >9xx - General system alerts
> >1000-1999 debugging events
>
> Is it possible that someday there will
Following is an updated list of the messages to be channeled by the proposed logging
system.
THESE AND *ONLY* THESE are slated for implementation. If you have items you want
included, PLEASE LET ME KNOW! As it stands, this is a pretty minimal set.
Bear in mind that the logger is NOT a debugger.
Tom Lane wrote:
>
> Tim Holloway <[EMAIL PROTECTED]> writes:
> >> Note that logging into a table is harder than you might think.
>
> > I guess I should have mentioned - at least in its initial incarnation,
> > cowardice forbids me to attempt reading or wr
s and allow the administrator to alter
the filter mask.
Although, in truth, the channel design is pretty much the
same thing.
Tim Holloway
Tom Lane wrote:
>
> Tim Holloway <[EMAIL PROTECTED]> writes:
> > Request For Comments: Towards an industrial-strength
> > logging facility
>
> Sounds pretty good overall.
>
> > This depends. I like a console-style listing, as my needs are
> >
Request For Comments: Towards an industrial-strength
logging facility
1999-10-19, Tim Holloway [EMAIL PROTECTED]
Introduction.
PostgreSQL is a commercial-quality DBMS. However, one item
generally found in commercial DBMS's that
PostgreSQL has so far lacked has been a logging facility.
Ye
>
> > that. Having made that constraint, I see 3 contexts:
> >
> > 1) Server events. E.g.:
> > 2) User sessions.
> > 3) Transactions.
> >
>
> how about 3 different logs? pg_server.log, pg_sessions.log, pg_trans.log or
> something along those lines.. that way you could parse each file as they woul
ed about the exact format. I've got a
simple but powerful mechanism to allow custom message
formatting for each loggable event, including the ability to
internationalize.
I do want to have a good default format, however.
Comments? Questions? Rude remarks?
Tim Holloway
MTS Associates, Inc.
ly
like logging to be up to modern-day quality expectations (e.g. filterable, routable,
and securable) and to record not only basic session info, but statistical info to
assist in tuning.
So, returning to my own question. Is any such presently available that I'm ignorant
of, or, failing that,
may I be of assitance in realizing such a facility?
Tim Holloway
MTS Associates, Inc.
authentication
failed"
Query: Is there a feature I'm missing out on, or is an authentication logging facility
something that I can contribute?
Thanks,
Tim Holloway
MTS Associates, Inc.
17 matches
Mail list logo
