Re: [BUGS] uuid.h: present but cannot be compiled

2013-08-28 Thread Peter Eisentraut
On Sun, 2013-08-25 at 12:01 -0700, Nick Carenza wrote: > on os x 10.8.4 > > installing with homebrew This is not a problem. Homebrew has the appropriate patches. There is more discussion about this issue in the mailing list archives. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgre

FW: [BUGS] BUG #8404: JDBC block hot standby replication?

2013-08-28 Thread Pius Chan
From: Pius Chan Sent: Wednesday, August 28, 2013 11:03 AM To: Heikki Linnakangas; Valentine Gogichashvili Cc: Frank Moi; Ken Yu; Vincent Lasmarias; Vladimir Kosilov Subject: RE: [BUGS] BUG #8404: JDBC block hot standby replication? Hi Heikki, Valentine, T

Re: [BUGS] BUG #8405: user can create a system table(eg, pg_class)

2013-08-28 Thread Heikki Linnakangas
On 28.08.2013 05:01, syxj...@gmail.com wrote: postgres=# create table pg_class(a int); CREATE TABLE postgres=# insert into pg_class values (1); ERROR: null value in column "relnamespace" violates not-null constraint DETAIL: Failing row contains (1, null, null, null, null, null, null, null, null

[BUGS] BUG #8405: user can create a system table(eg, pg_class)

2013-08-28 Thread syxjxia
The following bug has been logged on the website: Bug reference: 8405 Logged by: xjxia Email address: syxj...@gmail.com PostgreSQL version: 9.2.2 Operating system: ubuntu11.04 x86_64 Description: postgres=# create table pg_class(a int); CREATE TABLE postgres=# insert

[BUGS] Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size

2013-08-28 Thread Andres Freund
On 2013-08-28 11:50:17 +0200, Valentine Gogichashvili wrote: > Oh, here is more context about this issue: > http://www.postgresql.org/message-id/201208171307.16342.and...@2ndquadrant.com I think that backtrace and explanation pretty much explained what's going on. Did you try 9.3 to see whether th

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

2013-08-28 Thread Heikki Linnakangas
On 28.08.2013 02:28, Valentine Gogichashvili wrote: Running this sproc on the master: CREATE OR REPLACE FUNCTION public.f() RETURNS integer LANGUAGE plpgsql AS $function$ begin CREATE TEMP TABLE temp_table_to_test_replication AS SELECT s.i as id from generate_series(1, 100) as s(i);

Re: [BUGS] BUG #8404: JDBC block hot standby replication?

2013-08-28 Thread Heikki Linnakangas
On 28.08.2013 12:46, Valentine Gogichashvili wrote: Hello This is a well documented feature of Hot-Standby Replication. see: http://www.postgresql.org/docs/9.2/static/runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-STANDBY That explains how streaming delay and query cancellations w

Re: [BUGS] BUG #7494: WAL replay speed depends heavily on the shared_buffers size

2013-08-28 Thread Valentine Gogichashvili
Oh, here is more context about this issue: http://www.postgresql.org/message-id/201208171307.16342.and...@2ndquadrant.com -- Valentin On Wed, Aug 28, 2013 at 1:28 AM, Valentine Gogichashvili wrote: > Hello Andreas, > > it is more then a year now, that I have not returned to that topic. > > As we

Re: [BUGS] BUG #8404: JDBC block hot standby replication?

2013-08-28 Thread Valentine Gogichashvili
Hello This is a well documented feature of Hot-Standby Replication. see: http://www.postgresql.org/docs/9.2/static/runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-STANDBY Regards, -- Valentin ვალენტინ გოგიჩაშვილი Valentine Gogichashvili On Wed, Aug 28, 2013 at 2:30 AM, wrote: >