Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Shridhar Daithankar
On 12 Jun 2003 at 11:31, Bruce Momjian wrote: OK, doc patch attached and applied. Improvements? Can we point people to /usr/src/linux/doc...place where they can find more documentation and if their kernel supports it or not. Bye Shridhar -- Zall's Laws:(1) Any time you get a

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Jeroen T. Vermeulen
On Thu, Jun 12, 2003 at 07:22:14PM -0700, Ron Mayer wrote: I'm guessing any database backend (postgres, oracle) that wasn't part of a long-lived connection seems like an especially attractive target to this algorithm. Yeah, IIRC it tries to pick daemons that can be restarted, or will be

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Bruce Momjian
Shridhar Daithankar wrote: On 12 Jun 2003 at 11:31, Bruce Momjian wrote: OK, doc patch attached and applied. Improvements? Can we point people to /usr/src/linux/doc...place where they can find more documentation and if their kernel supports it or not. Yes, we could, but the name of

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Patrick Welche
On Thu, Jun 12, 2003 at 10:10:02PM -0400, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: You have to love that swap + 1/2 ram option --- when you need four possible options, there is something wrong with your approach. :-) I'm still wondering what the

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Bruce Momjian
Patrick Welche wrote: On Thu, Jun 12, 2003 at 10:10:02PM -0400, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: You have to love that swap + 1/2 ram option --- when you need four possible options, there is something wrong with your approach. :-)

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Jeroen T. Vermeulen
On Fri, Jun 13, 2003 at 09:25:49AM -0400, Bruce Momjian wrote: malloc() - should fail right away if it can't reserve the requested memory; assuming application request memory they don't use just seems dumb --- fix the bad apps. fork() - this is the tricky one because you don't know at

Re: [HACKERS] security flaw

2003-06-13 Thread ohp
On Tue, 10 Jun 2003, scott.marlowe wrote: Date: Tue, 10 Jun 2003 08:15:06 -0600 (MDT) From: scott.marlowe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: pgsql-hackers list [EMAIL PROTECTED] Subject: Re: [HACKERS] security flaw On Sat, 7 Jun 2003 [EMAIL PROTECTED] wrote: Hi all, I

[HACKERS] Mirro updates

2003-06-13 Thread ohp
Hi every one, Is it normal that mirro site now all redirect to www.postgresql.org? It also seem that rsync is doing nothing when updating www... Regards -- Olivier PRENANT Tel:+33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190

Re: [HACKERS] Mirro updates

2003-06-13 Thread The Hermit Hacker
for the web, yes ... the new site doesn't support mirroring, as its highly database driven ... only thing still mirrorable, really, is the ftp server ... On Fri, 13 Jun 2003 [EMAIL PROTECTED] wrote: Hi every one, Is it normal that mirro site now all redirect to www.postgresql.org? It also

Re: [HACKERS] Mirro updates

2003-06-13 Thread Vince Vielhaber
On Fri, 13 Jun 2003, The Hermit Hacker wrote: for the web, yes ... the new site doesn't support mirroring, as its highly database driven ... only thing still mirrorable, really, is the ftp server ... I knew that was gonna happen. Vince. -- Fast, inexpensive internet service 56k and

[HACKERS] SOLUTION: Insert a Euro symbol as UTF-8 from a latin1 charset.

2003-06-13 Thread Roland Glenn McIntosh
This is my solution / bug report / RFC cross-posted from [GENERAL] regarding insertion of hexadecimal characters from the command line. --- Okay. I have NO IDEA why this works. If someone could enlighten me as to the math involved I'd appreciate it. First, a

Re: [HACKERS] SOLUTION: Insert a Euro symbol as UTF-8 from a latin1 charset.

2003-06-13 Thread Jeroen T. Vermeulen
On Fri, Jun 13, 2003 at 11:28:36AM -0400, Roland Glenn McIntosh wrote: The Euro symbol is unicode value 0x20AC. UTF-8 encoding is a way of representing most unicode characters in two bytes, and most latin characters in one byte. More precisely, UTF-8 encodes ASCII characters in one byte.

Re: [PATCHES] [HACKERS] PostgreSQL libraries - PThread Support, but

2003-06-13 Thread Bruce Momjian
Lee, I have a question about this code: char *pqStrerror(int errnum, char *strerrbuf, size_t buflen) { #if defined HAVE_STRERROR_R /* reentrant strerror_r is available */ strerror_r(errnum, strerrbuf, buflen); return strerrbuf;

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Josh Berkus
Tom, et al, Given that swap space is cheap, and that killing random processes is obviously bad, it's not apparent to me why people think this is not a good approach --- at least for high-reliability servers. And Linux would definitely like to think of itself as a server-grade OS.

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Bruce Momjian
Josh Berkus wrote: Tom, et al, Given that swap space is cheap, and that killing random processes is obviously bad, it's not apparent to me why people think this is not a good approach --- at least for high-reliability servers. And Linux would definitely like to think of itself as a

Re: [PATCHES] [HACKERS] PostgreSQL libraries - PThread Support, but

2003-06-13 Thread Lee Kindness
Your call, but the broken call is in earlier glibc versions for sure (if you're on a Linux box take a look in /usr/include - the prototype is still there, may even get used depending on compiler options!). I seem to remember compiling this on recent Solaris, HPUX, Linux and AIX versions without

Re: [PATCHES] [HACKERS] PostgreSQL libraries - PThread Support, but

2003-06-13 Thread Bruce Momjian
My point is why do we care whether it returns char * or nothing --- we should just return strerrbuf in all cases. --- Lee Kindness wrote: Your call, but the broken call is in earlier glibc versions for sure (if you're on

Re: [PATCHES] [HACKERS] PostgreSQL libraries - PThread Support, but

2003-06-13 Thread Lee Kindness
Bruce Momjian writes: My point is why do we care whether it returns char * or nothing --- we should just return strerrbuf in all cases. Ok, I see. Guess that is reasonable. L. ---(end of broadcast)--- TIP 7: don't forget to increase your free

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Bruce Momjian
Lamar Owen wrote: On Friday 13 June 2003 11:55, Josh Berkus wrote: Regrettably, few of the GUI installers for Linux (SuSE or Red Hat, for example), include adequate swap space in their suggested disk formatting. Some versions of some distributions do not create a swap partition at all;

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Nigel J. Andrews
On Fri, 13 Jun 2003, Lamar Owen wrote: On Friday 13 June 2003 11:55, Josh Berkus wrote: Regrettably, few of the GUI installers for Linux (SuSE or Red Hat, for example), include adequate swap space in their suggested disk formatting. Some versions of some distributions do not create a swap

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Bruce Momjian
I will say I do use swap sometimes when I am editing a huge image or something --- there are peak times when it is required. --- Nigel J. Andrews wrote: On Fri, 13 Jun 2003, Lamar Owen wrote: On Friday 13 June 2003

Re: [HACKERS] SOLUTION: Insert a Euro symbol as UTF-8 from a latin1 charset.

2003-06-13 Thread Ian Barwick
On Friday 13 June 2003 17:28, Roland Glenn McIntosh wrote: This is my solution / bug report / RFC cross-posted from [GENERAL] regarding insertion of hexadecimal characters from the command line. --- Okay. I have NO IDEA why this works. If someone could

[HACKERS] UTF8 and KOI8 mini-howto

2003-06-13 Thread Oleg Bartunov
Hi there, I've managed to get postgresql working with UTF8 and KOI8. Here is some mini-howto: http://www.sai.msu.su/~megera/postgres/utf8.html Regards, Oleg _ Oleg Bartunov, sci.researcher, hostmaster of

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Jeroen T. Vermeulen
On Fri, Jun 13, 2003 at 12:32:24PM -0400, Lamar Owen wrote: Incidentally, Red Hat as of about 7.0 began insisting on swap space at least as large as twice RAM size. In my case on my 512MB RAM notebook, that meant it wanted 1GB swap. If you upgrade your RAM you could get into trouble. In

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Lamar Owen
On Friday 13 June 2003 12:46, Nigel J. Andrews wrote: On Fri, 13 Jun 2003, Lamar Owen wrote: Incidentally, Red Hat as of about 7.0 began insisting on swap space at least as large as twice RAM size. In my case on my 512MB RAM notebook, that meant it wanted 1GB swap. If you upgrade your RAM

[HACKERS] dblink_ora - a first shot on Oracle ...

2003-06-13 Thread Hans-Jürgen Schönig
Hi there ... I have spent some time working on an Oracle version of dblink. It works quite nicely for me and I hope it does for others. It already supports some basic features such as persistent connection and fetching data. This is not a perfect piece of software and there is lot of room for

Re: [HACKERS] Mirro updates

2003-06-13 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 June 2003 15:19 To: pgsql-hackers list Subject: [HACKERS] Mirro updates Hi every one, Is it normal that mirro site now all redirect to www.postgresql.org? It also seem that rsync is doing

Re: [HACKERS] Mirro updates

2003-06-13 Thread The Hermit Hacker
On Fri, 13 Jun 2003 [EMAIL PROTECTED] wrote: Hi vince, Hi Marc Although I understand why, I think it's a bit f a pity that there's no mirror of web anymore. For that it means that 1) every thing is now on your shoulders and that if anything goes wrong you've got no mirror to rely on. BUT

[HACKERS] Compiling Win32

2003-06-13 Thread Paul Ramsey
I have started playing with the pre7.4 code to see if I can compile a win32 version with PostGIS support. So far, finding it a little hard. Is there a wee guide to compiling 7.4 native win32 around? Thanks, Paul -- __ / | Paul Ramsey | Refractions Research | Email:

Re: [HACKERS] Compiling Win32

2003-06-13 Thread Bruce Momjian
No, we are not there yet, but you can download Mingw and Msys to get started. --- Paul Ramsey wrote: I have started playing with the pre7.4 code to see if I can compile a win32 version with PostGIS support. So far,

Re: [HACKERS] Compiling Win32

2003-06-13 Thread Paul Ramsey
Yep, have done that... Configure even runs right through, but nothing after that. :/ P. Bruce Momjian wrote: No, we are not there yet, but you can download Mingw and Msys to get started. --- Paul Ramsey wrote: I have started

Re: [HACKERS] Compiling Win32

2003-06-13 Thread Bruce Momjian
You should be able to compile, but not link the backend. --- Paul Ramsey wrote: Yep, have done that... Configure even runs right through, but nothing after that. :/ P. Bruce Momjian wrote: No, we are not there yet,

Re: [PATCHES] [HACKERS] PostgreSQL libraries - PThread Support, but

2003-06-13 Thread Bruce Momjian
Lee, I have been looking at the code, and though the quoted function is OK to avoid the non-posix case, it seems the later ones are a problem: #if defined HAVE_NONPOSIX_GETPWUID_R /* broken (well early POSIX draft) getpwuid_r() which returns * 'struct passwd

Re: [HACKERS] PostgreSQL under Windows

2003-06-13 Thread Justin Clift
Hi guys, Although the Proof of Concept build works, it does have a few drawbacks: + Only works on English (US at least) installations, because it's hard coded to install in C:\Program Files\PostgreSQL. On non-English installations, C:\Program Files is named differently and causes things to

Re: [HACKERS] PostgreSQL under Windows

2003-06-13 Thread Robert Treat
Justin, can you add this to the release notes section on the sourceforge site if it's not already there? Robert Treat On Saturday 14 June 2003 12:02 am, Justin Clift wrote: Hi guys, Although the Proof of Concept build works, it does have a few drawbacks: + Only works on English (US at