Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

? Thanks On 8 Jan 2013, at 3:13 PM, Birta Levente wrote: On 08/01/2013 08:40, a...@hsk.hk wrote: Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used apt-get install pgbouncer, after configuring it, I can now connect to pgbouncer

Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

On 8 Jan 2013, at 5:04 PM, Birta Levente wrote: The pooler is between client and postgresql server. So, if you want to connect through the pooler you need to connect on 6543. But I think you really need to read some documentation about pgbouncer. Thanks, I can connect to any testing DB

[GENERAL] Questions about 9.2 unique constraints

Hi, In PostgreSQL 9.0.x we must define a constraint as DEFERRABLE on the create table, we cannot define DEFERRABLE on create table as select, how is this restriction in 9.2 now? Also, in 9.2 can deferrable uniqueness be mixed with Foreign keys? Thanks -- Sent via pgsql-general mailing

[GENERAL] PostgreSQL 9.2 and PGBOUNCER

Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used apt-get install pgbouncer, after configuring it, I can now connect to pgbouncer and can use all pgbouncer SHOW commands, however: Q1) Is version 1.4.2/bouncer the right one for

Re: [GENERAL] PostgreSQL contrib 9.2.x

Hi, got it installed, thanks On 14 Dec 2012, at 7:36 PM, Ondrej Ivanič wrote: Hi, On 14 December 2012 17:56, a...@hsk.hk a...@hsk.hk wrote: I could see that it would install older PostgreSQL 9.1 and postgresql-contrib-9.1. As I already have 9.2.1 and do not want to have older version

[GENERAL] PostgreSQL contrib 9.2.x

Hi, I am using Ubuntu 12.04, I have used installer to install PostgreSQL 9.2.1, the contrib modules are not installed together with the core. I tried to run: sudo apt-get install postgresql-contrib The following packages were automatically installed and are no longer required:

Re: [GENERAL] effective_cache_size and work_ram

Hi, yes it is a dedicated server. and THANKS! On 12 Dec 2012, at 3:55 PM, Pavel Stehule wrote: hello 2012/12/12 a...@hsk.hk a...@hsk.hk: Hi, I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to turn the server with the following changes from default

[GENERAL] effective_cache_size and work_ram

Hi, I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to turn the server with the following changes from default: max_connections = 100 # default shared_buffers = 2048MB # change from 24MB to 2048MB as I think 24MB is not enough maintenance_work_mem =

[GENERAL] Ubutu 12.04 and PostgreSQL9.2.1

Hi, I have questions about Linux Write cache sizing: 1) /proc/sys/vm/dirty_ratio : current value (default) 20 2) /proc/sys/vm/dirty_background_ratio: current value (default) 10 I am using Ubuntu 12.04 (8GB RAM) and PostgreSQL 9.2.1, what values of these kernel ratios should be set for better

Re: [GENERAL] Ubutu 12.04 and PostgreSQL9.2.1

Hi, thank you very much! On 7 Dec 2012, at 11:47 AM, Ondrej Ivanič wrote: Hi, On 7 December 2012 14:17, a...@hsk.hk a...@hsk.hk wrote: I have questions about Linux Write cache sizing: 1) /proc/sys/vm/dirty_ratio : current value (default) 20 2) /proc/sys/vm/dirty_background_ratio

Re: [GENERAL] replicate or multi-master for 9.1 or 9.2

Hi Jon, I have had a similar case as yours, I have one data center in Hong Kong another one in Tokyo, we have line between them, here are my feedback: 1) we used multiple masters at first, from time to time, some issues like that it took time to sync between master servers which caused obvious

Re: [GENERAL] replicate or multi-master for 9.1 or 9.2

correction: because the single master was too BUSY On 28 Sep 2012, at 7:48 PM, a...@hsk.hk wrote: Hi Jon, I have had a similar case as yours, I have one data center in Hong Kong another one in Tokyo, we have line between them, here are my feedback: 1) we used multiple masters at first

Re: [GENERAL] Linux PowerPC 64bits issue

, a...@hsk.hk wrote: Hi, Could you provide the steps and commands you used to compile 9.1? I want to reproduce your case in my machine Regards Arthur Yes, I downloaded postgresql-9.1.5.tar.gz from the PostgreSql web site, then did this: tar xvfz postgresql-9.1.5.tar.gz cd postgresql

Re: [GENERAL] Linux PowerPC 64bits issue

Hi, Could you provide the steps and commands you used to compile 9.1? I want to reproduce your case in my machine Regards Arthur On 27 Sep 2012, at 7:46 AM, Leonardo M. Ramé wrote: Hi, I compiled PostgreSql 9.1 from sources in a OpenSuse 10.1 PowerPC machine. While trying to test one

[GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

Hi, I have upgraded postgresql 8.4.13 to 9.2.0.1 O/S Ubuntu, restarted postgresql, it displayed my postgresql is 9.2 but when I log into postgresql, show version, it is still 8.4.13, see a) and b) below, a) * Restarting PostgreSQL 9.2 database server ...done. b) psql (8.4.13) Type help

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

Regards Arthur On 24 Sep 2012, at 4:45 AM, Raymond O'Donnell wrote: On 23/09/2012 19:31, Martin Collins wrote: On 23/09/12 11:48, Adrian Klaver wrote: On 09/23/2012 04:47 AM, a...@hsk.hk wrote: Hi, I have upgraded