[ADMIN] Re: [pgsql-pkg-debian] Fwd: Invalid version while creating PostgreSQL 9.1 cluster

2011-09-23 Thread Christoph Berg
Re: Виктор Столбин 2011-09-23 <4e7c7da8.6060...@gmail.com> > Hello! > I'm trying create a cluster with existing data directory on Debian > 2.6.26-2-686-bigmem. I use PostgreSQL 8.3 installed from apt-get and > PostgreSQL 9.1 installed from > [OpenSCG](http://www.openscg.org/se/oscg_download.jsp?fi

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Joe Conway
On 09/23/2011 01:45 PM, Burgholzer, Robert (DEQ) wrote: > Joe - it appears that it ALWAYS involves pLR - even a simple median call > has caused it, though I must say it is something that is calculating the > median of somewhere around 10-20,000 pieces of data if that makes any > difference. I woul

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Burgholzer, Robert (DEQ)
Thanks Scott - I'm on the MFer. That is, I WILL be on it next Monday when I have time to sit down, gin up a test case and break this sucker. :) Stay tuned, and thanks bunches, r.b. -Original Message- From: Scott Marlowe [mailto:scott.marl...@gmail.com] Sent: Fri 9/23/2011 4:51 PM To:

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Scott Marlowe
On Fri, Sep 23, 2011 at 2:45 PM, Burgholzer, Robert (DEQ) wrote: > Scott - thanks, in pouring over the logs, I have not found anything certain, > but have turned up a ton of mesages about my sysadmins se-linux security and > php/pg (don't know if they're my app or script kiddies...).  I will keep

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Burgholzer, Robert (DEQ)
Scott - thanks, in pouring over the logs, I have not found anything certain, but have turned up a ton of mesages about my sysadmins se-linux security and php/pg (don't know if they're my app or script kiddies...). I will keep looking for things pertianing to these crashes. The message relative

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Joe Conway
On 09/23/2011 12:38 PM, Burgholzer, Robert (DEQ) wrote: > Thanks - I will try to check into this - however, we have done some > tuning on the memory over the last 2 years and gotten it such that it is > seldom if every having to dip into its swap too substantially -- > according to "top", we remain

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Scott Marlowe
On Fri, Sep 23, 2011 at 1:38 PM, Burgholzer, Robert (DEQ) wrote: > Joe, > Thanks - I will try to check into this - however, we have done some tuning > on the memory over the last 2 years and gotten it such that it is seldom if > every having to dip into its swap too substantially -- according to "

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Burgholzer, Robert (DEQ)
Joe, Thanks - I will try to check into this - however, we have done some tuning on the memory over the last 2 years and gotten it such that it is seldom if every having to dip into its swap too substantially -- according to "top", we remain under 1% swap usage during most times. Generally spea

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Scott Marlowe
On Fri, Sep 23, 2011 at 1:23 PM, Joe Conway wrote: > On 09/23/2011 12:02 PM, Burgholzer, Robert (DEQ) wrote: >> I am trying to get my head around why I keep getting crashes to my PG >> 8.3.7 database on CentOS - Linux version 2.6.18-164.el5.  There are 3 >> slightly different (I think) circumstanc

Re: [ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Joe Conway
On 09/23/2011 12:02 PM, Burgholzer, Robert (DEQ) wrote: > I am trying to get my head around why I keep getting crashes to my PG > 8.3.7 database on CentOS - Linux version 2.6.18-164.el5. There are 3 > slightly different (I think) circumstances leading to a crash of the > database, all related in s

[ADMIN] diagnosing a db crash - server exit code 2

2011-09-23 Thread Burgholzer, Robert (DEQ)
I am trying to get my head around why I keep getting crashes to my PG 8.3.7 database on CentOS - Linux version 2.6.18-164.el5. There are 3 slightly different (I think) circumstances leading to a crash of the database, all related in some way to long running PHP scripts with intensive activity o

[ADMIN] Re: [pgsql-cluster-hackers] Fwd: Invalid version while creating PostgreSQL 9.1 cluster

2011-09-23 Thread Hannu Krosing
On Fri, 2011-09-23 at 16:38 +0400, Виктор Столбин wrote: > Hello! Firts, this list is not for pg_*cluster, but rather clustering, high availability and replication solutions > I'm trying create a cluster with existing data directory on Debian > 2.6.26-2-686-bigmem. I use PostgreSQL 8.3 installe

[ADMIN] Fwd: Invalid version while creating PostgreSQL 9.1 cluster

2011-09-23 Thread Виктор Столбин
Hello! I'm trying create a cluster with existing data directory on Debian 2.6.26-2-686-bigmem. I use PostgreSQL 8.3 installed from apt-get and PostgreSQL 9.1 installed from [OpenSCG](http://www.openscg.org/se/oscg_download.jsp?file=packages/postgres-9.1.0-1.i386.openscg.deb&user=) I want to cr

Re: [ADMIN] [GENERAL] Date time value error in Ms Access using pass through queries

2011-09-23 Thread c k
I found the solution. Earlier for 9.0 database I have changed a line as Datestyle= ' ISO, mdy' to DateStyle= "ISO, dmy'. So it was working fine. For 9.1 I forgot to make this change in postgresql.conf. After making the change everything is working fine. Regards, C P Kulkarni On Fri, Sep 23, 2011

Re: [ADMIN] [GENERAL] Date time value error in Ms Access using pass through queries

2011-09-23 Thread c k
As I have connected to postgres from MS Access, it thrown the error. Now I have updated ODBC driver, still same problems comes for 9.1 and not for 9.0. There should be some thing that has changed in 9.1 release which prevents from auto-conversion of format of date from client to server. >From packa

[ADMIN] pgpool

2011-09-23 Thread Karuna Karpe
Hello, I am run pgpool and then create database bench. After that I run following command : pgbench -i -p bench But I got following error : 2011-09-23 12:38:11 ERROR: pid 12697: pool_read_kind: kind does not match between master(53) slot[1] (45) 2011-09-23 12:38:11 ERROR: pid 1269