Re: [ADMIN] PostgreSQL crashes

2009-05-31 Thread Tom Lane
"Moshe Ben-Shoham" writes: > I believe there are two problems here: one is the process 2604 exiting > with code 128, and the other one is the re-initialization failure with > the following fatal message: "BST FATAL: pre-existing shared memory > block is still in use". The second problem is most

Re: [ADMIN] Efficiently searching for CIDRs containing an IP address

2009-05-31 Thread Alan McKay
Hmmm, I've never done this quite that way, but IPs - especially CIDRs - are far easier to work with in binary format than in human-readable format. At my old workplace about 5 years ago I wrote an IP management system (PHP/MySQL) that stored the IP in binary and human-readable formats, but all of