[GENERAL] Prepared Statements and Pooling

2015-08-10 Thread Mister Junk
I'm working on a project for school that requires a simple java server (a ServerSocket creates Socket connections which I send JSON strings over) which then communicates with a database. Obviously I have chosen PostgreSQL. I'm using Apache DBCP for connection pooling. The DataSource is handed of

Re: [GENERAL] conn = PQconnectdb(conninfo);

2015-08-10 Thread Albe Laurenz
Peter Kroon wrote: >>> I've found perhaps a bug. >>> I've narrowed down my code and the problem is indeed at: conn = >>> PQconnectdb(conninfo); >>> >>> My connection string: host=192.168.178.12 dbname=DATABASE user=foo >>> password=bar >>> >>> When I remove key/value host=xxx then everything is O

Re: [GENERAL] Postgresql 9.4.4: ERROR: bigint out of range

2015-08-10 Thread Adrian Klaver
On 08/10/2015 06:23 AM, Arthur Chan wrote: Hi, I have installed 9.4.4 and repmgr 3.0.1 (installed by using "yum install repmgr"). From the system log, I found many errors with same type: ERROR: bigint out of range STATEMENT: INSERT INTO "repmgr_pg_cluster".repl_monitor (primary_node, stand

[GENERAL] Postgresql 9.4.4: ERROR: bigint out of range

2015-08-10 Thread Arthur Chan
Hi, I have installed 9.4.4 and repmgr 3.0.1 (installed by using "yum install repmgr"). From the system log, I found many errors with same type: ERROR: bigint out of range STATEMENT: INSERT INTO "repmgr_pg_cluster".repl_monitor (primary_node, standby_node, last_monitor_time, last_

Re: [GENERAL] postgres connection

2015-08-10 Thread Martín Marqués
El 07/08/15 a las 07:31, Ramesh T escribió: > FATAL: syntax error in file "recovery.conf" line 2, near token "config" > < 2015-08-07 05:21:13.086 EDT >LOG: startup process (PID 6129) exited with > exit code 1 > < 2015-08-07 05:21:13.086 EDT >LOG: aborting startup due to startup > process failure

Re: [GENERAL] pg_start_backup: file has vanished from pg_subtrans/

2015-08-10 Thread Leo Baltus
Op 08/08/2015 om 14:24:00 -0400, schreef David Steele: > On 8/7/15 7:01 AM, Leo Baltus wrote: > >While backing up some postgresql-8.4.2 instances using > >pg_start_backup()/pg_stop_backup() > > > >We noticed that sometimes rsync complains: > > > >file has vanished: "./data/pg_subtrans/3