Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-07 Thread Prashant Ranjalkar
mory hence leading to problems. regards Prashant Ranjalkar EnterpriseDB On 5/7/07, Christopher S Martin <[EMAIL PROTECTED]> wrote: Martin: They didn't take any memory out of the machine. AS for memory cache parameters, I'm don't know about that. How would I go

Re: [GENERAL] Postgres 8.3-dev

2007-05-07 Thread Prashant Ranjalkar
Hello, Remove Postgres directory from the your drive and also entries from Registry. Reboot and try regards Prashant Ranjalkar On 5/2/07, Paolo Saudin <[EMAIL PROTECTED]> wrote: I am trying out postgresql-8.3-dev1 on Windows XP SP2 and during the installation, I get the following

Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-07 Thread Prashant Ranjalkar
Hello, Please check any .pid file exist in your data directory. If it exists then postmaster is running and memory is not freed up. Also check ipcs -mp it will give any shared memory allocated segments if any and consuming the memory. regards Prashant Ranjalkar On 5/7/07, Christopher S

Re: [GENERAL] shmget fails on OS X with proper settings

2007-05-07 Thread Prashant Ranjalkar
ough memory then set the shmmax to highier value and try again. Hope this will resolve your problem. Regards, Prashant Ranjalkar EnterpriseDB On 5/7/07, Christopher S Martin <[EMAIL PROTECTED]> wrote: No .pid files found in the data directory. The ipcs output doesn't list anythi

Re: [GENERAL] did not find any relation for existing table

2007-05-07 Thread Prashant Ranjalkar
schemaname column then the object is residing in public schema not in history schema. Please try this. Regards, Prashant Ranjalkar EnterpriseDB On 5/7/07, Sinead O Brien <[EMAIL PROTECTED]> wrote: > >"Sinead O Brien" <[EMAIL PROTECTED]> writes: > > I am receiving

Re: [GENERAL] a few questions on backup

2007-05-15 Thread Prashant Ranjalkar
this helps. Regards, Prashant Ranjalkar EnterpriseDB Corporation On 5/14/07, Marco Colombo <[EMAIL PROTECTED]> wrote: Hello, I have a few questions on backuping a PostgreSQL server (lets say anything 8.x.x). I've read "Continuous Archiving and Point-In-Time Recovery (PITR)"

Re: [GENERAL] EXCEPTION clause not identified

2007-05-15 Thread Prashant Ranjalkar
Hi, Probably you might be using reserved words (ip_address). Please try with out using the reserved words. Regards Prashant Ranjalkar On 5/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote: Hi, In one of my trigger functions, i'm trying to catch invalid ip address exception