[GENERAL] Installing module for 9.6, not 9.2, on Centos?

Hi. I recently installed 9.6 on my Centos 6.9 server, alongside a still-running 9.2. I need to install a module for 9.6 (table_log) that is installed on 9.2. I took the table_log Makefile and changed it to point to /usr/pgsql-9.6/bin/pg_config instead of 9.2. It is still installing into the 9.2

[GENERAL] shard_manager extension on PGXN

Hello, Regarding this thread : https://www.postgresql.org/message-id/0683F5F5A5C7FE419A752A034B4A0B979778864A%40sswchi5pmbx2.peak6.net And after reading https://pgxn.org/dist/shard_manager/0.0.1/doc/shard_manager.html#shard_manager.Extension Column data for sharding not only series type ,

Re: [GENERAL] issue performing a switchover with repmgr

On 05/22/2017 05:14 PM, Dylan Luong wrote: Thanks for you answer. So is there a way to remove this -w from the repmgr switchover process? There might be but I would not do it. Pretty sure there is a reason why repmgr wants to make sure the server is accepting connections before moving on fr

Re: [GENERAL] issue performing a switchover with repmgr

Thanks for you answer. So is there a way to remove this -w from the repmgr switchover process? -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, 22 May 2017 10:27 PM To: Dylan Luong ; pgsql-general@postgresql.org Subject: Re: [GENERAL] issue performi

Re: [GENERAL] logical replication in PG10 BETA

On 05/22/2017 12:33 PM, Igor Neyman wrote: Hi, Does built-in logical replication work on Windows in PG10 BETA release? Short version: Maybe. Long version: AFAIK to run on Windows you need to build pglogical 2.0 from source master branch. So what version of pglogical and how did you insta

[GENERAL] logical replication in PG10 BETA

Hi, Does built-in logical replication work on Windows in PG10 BETA release? I can't make it working so far. I created Publication on "source" PG server, but when I'm trying to CREATE SUBSCRIPTION... on "destination" server, I'm getting: "ERROR: could not connect to the publisher: could not send

[GENERAL] Please participate in a research survey on graphs

Hi, My name is Siddhartha Sahu and I am a Master's student at University of Waterloo working on graph processing with Prof. Semih Salihoglu. As part of my research, I am running a survey on how graphs are used in the industry and academia. If you use PostgreSQL to store and query graphs, can you

Re: [GENERAL] how to use the struct "RangeFunction" in Postgres 9.6 ?

lin writes: > I am puzzled for how to use the struct "RangeFunction" in Postgres 9.6, the > struct "RangeFunction" is not the same with 9.3. > Can someone help me how to write the function "make_RangeFunction"? You probably want to look at "func_table:" and associated productions in gram.y, an

Re: [GENERAL] issue performing a switchover with repmgr

On 05/22/2017 01:15 AM, Dylan Luong wrote: Hi I have setup a master/standby on PostgreSQL95 on two test servers and trialing out repmgr. (https://github.com/2ndQuadrant/repmgr/) I am testing a switchover using the following: -bash-4.1$ repmgr -f /etc/repmgr/9.5/repmgr.conf -C /etc/repmgr/9.

[GENERAL] how to use the struct "RangeFunction" in Postgres 9.6 ?

Hi all, I am puzzled for how to use the struct "RangeFunction" in Postgres 9.6, the struct "RangeFunction" is not the same with 9.3. Can someone help me how to write the function "make_RangeFunction"? the code as below: SelectStmt *stmt = makeNode(SelectStmt); List *args = list

[GENERAL] issue performing a switchover with repmgr

Hi I have setup a master/standby on PostgreSQL95 on two test servers and trialing out repmgr. (https://github.com/2ndQuadrant/repmgr/) I am testing a switchover using the following: -bash-4.1$ repmgr -f /etc/repmgr/9.5/repmgr.conf -C /etc/repmgr/9.5/repmgr.conf standby switchover -L DEBUG -v