Re: What generates pg_config.h?

2018-01-05 Thread Travis Allison
Tom, I guess I don't understand the point of having a different pg_config.h in my user/include/postgresql directory than the postgresql server that I am running. You mentioned building client code that would reference the pg_config.h in user/include/postgresql. A couple of questions: What type o

Re: What generates pg_config.h?

2018-01-05 Thread Tom Lane
Travis Allison writes: > I suppose an easy workaround is to copy my version 9.6 pg_config.h into my > user/include/postgresql directory and replace the one installed by > libpq-dev. > Can you think of any detrimental side-effects from doing that? I would not recommend that: it's likely to break

Re: What generates pg_config.h?

2018-01-05 Thread Travis Allison
I suppose an easy workaround is to copy my version 9.6 pg_config.h into my user/include/postgresql directory and replace the one installed by libpq-dev. Can you think of any detrimental side-effects from doing that? Travis On Fri, Jan 5, 2018 at 3:40 PM, Adrian Klaver wrote: > On 01/05/2018 03

Re: Postgres HA

2018-01-05 Thread Azimuddin Mohammed
Thank you..I have subscribed to the list.. On Jan 5, 2018 8:09 PM, "Tatsuo Ishii" wrote: > Hi, > > Yes, definitely I am hanging out here. > > If you have more specific questions to Pgpool-II, you are encouraged > to be subscribed to the Pgpool-II mailing list. > https://www.pgpool.net/mailman/l

Re: Postgres HA

2018-01-05 Thread Tatsuo Ishii
Hi, Yes, definitely I am hanging out here. If you have more specific questions to Pgpool-II, you are encouraged to be subscribed to the Pgpool-II mailing list. https://www.pgpool.net/mailman/listinfo/pgpool-general Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.j

Re: Postgres HA

2018-01-05 Thread John Scalia
What he said, and you also may want to look at pgpool-II. I’ve had fairly good luck with that and Tatsuo (the author) hangs out here occasionally too. — Jay Sent from my iPad > On Jan 5, 2018, at 4:00 PM, Jehan-Guillaume (ioguix) de Rorthais > wrote: > > On Fri, 5 Jan 2018 13:07:10 -0600 > Az

Re: What generates pg_config.h?

2018-01-05 Thread Adrian Klaver
On 01/05/2018 03:29 PM, Tom Lane wrote: Travis Allison writes: Tom, where's the -l switch exactly? What command is it attached to? (I'm not sure what to look for.) Look into the extension's Makefile for something roughly along the lines of Assuming the OP is talking about this: https://gi

Re: What generates pg_config.h?

2018-01-05 Thread Tom Lane
Travis Allison writes: > Tom, where's the -l switch exactly? What command is it attached to? (I'm > not sure what to look for.) Look into the extension's Makefile for something roughly along the lines of CPPFLAGS = -I/usr/include/postgresql Very likely there's some amount of macro-ization invo

Re: What generates pg_config.h?

2018-01-05 Thread Travis Allison
Tom, where's the -l switch exactly? What command is it attached to? (I'm not sure what to look for.) Thanks, Travis On Fri, Jan 5, 2018 at 2:56 PM, Tom Lane wrote: > Alvaro Herrera writes: > > Travis Allison wrote: > >> No instance of Postgres 10 running. I took Tom's suggestion: I ran dpkg

Re: What generates pg_config.h?

2018-01-05 Thread Tom Lane
Alvaro Herrera writes: > Travis Allison wrote: >> No instance of Postgres 10 running. I took Tom's suggestion: I ran dpkg -S >> /usr/include/postgresql/pg_config.h >> Result: libpq-dev: /usr/include/postgresql/pg_config.h Ah, thanks for clearing that up. >> Any suggestions on what to do next? >

Re: What generates pg_config.h?

2018-01-05 Thread Alvaro Herrera
Travis Allison wrote: > No instance of Postgres 10 running. I took Tom's suggestion: I ran dpkg -S > /usr/include/postgresql/pg_config.h > Result: libpq-dev: /usr/include/postgresql/pg_config.h > > Here is the result from dpkg-query -l | grep libpq > > ii libpq-dev

Re: Postgres HA

2018-01-05 Thread Jehan-Guillaume (ioguix) de Rorthais
On Fri, 5 Jan 2018 13:07:10 -0600 Azimuddin Mohammed wrote: > Hello, > I am little confused with how HA works in postgres. Reading the article > which state as below "*If the primary server fails and the standby server > becomes the new primary, and then the old primary restarts, you must have a

Re: What generates pg_config.h?

2018-01-05 Thread Travis Allison
No instance of Postgres 10 running. I took Tom's suggestion: I ran dpkg -S /usr/include/postgresql/pg_config.h Result: libpq-dev: /usr/include/postgresql/pg_config.h Here is the result from dpkg-query -l | grep libpq ii libpq-dev 10.0-1.pgdg16.04+1

Re: What generates pg_config.h?

2018-01-05 Thread rob stone
Hello, On Fri, 2018-01-05 at 12:19 -0800, Adrian Klaver wrote: > On 01/05/2018 11:57 AM, Travis Allison wrote: > > Distro and version: Ubuntu 16.04 LTS. > > > > If memory serves, I installed 9.5 using synaptic and 9.6 using apt- > > get, > > where I followed the instructions from this site: >

Re: What generates pg_config.h?

2018-01-05 Thread Adrian Klaver
On 01/05/2018 11:57 AM, Travis Allison wrote: Distro and version:  Ubuntu 16.04 LTS. If memory serves, I installed 9.5 using synaptic and 9.6 using apt-get, where I followed the instructions from this site: https://www.postgresql.org/download/linux/ubuntu/ I also have an anaconda installatio

Re: What generates pg_config.h?

2018-01-05 Thread Tom Lane
Travis Allison writes: > Distro and version: Ubuntu 16.04 LTS. > If memory serves, I installed 9.5 using synaptic and 9.6 using apt-get, > where I followed the instructions from this site: > https://www.postgresql.org/download/linux/ubuntu/ > I also have an anaconda installation of postgresql, b

Re: What generates pg_config.h?

2018-01-05 Thread Travis Allison
Distro and version: Ubuntu 16.04 LTS. If memory serves, I installed 9.5 using synaptic and 9.6 using apt-get, where I followed the instructions from this site: https://www.postgresql.org/download/linux/ubuntu/ I also have an anaconda installation of postgresql, but that is a version less than 9.

Re: Postgres HA

2018-01-05 Thread Rui DeSousa
There are many different solutions; but I would recommend and use a least a three node cluster using synchronous replication where one of the nodes is acting as the witness — at a minimum (actual have more replicas). The witness node need not be a full Postgres instance; it can also be achieved

Re: Postgres HA

2018-01-05 Thread Scott Marlowe
On Fri, Jan 5, 2018 at 12:07 PM, Azimuddin Mohammed wrote: > > Hello, > I am little confused with how HA works in postgres. Reading the article which > state as below "If the primary server fails and the standby server becomes > the new primary, and then the old primary restarts, you must have a

Postgres HA

2018-01-05 Thread Azimuddin Mohammed
Hello, I am little confused with how HA works in postgres. Reading the article which state as below "*If the primary server fails and the standby server becomes the new primary, and then the old primary restarts, you must have a mechanism for informing the old primary that it is no longer the prima

Re: What generates pg_config.h?

2018-01-05 Thread Adrian Klaver
On 01/05/2018 09:07 AM, Travis Allison wrote: Hi, I have postgres 9.5 and 9.6 installed.  pg_config points to 9.6. I am trying to compile a postgresql plugin (Timescaledb).  I am getting an error: --- /usr/include/postgresql/pg_config.h:733:0: warnin

What generates pg_config.h?

2018-01-05 Thread Travis Allison
Hi, I have postgres 9.5 and 9.6 installed. pg_config points to 9.6. I am trying to compile a postgresql plugin (Timescaledb). I am getting an error: --- /usr/include/postgresql/pg_config.h:733:0: warning: "PACKAGE_VERSION" redefined #define PACKAGE_VE