Re: pgbackrest when data/base is symlinked to another volume

2018-09-07 Thread Ron
On 09/07/2018 05:22 PM, David Steele wrote: Hi Ron, On 9/6/18 11:21 PM, Ron wrote: Will pgbackrest properly backup and restore the cluster if data/base, data/pg_xlog and data/pg_log are symlinks? PGDATA=/var/lib/pgsql/9.6/data $PGDATA/base -> /Database/9.6/base $PGDATA/pg_log -> /Database/9

Re: pgbackrest when data/base is symlinked to another volume

2018-09-07 Thread Ron
On 09/07/2018 05:22 PM, David Steele wrote: Hi Ron, On 9/6/18 11:21 PM, Ron wrote: Will pgbackrest properly backup and restore the cluster if data/base, data/pg_xlog and data/pg_log are symlinks? PGDATA=/var/lib/pgsql/9.6/data $PGDATA/base -> /Database/9.6/base $PGDATA/pg_log -> /Database/9

Re: pgbackrest when data/base is symlinked to another volume

2018-09-07 Thread David Steele
Hi Ron, On 9/6/18 11:21 PM, Ron wrote: Will pgbackrest properly backup and restore the cluster if data/base, data/pg_xlog and data/pg_log are symlinks? PGDATA=/var/lib/pgsql/9.6/data $PGDATA/base -> /Database/9.6/base $PGDATA/pg_log -> /Database/9.6/pg_log $PGDATA/pg_xlog -> /Database/9.6/pg

Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Andrew Staller
Hi All, Full disclosure: I'm a Timescale employee. Fabio, really interesting analysis and we can generally confirm the conclusions of your tests. As Thomas pointed out above, TimescaleDB is an open-source time-series database packaged as Postgres extension. We are always interested in performance c

Re: connection error

2018-09-07 Thread amul sul
On Fri, Sep 7, 2018 at 5:10 PM amul sul wrote: > > Do you have following entry as well? > > # IPv6 local connections: > hostall all ::1/128 trust > > I hope "listen_addresses " in postgresql.conf is on default setting. > Sorry, I misread -- your local p

Re: connection error

2018-09-07 Thread amul sul
Do you have following entry as well? # IPv6 local connections: hostall all ::1/128 trust I hope "listen_addresses " in postgresql.conf is on default setting. Regards, Amul Sul On Fri, Sep 7, 2018 at 4:08 PM Sonam Sharma wrote: > > getting below error

Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Benjamin Scherrey
Interesting and useful article, Fabio. I'm actually quite curious about your evaluation of MongoDB & Postgres. I've been operating under the opinion that MongoDB has been obsoleted in every respect by Postgres and am curious as to whether there are any credible use cases where, given the opportunit

Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Thomas Kellerer
Fabio Pardi schrieb am 07.09.2018 um 10:07: > Hi, > I recently published a blog article reporting a small research I made on > the usage of InfluxDB and PostgreSQL for time series, together with > Grafana on my specific use case. > > I think that some of you might find it interesting, maybe inspir

connection error

2018-09-07 Thread Sonam Sharma
getting below error from application side : Last acquisition attempt exception: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. the port no is set correct : [postgres@lxsqlptgs

Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Fabio Pardi
Hi Achilleas, I'm glad you like the article. Probably I will find the time to come back to the topic when I'm done comparing Mongodb with PostgreSQL regards, fabio pardi On 07/09/18 11:18, Achilleas Mantzios wrote: > Nice read! Wonder if you could repeat the tests on pgsql 10.5 and btree/BRI

Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Achilleas Mantzios
On 07/09/2018 11:07, Fabio Pardi wrote: Hi, I recently published a blog article reporting a small research I made on the usage of InfluxDB and PostgreSQL for time series, together with Grafana on my specific use case. I think that some of you might find it interesting, maybe inspiring or perha

Re: bad url in docs

2018-09-07 Thread Arthur Zakirov
On Thu, Sep 06, 2018 at 04:57:17PM -0600, Rob Sargent wrote: > Sorry.  I didn't see the specific form for documentations issues. There is a link [1] on bottom of the documentation page [2] to the report form. It is in the "Submit correction" section. A documentation issue is sent to pgsql-docs mai

A Timeseries Case Study: InfluxDB VS PostgreSQL

2018-09-07 Thread Fabio Pardi
Hi, I recently published a blog article reporting a small research I made on the usage of InfluxDB and PostgreSQL for time series, together with Grafana on my specific use case. I think that some of you might find it interesting, maybe inspiring or perhaps it can trigger some interesting discuss