[GENERAL] PostgreSQL Portable for Linux

2017-05-12 Thread Alejandro Carrillo
Good morning / afternoon / night, I already updated the PostgreSQL Portable for Linux Debian and him flawors. Tested on Debian Jessie and Ubuntu 17.4. Its a 7z file.https://sourceforge.net/projects/pgsqlportable/files/9.6/pgsql%209.6x64.7z/download Please look the description of the project to r

Re: [GENERAL] Partitioning and Table Inheritance

2017-05-12 Thread Andrew Staller
Hi Paul, How much of your data is time-series in nature? Put another way, is there a timestamp coupled with the inserted data? Andrew On Fri, May 12, 2017 at 4:38 PM, Ivan E. Panchenko < i.panche...@postgrespro.ru> wrote: > Hi > > > 12.05.2017 23:22, Justin Pryzby пишет: > >> On Mon, May 08, 20

Re: [GENERAL] Partitioning and Table Inheritance

2017-05-12 Thread Ivan E. Panchenko
Hi 12.05.2017 23:22, Justin Pryzby пишет: On Mon, May 08, 2017 at 10:12:18AM -0700, Paul A Jungwirth wrote: I'm working on a problem where partitioning seems to be the right approach, but we would need a lot of partitions (say 10k or 100k). Everywhere I read that after ~100 child tables you ex

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-12 Thread Tom Lane
Mathieu Fenniak writes: > I've taken your patches, Tom, and applied them to a test deployment of my > actual application. > The most accessible way I have to reproduce this issue is to run a > maintenance task that we typically run during a software deployment, which > will remove some tenant sch

Re: [GENERAL] Partitioning and Table Inheritance

2017-05-12 Thread Justin Pryzby
On Mon, May 08, 2017 at 10:12:18AM -0700, Paul A Jungwirth wrote: > I'm working on a problem where partitioning seems to be the right > approach, but we would need a lot of partitions (say 10k or 100k). > Everywhere I read that after ~100 child tables you experience > problems. I have a few questio

Re: [GENERAL] Logical decoding CPU-bound w/ large number of tables

2017-05-12 Thread Mathieu Fenniak
Hi Tom, Andres, I've taken your patches, Tom, and applied them to a test deployment of my actual application. The most accessible way I have to reproduce this issue is to run a maintenance task that we typically run during a software deployment, which will remove some tenant schemas from our data

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 09:19 AM, Martin Goodson wrote: On 12/05/2017 16:59, Adrian Klaver wrote: Configuring Automatic failover using Replication Manager 2.0 on PostgreSQL 9.3.5 http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html "In this post, am demonstrating Replicatio

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 09:14 AM, Martin Goodson wrote: On 12/05/2017 16:48, Adrian Klaver wrote: On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: The EDB installer allows you to specify where to install PostgreSQL, and uses /opt/PostgreSQL/ for the default.

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
On 12/05/2017 16:59, Adrian Klaver wrote: Configuring Automatic failover using Replication Manager 2.0 on PostgreSQL 9.3.5 http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html "In this post, am demonstrating Replication Manager on single node(localhost) on RHEL 6.

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
On 12/05/2017 16:48, Adrian Klaver wrote: On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: Thanks for the response. The problem is I'm kind of stuck with using EnterpriseDB's community edition installers. It's a company policy. I can't install Postg

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Thanks for the response. The problem is I'm kind of stuck with using EnterpriseDB's community edition installers. It's a company policy. I can't in

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: Thanks for the response. The problem is I'm kind of stuck with using EnterpriseDB's community edition installers. It's a company policy. I can't install PostgreSQL using repositories, I ** have ** to u

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed to be 'you need to compile it'. Time for

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
On 12/05/2017 16:18, Joshua D. Drake wrote: On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Joshua D. Drake
On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed to be 'you need to compile it'. I'm running u

[GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed to be 'you need to compile it'. Time for round 2, trying to compile it with our own envi

Re: [GENERAL] Top posting....

2017-05-12 Thread Francisco Olarte
George: On Fri, May 12, 2017 at 2:23 AM, George Neuner wrote: > I agree 100%. But excessive brevity can make it so a reader can't > follow the conversation. Users of web forums often assume *you* can > easily look back up the thread because *they* can. In my experience, > it isn't always easy