Re: [HACKERS] PGP signing releases

2003-02-05 Thread Curt Sampson
On Wed, 4 Feb 2003, Greg Copeland wrote: If three people are required to sign a package prior to release, what happens when one of them is unavailable for signing (vacation, hospital, etc). This is one of the reasons why having a single project key which the core developers sign may appear to

Re: [HACKERS] PGP signing releases

2003-02-05 Thread Bruno Wolff III
On Wed, Feb 05, 2003 at 15:22:12 +0900, Curt Sampson [EMAIL PROTECTED] wrote: On Wed, 4 Feb 2003, Greg Copeland wrote: Hm. Splitting the key into parts is a very interesting idea, but I'd be interested to know how you might implement it without requiring everybody to be physically present

Re: [HACKERS] POSIX regex performance bug in 7.3 Vs. 7.2

2003-02-05 Thread wade
Confirmed. Looks like a 100-fold increase. Thanx guys. Explain output can be seen here: http://arch.wavefire.com/pgregex.txt -Wade Klaver At 09:59 AM 2/5/03 -0500, Tom Lane wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: Ok. The original complain can be sasily solved at least for single byte

Re: [HACKERS] PGP signing releases

2003-02-05 Thread Greg Copeland
On Wed, 2003-02-05 at 00:22, Curt Sampson wrote: On Wed, 4 Feb 2003, Greg Copeland wrote: If three people are required to sign a package prior to release, what happens when one of them is unavailable for signing (vacation, hospital, etc). This is one of the reasons why having a single

Re: [HACKERS] PGP signing releases

2003-02-05 Thread Kurt Roeckx
On Tue, Feb 04, 2003 at 06:19:42PM -0600, Greg Copeland wrote: I do agree that a checksum (or hash) is better than nothing, however, a serious security solution it is not. Which really is all I'm saying. Kurt ---(end of broadcast)--- TIP 6:

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread James Hubbard
Justin Clift wrote: Hmmm... does anyone remember the name of that NFS testing tool the FreeBSD guys were using? Think it came from Apple. They used it to find and isolate bugs in the FreeBSD code a while ago. Sounds like it might be useful here. :-) You can find a write about it here:

[HACKERS] Status report: regex replacement

2003-02-05 Thread Tom Lane
I have just committed the latest version of Henry Spencer's regex package (lifted from Tcl 8.4.1) into CVS HEAD. This code is natively able to handle wide characters efficiently, and so it avoids the multibyte performance problems recently exhibited by Wade Klaver. I have not done extensive

Re: [HACKERS] Status report: regex replacement

2003-02-05 Thread Jon Jensen
On Wed, 5 Feb 2003, Tom Lane wrote: 1. There are a couple of minor incompatibilities between the advanced regex syntax implemented by this package and the syntax handled by our old code; in particular, backslash is now a special character within bracket expressions. It seems to me that we'd

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Kevin Brown
Tom Lane wrote: Greg Copeland [EMAIL PROTECTED] writes: On Wed, 2003-02-05 at 11:18, Tom Lane wrote: Wild thought here: can you reduce the MTU on the LAN linking the NFS server to the NetBSD box? If so, does it help? I'm curious as to why you think adjusting the MTU may have an effect

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Justin Clift
James Hubbard wrote: Justin Clift wrote: Hmmm... does anyone remember the name of that NFS testing tool the FreeBSD guys were using? Think it came from Apple. They used it to find and isolate bugs in the FreeBSD code a while ago. Sounds like it might be useful here. :-) You can find a

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Tom Lane
D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Well, it does appear to be working but it never finishes. Here are two backtraces. One was taken while it was running and the other after a kill -9. The primary key file should have had 322846720 bytes based on the database that I was copying in

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
On Wednesday 05 February 2003 10:12, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Well, it does appear to be working but it never finishes. Here are two backtraces. One was taken while it was running and the other after a kill -9. The primary key file should have had

Re: [HACKERS] POSIX regex performance bug in 7.3 Vs. 7.2

2003-02-05 Thread Tatsuo Ishii
Nice work, Tatsuo! Wade, can you confirm that this patch solves your problem? Tatsuo, please commit into REL7_3 branch only --- I'm nearly ready to do a wholesale replacement of the regex code in HEAD, so you wouldn't accomplish much except to create a merge problem for me ... Ok. I have

Re: [HACKERS] PGP signing releases

2003-02-05 Thread Curt Sampson
On Thu, 5 Feb 2003, Greg Copeland wrote: Who will actually hold the key? Where will it be physically kept? Good question but can usually be addressed. It can be addressed, but how well? This is another big issue that I don't see any plan for that I'm comfortable with.. The

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Tom Lane
D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Hmm. This time it passed that point but this happened: COPY certificate FROM stdin; NOTICE: copy: line 253677, bt_insertonpg[certificate_pkey]: parent page unfound - fixing branch ERROR: copy: line 253677, bt_fixlevel[certificate_pkey]: invalid

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
On Wednesday 05 February 2003 11:49, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: Hmm. This time it passed that point but this happened: COPY certificate FROM stdin; NOTICE: copy: line 253677, bt_insertonpg[certificate_pkey]: parent page unfound - fixing branch ERROR:

Re: [HACKERS] Status report: regex replacement

2003-02-05 Thread Christopher Kings-Lynne
set regex_flavor = advanced set regex_flavor = extended set regex_flavor = basic [snip] Any suggestions about the name of the parameter? Actually I think 'regex_flavor' sounds fine. Not more Americanisms in our config files!! :P Chris ---(end of

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Tom Lane
D'Arcy J.M. Cain [EMAIL PROTECTED] writes: On Wednesday 05 February 2003 11:49, Tom Lane wrote: I wonder if it is possible that, every so often, you are losing just the last few bytes of an NFS transfer? Yah, that's kind of what it looked like when I tried this before Christmas too although

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Justin Clift
Tom Lane wrote: snip Hoo boy. I was already suspecting data corruption in the index, and this looks like more of the same. My thoughts are definitely straying in the direction of the NFS server is dropping bits, somehow. Both this and the (admittedly unproven) bt_moveright loop suggest

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Greg Copeland
On Wed, 2003-02-05 at 11:18, Tom Lane wrote: D'Arcy J.M. Cain [EMAIL PROTECTED] writes: On Wednesday 05 February 2003 11:49, Tom Lane wrote: I wonder if it is possible that, every so often, you are losing just the last few bytes of an NFS transfer? Yah, that's kind of what it looked

[HACKERS] new version of btree_gist

2003-02-05 Thread Oleg Bartunov
Bruce, we just released new version of contrib/btree_gist (7.3 and current CVS) with support of int8, float4, float8 in addition to int4. Thanks Janko Richter for contribution. Could you, please, download entire archive (12Kb) from

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Tom Lane
Greg Copeland [EMAIL PROTECTED] writes: On Wed, 2003-02-05 at 11:18, Tom Lane wrote: Wild thought here: can you reduce the MTU on the LAN linking the NFS server to the NetBSD box? If so, does it help? I'm curious as to why you think adjusting the MTU may have an effect on this. Lowering

[HACKERS] Alpha version of contrib/tsearch is available for testing

2003-02-05 Thread Oleg Bartunov
Hi there, Teodor has finished alpha version of contrib/tsearch with ranking support. Also, it includes OpenFTS (0.34) parser, ispell and snowball (stemming) support. Comments and documentation are welcome ! Without documentation we'll be not able to release the module ! We need documentation

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread D'Arcy J.M. Cain
On Wednesday 05 February 2003 13:04, Ian Fry wrote: Wild thought here: can you reduce the MTU on the LAN linking the NFS server to the NetBSD box? If so, does it help? How about adjusting the read and write-size used by the NetBSD machine? I think the default is 32k for both read and write

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Tom Lane
D'Arcy J.M. Cain [EMAIL PROTECTED] writes: On Wednesday 05 February 2003 13:04, Ian Fry wrote: How about adjusting the read and write-size used by the NetBSD machine? I think the default is 32k for both read and write on i386 machines now. Perhaps try setting them back to 8k (it's the -r and

Re: [HACKERS] [ANNOUNCE] PostgreSQL v7.3.2 Released

2003-02-05 Thread Laurette Cisneros
Well this isn't any good...the primary site is hugely busy and it is not on any of the mirrors. Perhaps it did not get copied over to the mirrors even though this announcent says it is there? Thanks, L. On Wed, 5 Feb 2003, Marc G. Fournier wrote: G'day ... This is just a quick

Re: [HACKERS] [ANNOUNCE] PostgreSQL v7.3.2 Released

2003-02-05 Thread Tom Lane
Laurette Cisneros [EMAIL PROTECTED] writes: Well this isn't any good...the primary site is hugely busy and it is not on any of the mirrors. Sure it is. I tried two at random: ftp://ftp.us.postgresql.org/source/v7.3.2/ ftp://ftp.dk.postgresql.org/mirrors/postgresql/source/v7.3.2/ The

Re: [HACKERS] [ANNOUNCE] PostgreSQL v7.3.2 Released

2003-02-05 Thread Laurette Cisneros
I was trying from the postgresql.org download web page and following the mirror links there...and none of them that I was able to get to (some of them didn't work) showed 7.3.2. The second link you gave below works. Thanks, L. On Wed, 5 Feb 2003, Tom Lane wrote: Laurette Cisneros [EMAIL

Re: [HACKERS] PostgreSQL, NetBSD and NFS

2003-02-05 Thread Christopher Kings-Lynne
Hmmm... does anyone remember the name of that NFS testing tool the FreeBSD guys were using? Think it came from Apple. They used it to find and isolate bugs in the FreeBSD code a while ago. fsx Chris ---(end of broadcast)--- TIP 1:

Re: [HACKERS] Status report: regex replacement

2003-02-05 Thread Hannu Krosing
Christopher Kings-Lynne kirjutas N, 06.02.2003 kell 03:56: set regex_flavor = advanced set regex_flavor = extended set regex_flavor = basic [snip] Any suggestions about the name of the parameter? Actually I think 'regex_flavor' sounds fine. Not more Americanisms in our