Re: [GENERAL] Have just libpg installer

2017-05-23 Thread David G. Johnston
On Tuesday, May 23, 2017, John R Pierce wrote: > On 5/23/2017 7:45 PM, Igor Korot wrote: > >> Because I can't find libpg.so or libpg.dylib or libpg.Framework anywhere. >> >> Is there a place to get them? >> > > > maybe because thats not the correct name? its libpq as in PQ.

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Adrian Klaver
On 05/23/2017 08:03 PM, Igor Korot wrote: Adrian, On Tue, May 23, 2017 at 10:45 PM, Igor Korot wrote: Adrian, On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver wrote: On 05/23/2017 04:15 PM, Igor Korot wrote: Adrian, On Tue, May 23, 2017 at

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Adrian Klaver
On 05/23/2017 07:45 PM, Igor Korot wrote: Adrian, On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver wrote: On 05/23/2017 04:15 PM, Igor Korot wrote: Adrian, On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver wrote: On 05/23/2017 09:12 AM,

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread John R Pierce
On 5/23/2017 7:45 PM, Igor Korot wrote: Because I can't find libpg.so or libpg.dylib or libpg.Framework anywhere. Is there a place to get them? maybe because thats not the correct name? its libpq as in PQ. I have no idea what a .Framework file is, but any of the postgres installers for

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Igor Korot
Adrian, On Tue, May 23, 2017 at 10:45 PM, Igor Korot wrote: > Adrian, > > On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver > wrote: >> On 05/23/2017 04:15 PM, Igor Korot wrote: >>> >>> Adrian, >>> >>> On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Igor Korot
Adrian, On Tue, May 23, 2017 at 7:28 PM, Adrian Klaver wrote: > On 05/23/2017 04:15 PM, Igor Korot wrote: >> >> Adrian, >> >> On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver >> wrote: >>> >>> On 05/23/2017 09:12 AM, Igor Korot wrote:

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

2017-05-23 Thread John R Pierce
On 5/23/2017 4:54 PM, Ken Tanzer wrote: But the install still goes to 9.2: PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 install | /bin/mkdir -p '/usr/pgsql-9.2/share/contrib' earlier you said something about /usr/pgsql-9.6/bin ... is it that, or is it

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

2017-05-23 Thread Adrian Klaver
On 05/23/2017 05:54 PM, Ken Tanzer wrote: On Tue, May 23, 2017 at 5:34 PM, Adrian Klaver > wrote: Sorry, not sure I follow what is the trailing part here? Does the compile stage specify where a module is to be installed? Or is

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

2017-05-23 Thread Ken Tanzer
On Tue, May 23, 2017 at 5:34 PM, Adrian Klaver wrote: > On 05/23/2017 05:27 PM, Ken Tanzer wrote: > >> >> But the install still goes to 9.2: >> >> PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 install >> >> >> Did you do: >> >>

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

2017-05-23 Thread Adrian Klaver
On 05/23/2017 05:27 PM, Ken Tanzer wrote: But the install still goes to 9.2: PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 install Did you do: PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 clean all I did. Or is there some environment variable set

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

2017-05-23 Thread Ken Tanzer
> > >> But the install still goes to 9.2: >> >> PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 install >> > > Did you do: > > PATH=/usr/local/pgsql96/bin/:$PATH make USE_PGXS=1 clean all > > I did. > Or is there some environment variable set that could be interfering? > > I didn't see

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

2017-05-23 Thread Adrian Klaver
On 05/23/2017 04:54 PM, Ken Tanzer wrote: Thanks Adrian, though still no luck for me. The compiling was working OK already, the install still goes to 9.2. Where did you get the table_log extension I no longer remember (it's been a few years), but my tgz file was the same as what's on

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

2017-05-23 Thread Ken Tanzer
Thanks Adrian, though still no luck for me. The compiling was working OK already, the install still goes to 9.2. > Where did you get the table_log extension > >> I no longer remember (it's been a few years), but my tgz file was the same as what's on pgfoundry > I usually do something

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Adrian Klaver
On 05/23/2017 01:38 PM, Igor Neyman wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of George Neuner Windows does not support "local" domain sockets as in Unix/Linux. Local loopback connections on Windows are

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Adrian Klaver
On 05/23/2017 04:15 PM, Igor Korot wrote: Adrian, On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver wrote: On 05/23/2017 09:12 AM, Igor Korot wrote: Yes, I mean libpq. Now yes, I can install it from the package manager or from source by just running ../configure

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Igor Korot
Adrian, On Tue, May 23, 2017 at 5:52 PM, Adrian Klaver wrote: > On 05/23/2017 09:12 AM, Igor Korot wrote: >> >> Hi, ALL, >> Is it possible to have just libpg installer for main OSes: Win, Linux, >> Mac? > > > AFAIK there is no libpg library. I going to assume you

Re: [GENERAL] Have just libpg installer

2017-05-23 Thread Adrian Klaver
On 05/23/2017 09:12 AM, Igor Korot wrote: Hi, ALL, Is it possible to have just libpg installer for main OSes: Win, Linux, Mac? AFAIK there is no libpg library. I going to assume you mean the client library libpq. The package systems for Linux and OS X allow you to install just the --client

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Adrian Klaver
On 05/23/2017 08:15 AM, Igor Neyman wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver Sent: Tuesday, May 23, 2017 10:04 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of George Neuner Sent: Tuesday, May 23, 2017 4:22 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On Tue, 23 May 2017 15:15:46

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread George Neuner
On Tue, 23 May 2017 15:15:46 +, Igor Neyman wrote: >Interestingly, when I add this line to pg_hba.conf: > >localall all md5 > >Postgres is not starting with the following error in the log file: > >2017-05-23 11:02:10.397 EDT [4796] LOG:

[GENERAL] Have just libpg installer

2017-05-23 Thread Igor Korot
Hi, ALL, Is it possible to have just libpg installer for main OSes: Win, Linux, Mac? And then just the source code of the client library to compile, since I don't have latest OSX available? Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] libpg sources

2017-05-23 Thread Igor Korot
On Tue, May 23, 2017 at 10:54 AM, John McKown wrote: > On Tue, May 23, 2017 at 9:39 AM, Albe Laurenz > wrote: >> >> Igor Korot wrote: >> >> > Can I put libpg sources into my project? Or I will have to provide >> > binaries? >> >> You can do

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver Sent: Tuesday, May 23, 2017 10:04 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:52 AM, Igor

Re: [GENERAL] libpg sources

2017-05-23 Thread John McKown
On Tue, May 23, 2017 at 9:39 AM, Albe Laurenz wrote: > Igor Korot wrote: > > > Can I put libpg sources into my project? Or I will have to provide > binaries? > > You can do anything you want as long as you stick with the license: >

Re: [GENERAL] libpg sources

2017-05-23 Thread Albe Laurenz
Igor Korot wrote: > Can I put libpg sources into my project? Or I will have to provide binaries? You can do anything you want as long as you stick with the license: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=COPYRIGHT;hb=HEAD All you have to do is include the following

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 10:31 AM To: Igor Neyman ; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 07:05 AM, Igor Neyman wrote: >> >>

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Adrian Klaver
On 05/23/2017 07:05 AM, Igor Neyman wrote: pg_hba.conf modified to allow "replication" user to connect to the server. In the original email I mentioned that I configured Postgres_fdw foreign server that connects using the same connection options as I'm using in CREATE SUBSCRIPTION, and

[GENERAL] libpg sources

2017-05-23 Thread Igor Korot
Hi, ALL, Can I put libpg sources into my project? Or I will have to provide binaries? Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 9:45 AM To: Igor Neyman ; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:33 AM, Igor Neyman wrote: > >

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Adrian Klaver
On 05/23/2017 06:52 AM, Igor Neyman wrote: sounds more like a SSL setup problem between the two Postgres servers, not really related to logical replication. Can you try to setup the connections without SSL?

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer Sent: Tuesday, May 23, 2017 9:46 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA Igor Neyman schrieb am

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Thomas Kellerer
Igor Neyman schrieb am 22.05.2017 um 21:33: > 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: > >

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Adrian Klaver
On 05/23/2017 06:33 AM, Igor Neyman wrote: Yeah, my mistake I was working with pglogical and it got stuck in my head. Any other ideas? Have you gone through these sections of the docs?: https://www.postgresql.org/docs/10/static/logical-replication-config.html

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 9:26 AM To: Igor Neyman ; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:17 AM, Igor Neyman wrote: >

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

2017-05-23 Thread Adrian Klaver
On 05/22/2017 09:41 PM, Ken Tanzer wrote: 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. Where did you get the table_log extension I took the table_log Makefile and changed it to

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Adrian Klaver
On 05/23/2017 06:17 AM, Igor Neyman wrote: -Original Message- "ERROR: could not connect to the publisher: could not send data to server: Socket is not connected (0x2749/10057) could not send SSL negotiation packet: Socket is not connected (0x2749/10057) SQL state: XX000" In

Re: [GENERAL] logical replication in PG10 BETA

2017-05-23 Thread Igor Neyman
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, May 22, 2017 7:56 PM To: Igor Neyman ; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/22/2017 12:33 PM, Igor Neyman wrote: > Hi, >