Re: [BUGS] looks like apple fixed /etc/rc

2005-04-30 Thread Theodore Petrosky
Jim, this is copied from /etc/rc... \ if [ -f /etc/sysctl.conf ]; then awk '{ if (!index($1, "#") && index($1, "=")) print $1 }' < /etc/sysctl.conf | while read do sysctl -w ${REPLY} done fi sysctl -w kern.sysv.shmmax=4194304 sysctl -w kern.sysv.shmmin=1

Re: [BUGS] looks like apple fixed /etc/rc

2005-04-30 Thread Jim C. Nasby
[EMAIL PROTECTED]:31]~:1%sysctl kern.sysv.shmmax kern.sysv.shmmax: 102400 It wouldn't surprise me at all if there was some other black magic at work here. What I do know is that I had to comment out the sysctl line in my /etc/rc to get that value to stick. I didn't make notes during my testing

Re: [BUGS] Win1250 database under linux

2005-04-30 Thread Tom Lane
Damir Bijuklic <[EMAIL PROTECTED]> writes: > My linux machine has following relevant locales: > hr_HR > hr_HR.iso88592 > hr_HR.utf8 > hrvatski I'd recommend using hr_HR.utf8 plus UTF8 database encoding. You'll need to re-initdb in order to install that as the database locale :-(

Re: [BUGS] BUG #1632: Several jailed PostgreSQL instances.

2005-04-30 Thread Tom Lane
"Nicolai Petri (lists)" <[EMAIL PROTECTED]> writes: > It might still be a good idea for postgresql to be able to detect this > collision without crashing each others backend or doing other weird stuff. It tries --- see IpcSemaphoreCreate in src/backend/port/sysv_sema.c. If the "jail" mechanism h

Re: [BUGS] BUG #1639: Problema re-instalacion

2005-04-30 Thread Jaime Casanova
On 4/29/05, PABLO <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1639 > Logged by: PABLO > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.02 > Operating system: windows 2000 > Description:Problema re-instalacion >

Re: [BUGS] Win1250 database under linux

2005-04-30 Thread Tom Lane
Damir Bijuklic <[EMAIL PROTECTED]> writes: > I'm using WIN1250 locale on both databases. Does your Linux platform even have such a locale? Mine doesn't. ("locale -a" will show you what is supported.) I suspect your machine is not recognizing the LANG setting and is falling back to behave as thou

Re: [BUGS] looks like apple fixed /etc/rc

2005-04-30 Thread Theodore Petrosky
Jim, I didn't understand your comment "It appears that you can shrink shmmax but not expand it." I did not comment out the kern.sysv.shmmax line and it appears that my larger setting is sticking. Or is it? What is that command to return the currrnt values from the terminal? Ted --- "Jim C. N

Re: [BUGS] BUG #1632: Several jailed PostgreSQL instances.

2005-04-30 Thread Nicolai Petri (lists)
You are correct - freebsd have indeed a global shm space which I don't think is fixed in 5.x yet. We have run up to 4 postgresql in jails for our testing and it just-works(tm) if we choose a different port for each database instance. It might still be a good idea for postgresql to be able to det