Re: [HACKERS] SSL renegotiation

2013-07-10 Thread Stuart Bishop
1 PDT LOG: record with zero length at 1C5/95D2FE00 Now I'm running Ubuntu 12.04 LTS (Precise) with openssl 1.0.1, and I think all the known renegotiation issues have been dealt with. I still get failures, but they are less informative: 2013-03-15 03:55:12 UTC LOG: SSL renegotiation f

Re: [HACKERS] [BUGS] BUG #6532: pg_upgrade fails on Python stored procedures

2012-03-16 Thread Stuart Bishop
we need is for pg_dumpall to _not_ output those handlers. Or pick it up in the check stage and make the user resolve the problem. If I shot myself in the foot in some particularly obtuse way, it might not be sane to bend over backwards making pg_upgrade repair things. -- Stuart Bishop http://

Re: [HACKERS] storing TZ along timestamps

2011-07-08 Thread Stuart Bishop
pm or 7pm depending on the policical edicts. If you are only storing past events, its not normally an issue but timezone information does occasionally get changed retroactively if errors are discovered. -- Stuart Bishop http://www.stuartbishop.net/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Indent authentication overloading

2010-11-17 Thread Stuart Bishop
hose keys being reused by accounts that shouldn't be reusing them. Please don't deprecate it unless there is an alternative. And if you are a pg_pool or pgbouncer maintainer, please consider adding support :) -- Stuart Bishop http://www.stuartbishop.net/ -- Sent via pgsql-hackers mai

Re: [HACKERS] Time-based Releases WAS: 8.5 release timetable, again

2009-09-08 Thread Stuart Bishop
s). There was some flak but we are still here. I personally suspect PostgreSQL would want a 1 year cycle for major releases while a full dump/reload is required for upgrades. When this changes, 6 or even 4 months might actually be a good fit. -- Stuart Bishop http://www.stuartbishop.net/

Re: [HACKERS] Time-based Releases WAS: 8.5 release timetable, again

2009-09-08 Thread Stuart Bishop
might end up to a similar process to GNU Bazaar except with yearly major releases and 2 month development releases, documented at http://doc.bazaar-vcs.org/latest/developers/cycle.html. This is a smaller project, but had to address a number of similar concerns that PostgreSQL would have to so may b

Re: [HACKERS] WIP: plpython3

2009-07-24 Thread Stuart Bishop
ain(pg, i): return i $python$; Thoughts? [...it still has a *long* ways to go =] I tend to dislike magic function names, but perhaps it is the most usable solution. -- Stuart Bishop http://www.stuartbishop.net/ signature.asc Description: OpenPGP digital signature

Re: [HACKERS] Re: [GENERAL] pgstattuple triggered checkpoint failure and database outage?

2009-03-31 Thread Stuart Bishop
ption to be raised personally. > I'm ok with returning NULLs as well, but returning zeroes doesn't feel > right. -- Stuart Bishop http://www.stuartbishop.net/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Re: [GENERAL] pgstattuple triggered checkpoint failure and database outage?

2009-03-30 Thread Stuart Bishop
return zeroes (or perhaps > nulls?).  Neither one is tremendously appetizing.  The former would > be especially unhelpful if someone tried to write a query to apply > pgstattuple across all pg_class entries, which I kinda suspect is > what Stuart did. This is exactly what happened, and tempo

Re: [HACKERS] Security and Data Protection Issues

2008-07-10 Thread Stuart Gundry
Thank you, I'm also curious as to whether the data folder is already in some way encrypted and if so, what encryption/obfuscation is being used. There doesn't seem to be anything about this on the web.

[HACKERS] Security and Data Protection Issues

2008-07-09 Thread Stuart Gundry
I am setting up a postgres database on a standalone system with a randomized text password. However, the db will contain very sensitive data and my boss is worried about the possibility of someone being able to crack the db data if they stole the machine. Can anyone point me to information about ho

Re: [HACKERS] [GENERAL] ANALYZE getting dead tuple count hopelessly wrong

2008-04-07 Thread Stuart Brooks
tgres -22 -2 4896K4K mclpl 0:11 0.00% 0.00% I'm not convinced this is a postgresql bug (state=mclpl concerns me), but it's the first time I've seen it. I suppose it could be: http://www.netbsd.org/cgi-bin/query-pr-single.pl?number=35224. Anything I can do whi

Re: [HACKERS] [GENERAL] ANALYZE getting dead tuple count hopelessly wrong

2008-04-01 Thread Stuart Brooks
applied the patch and have started my test again, it takes a little while to fill up so I should have the results sometime tomorrow. Thanks for the quick response. Stuart -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] [GENERAL] ascii() for utf8

2007-07-31 Thread Stuart McGraw
From: Alvaro Herrera > Decibel! wrote: > > Moving to -hackers. > > > > On Jul 27, 2007, at 1:22 PM, Stuart wrote: > >> Does Postgresql have a function like ascii() that will > >> return the unicode codepoint value for a utf8 character? > >> (And

Re: [HACKERS] elog(FATAL) vs shared memory

2007-04-12 Thread Stuart Bishop
t; > There is a pg_backend_pid() function, even if it's not documented with > the other functions (it's in the stats function stuff for some reason). eh. No worries - my safeguard is just a comment saying 'don't connect to the same database you are

Re: [HACKERS] elog(FATAL) vs shared memory

2007-04-09 Thread Stuart Bishop
Tom Lane wrote: > Stuart Bishop <[EMAIL PROTECTED]> writes: >> After a test is run, the test harness kills any outstanding connections so >> we can drop the test database. Without this, a failing test could leave open >> connections dangling causing the drop database to

Re: [HACKERS] elog(FATAL) vs shared memory

2007-04-06 Thread Stuart Bishop
Mark Shuttleworth wrote: > Tom Lane wrote: >> (1) something (still not sure what --- Martin and Mark, I'd really like >> to know) was issuing random SIGTERMs to various postgres processes >> including autovacuum. >> > > This may be a misfeature in our te

Re: [HACKERS] Is Patch Ok for deferred trigger disk queue?

2003-07-28 Thread Stuart
same purpose, to force thing to disk when we consume enough RAM. --- Bruce Momjian wrote: Stuart, were are on this patch? Seems we need GUC additions, though I can do that for you, and changes to write the head to disk. Was

Re: [HACKERS] Is Patch Ok for deferred trigger disk queue?

2003-07-01 Thread Stuart
Also I've noticed that there is an fd.h which has file routines which I should be using rather than the stdio routines. I will also clean up those errors. Thank you, - Stuart ---(end of broadcast)--- TIP 6: Have you searched o

Re: [HACKERS] [CYGWIN] command

2002-11-05 Thread Henshall, Stuart - Design & Print
Title: RE: [CYGWIN] command Florian Litot wrote: > what is the command to launch a sql script not in psql thanks > > psql is used to execute sql scripts as follows: psql -f hth, - Stuart

Re: [HACKERS] tell Bugtraq about 7.2.2

2002-08-28 Thread Henshall, Stuart - WCP
Title: RE: [HACKERS] tell Bugtraq about 7.2.2 oops, sorry your correct. - Stuart > -Original Message- > From: Gavin Sherry [mailto:[EMAIL PROTECTED]] > Sent: 28 August 2002 15:57 > To: Marc G. Fournier > Cc: Henshall, Stuart - WCP; '[EMAIL PROTECTED]' >

Re: [HACKERS] tell Bugtraq about 7.2.2

2002-08-28 Thread Henshall, Stuart - WCP
Title: RE: [HACKERS] tell Bugtraq about 7.2.2 No idea sorry :( - Stuart > -Original Message- > From: Marc G. Fournier [mailto:[EMAIL PROTECTED]] > Sent: 28 August 2002 15:36 > To: Henshall, Stuart - WCP > Cc: '[EMAIL PROTECTED]' > Subject: Re: [HACKE

[HACKERS] tell Bugtraq about 7.2.2

2002-08-28 Thread Henshall, Stuart - WCP
Title: tell Bugtraq about 7.2.2 Does someone from core want to inform bugtraq about 7.2.2? Cheers, - Stuart Westcountry Design & Print, Heron Road, Sowton, Exeter. EX2 7NF - also at - 17 Brest Road, Derriford, Plymouth. PL6 5AA England www.westcountry-design-print.co.uk

Re: [HACKERS] Abort state on duplicated PKey in transactions

2001-09-10 Thread Henshall, Stuart - WCP
x27;d know the primary key already existed and if rc=1 then it would have inserted succesfully - Stuart "Haoldo Stenger" wrote: > "Matthew T. O'Connor" wrote: > > > > > A solution, could be to query for the existance of the PK, just before > the >

Re: [HACKERS] Porting to Native WindowsNT/2000

2001-09-03 Thread Henshall, Stuart - WCP
ervice. There's a slight hiccup on shutdown meaning that the postmaster.pid file gets left. This is due to sighup being sent by windows shutdown. I think current cygwin snapshots might cure this, otherwise there is a patch some where that causes SIGHUP to be ignored. I *think* the pre-built binary already has this patch applied. - Stuart ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

RE: [HACKERS] RE: OID wraparound (was Re: pg_depend)

2001-07-24 Thread Henshall, Stuart - WCP
ld have to be placed into the OID in all places it could be referenced (for WHERE clauses,etc...). It'd only work on those tables that had int4 priamary keys, but I suspect thats a fair few. I don't know wether this'd be worth while, but was rather throwing it out for thought. - Stuart

[HACKERS] RE: OID wraparound (was Re: pg_depend)

2001-07-23 Thread Henshall, Stuart - WCP
Would it be possible to offer an option for the OID column to get its value from an int4 primary key (settable on a per table basis maybe)? - Stuart > -Original Message- > From: Hiroshi Inoue [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, July 21, 2001 7:31 AM > To: Zeugswette

[HACKERS] RE: Row Versioning, for jdbc updateable result sets

2001-06-15 Thread Henshall, Stuart - WCP
Don't know about JDBC, but couldn't you just use UPDATE SET = WHERE xmin= AND primarykey= and get the number of altered records? (if its zero then you know somethings wrong and can investigate further) - Stuart > -Original Message- > From: Dave Cramer [SMTP:[EMAIL PR

[HACKERS] RE: Plans for solving the VACUUM problem

2001-05-21 Thread Henshall, Stuart - WCP
Apologises if I've missed something, but isn't that the same xmin that ODBC uses for row versioning? - Stuart > Currently, the XMIN/XMAX command counters are used only by the current > transaction, and they are useless once the transaction finishes and take >

[HACKERS] Split Distro

2001-04-09 Thread Henshall, Stuart - WCP
n the download directory it was not imediatly obvious there was one main tarball and the rest where a split version rather than a main one with optional stuff (which is not my favoured option). This is all just in my opinion of course. - Stuart ---(end of broa