[GENERAL] Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue

2015-09-04 Thread phiroc
Hello, I am using PGSQL 9.4 for Windows on Windows 7. when I insert 9 rows in a table called FINANCIAL_INSTIT, 24 rows end up being created! Furthermore, accented characters encoded in UTF-8 in the original SQL file, such as é, end up as "é". Any help would be much appreciated. Philippe

Re: [GENERAL] Duplicate rows inserted in PGSQL 9.4 for Windows, and accented character issue

2015-09-04 Thread phiroc
If I drop the FINANCIAL_INSTIT table, create it again, and run the insert commands, it now contains 9 rows as expected. - Mail original - De: phi...@free.fr À: pgsql-general@postgresql.org Envoyé: Vendredi 4 Septembre 2015 09:45:36 Objet: [GENERAL] Duplicate rows inserted in PGSQL 9.4 f

Re: [GENERAL] Slave promotion problem...

2015-09-04 Thread marin
On 2015-08-31 16:05, ma...@kset.org wrote: On 2015-08-31 14:38, Martín Marqués wrote: El 31/08/15 a las 03:29, ma...@kset.org escribió: Last week we had some problems on the master server which caused a failover on the slave (the master was completely unresponsive due to reasons still unknown).

Re: [GENERAL] Postgresql C extension and SIGSEGV

2015-09-04 Thread Albe Laurenz
Etienne Champetier wrote: > We are planning to add a C extension > (https://github.com/petropavel13/pg_rrule) to our shared > postgresql cluster, and wondering what are the risk? (looking for the worst > case scenario here) > > If there is a SIGSEGV, SIGBUS, SIGABRT ..., is the whole server stop

Re: [GENERAL] bdr admin role

2015-09-04 Thread Ray Stell
On 9/3/15 11:36 PM, Craig Ringer wrote: Please show your connection strings, and the contents of bdr.bdr_nodes and bdr.bdr_connections. On 3 September 2015 at 05:00, Ray Stell wrote: This doc specifies to initdb with the admin user "postgres," http://bdr-project.org/docs/stable/quickstart-inst

Re: [GENERAL] Postgresql C extension and SIGSEGV

2015-09-04 Thread Etienne Champetier
Hi and thanks for the answer 2015-09-04 11:45 GMT+02:00 Albe Laurenz : > Etienne Champetier wrote: > > We are planning to add a C extension ( > https://github.com/petropavel13/pg_rrule) to our shared > > postgresql cluster, and wondering what are the risk? (looking for the > worst case scenario h

[GENERAL] Any thoughts on a better approach to this query?

2015-09-04 Thread David G. Johnston
​Formatted query attached in addition to placing it inline. The commentary is inline with the query. Basically I've already solved this problem but was wondering if someone has a different perspective; or simply observations. TIA, David J. /* For a given id there are multiple linked values of

[GENERAL] in defensive of zone_reclaim_mode on linux

2015-09-04 Thread Ben Chobot
Over the last several months, I've seen a lot of grumbling about how zone_reclaim_mode eats babies, kicks puppies, and basically how you should just turn it off and live happily ever after. I thought I should add a counterexample, because that advice has not proven very good for us. Some facts

[GENERAL] Buffers: shared hit/read to shared_buffers dependence

2015-09-04 Thread Pavel Suderevsky
Hi, When I have been passing through "Understanding explain" manual ( http://www.dalibo.org/_media/understanding_explain.pdf) I've faced some strange situation when table with size of 65MB completely placed in cache with shared_buffers=320MB and it doesn't with shared_buffers <= 256MB. Actually be

[GENERAL] Trouble setting up replication

2015-09-04 Thread clmartin
I have been trying to set up "hot standby" replication, but have run into problems, and hope someone here can help. I have configured an ssh tunnel from a computer that is not on a public IP, and was unable to figure out how to run pg_basebackup from that server to backup the data from the mai