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
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
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
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
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
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.
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
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
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:
>
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
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
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
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?
>
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
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
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
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
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
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
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
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
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
22 matches
Mail list logo
