[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

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 D

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

[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 Pos

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 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

[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 : >> Hi, >> >> I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to >> turn the server with t

[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 = 400

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 wrote: >> I have questions about Linux Write cache sizing: >> >> 1) /proc/sys/vm/dirty_ratio : current value (default) 20 >> 2) /p

[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] 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 m

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] Linux PowerPC 64bits issue

Hi, I have tried to compile it in my local machine, I could not reproduce the issue yet. Does anyone else have idea what the reason would be? Would the issue come from the config file? Regards Arthur On 27 Sep 2012, at 7:46 PM, Leonardo M. Ramé wrote: > On 2012-09-27 11:51:46 +0800

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 appli

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

[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"