Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

On Sun, Feb 9, 2014 at 10:02 PM, Adarsh Sharma wrote: > I need to use xlogdump to analyse my xlog files in postgresql to understand > why there are so much xlog generation on Master. Only PostgreSQL is supported. EDB's product is not. -- Regards, Peter Geoghegan -- Sent via pgsql-general ma

[GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

Hi, Any body faced the similar issue while compiliing xlogdump :- [root@db1002 xlogdump]# make /usr/bin/gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv strlcpy.o xlogdump.o xl

Re: [GENERAL] client encoding that psql command sets

Thanks for your support. Best regards, Tsubasa Sakamoto > -Original Message- > From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at] > Sent: Friday, February 07, 2014 6:12 PM > To: Tsubasa Sakamoto *EXTERN*; 'Adrian Klaver' > Cc: pgsql-general@postgresql.org; pgsql-hack...@postgresql.org >

Re: [GENERAL] Better Connection Statistics

On Sun, Feb 9, 2014 at 4:52 AM, Greg Sabino Mullane wrote: >> For instance, I want the number of transactions a specific connection has >> submitted. >> The number of queries. Total amount of CPU time consumed, etc. So far as I >> know, >> there is no module, statistic, or view that provides any

Re: [GENERAL] WAL archive on slave

On Mon, Feb 10, 2014 at 9:43 AM, James Sewell wrote: > Hi again, > > I just realised I asked this question around a year ago (for a different > reason actually) and you answered me then! Amazing! > > Your answer then was: > > It works fine, only the server will not generate WAL while >> it is in r

Re: [GENERAL] WAL archive on slave

Hi again, I just realised I asked this question around a year ago (for a different reason actually) and you answered me then! Amazing! Your answer then was: It works fine, only the server will not generate WAL while > it is in recovery. As soon as you promote the standby, > it will archive ist

Re: [GENERAL] WAL archive on slave

Thanks for the reply Albe. I have WAL archiving enabled on both my servers, but it only happens on the master. When I promote the slave to be the new master then it will start archiving automatically, which suggests that my configuration is correct. Can you think of anything else which might cau

[GENERAL] Optimizing tables for known queries?

Hello! This is my first time on this list, so forgive me if it is not he correct place to discuss things like this. I have a question and answer tables right now that have grown large enough that my querying of them has become extremely slow and was wondering if anyone had tips on ways of optimiz

Re: [GENERAL] How to distribute budget value to actual rows in Postgresql

Andrus Moor wrote > Budget table contains jobs with loads: > > create temp table budget ( > job char(20) primary key, > load numeric(4,1) not null check (load>0 ) > ); > insert into budget values ( 'programmer', 3 ); > insert into budget values ( 'analyst', 1.5 ); >

[GENERAL] How to distribute budget value to actual rows in Postgresql

Budget table contains jobs with loads: create temp table budget ( job char(20) primary key, load numeric(4,1) not null check (load>0 ) ); insert into budget values ( 'programmer', 3 ); insert into budget values ( 'analyst', 1.5 ); Actual table contains actual loads by emp