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
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
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
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.debuser=)
I want to
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 installed
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
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 some
On Fri, Sep 23, 2011 at 1:23 PM, Joe Conway m...@joeconway.com 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)
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
On Fri, Sep 23, 2011 at 1:38 PM, Burgholzer, Robert (DEQ)
robert.burghol...@deq.virginia.gov 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
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
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
On Fri, Sep 23, 2011 at 2:45 PM, Burgholzer, Robert (DEQ)
robert.burghol...@deq.virginia.gov 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
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:
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 would
15 matches
Mail list logo