Re: Pg_auto_failover

On Tue, Sep 24, 2019 at 8:41 AM Sonam Sharma wrote: > I was setting up pg_auto_failover. Have successfully set up and monitor > and primary instance. While setting up secondary it's failing with below : > > ERROR Failed to ensure empty directory "//backup" : Permission denied > Error Failed initi

Re: Flood Warning message : user=[unknown],db=[unknown],host= WARNING: pg_getnameinfo_all() failed: Temporary failure in name resolution

On Wed, Jun 5, 2019 at 11:08 AM Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj wrote: > >> >> [64459]: [1-1] user=[unknown],db=[unknown],host= WARNING: >> pg_getnameinfo_all() failed: Temporary failure in name resolution... >> > > First thin

Re: schema change tracking

On Thu, May 16, 2019 at 9:41 AM Benedict Holland < benedict.m.holl...@gmail.com> wrote: > I need a tool that can track schema changes in a postgesql database, write > scripts to alter the tables, and store those changes in git. Are there > tools that exist that can do this? > For dev and QA, my c

Re: Replicate Tables from SAP (DB2/HANA) to PostgreSQL

On Tue, Sep 18, 2018 at 11:31 PM Thomas Güttler < guettl...@thomas-guettler.de> wrote: > Hi, > > is it possible to replicate some tables from SAP to PostgreSQL? > At the moment there are two underlaying database systems. > Some run DB2 and some run SAP-HANA. > In my case it would be nice, if it wo

Re: upgrading from pg 9.3 to 10

Hi Stephen, thanks for the feedback, it is much appreciated! On Mon, Aug 20, 2018 at 12:15 PM Stephen Frost wrote: > * bricklen (brick...@gmail.com) wrote: > > Using pg_upgrade, it is definitely possible to upgrade 9.3 to 10 in one > > jump. We did this in production earlier thi

Re: upgrading from pg 9.3 to 10

Hi Edmundo, On Tue, Aug 14, 2018 at 10:45 AM Edmundo Robles wrote: > Is safe to upgrade from pg 9.3 to pg 10 directly using pg_upgrade or > is better upgrade, with pg_upgrade, from 9.3 -> 9.4 ->9.5 -> 9.6 -> 10. > Using pg_upgrade, it is definitely possible to upgrade 9.3 to 10 in one jump.

Re: How to monitor logical replication initial sync?

On Wed, Mar 7, 2018 at 3:23 PM, Doug Gorley wrote: > Good day, > > How does one monitor the status or progress of an initial sync under > logical replication? For example: > > * I create a publication in database db_pub > * I create a subscription in database db_sub > * In 15 minutes I want to c

Re: Dependency tree to tie type/function deps to a table

On Fri, Dec 15, 2017 at 6:44 AM, Jeremy Finzel wrote: > Here is my current effort. I would love feedback in case I've missed > something. > Perhaps you'll find the version on the wiki useful as reference, it's an older version of the dependencies, and can be found at https://wiki.postgresql.org

Re: Replica on low-bandwitdh network

On Tue, Dec 5, 2017 at 1:12 AM, Job wrote: > we have some postgreswl 9.6.1 servers in two different continent. > Latency is from 180 to 250 ms between the two sites. > > Actually we use Rubyrep for off-site replication, since servers are > completely independent in case of connectivity loss. > >

Re: How clear the cache on postgresql?

On Fri, Nov 24, 2017 at 6:54 AM, hmidi slim wrote: > I'm trying to analyze some queries using the explain instructions and the > option analyze and buffers. I realized that the query refers to the cache > memory to return the results. Is there any solution to clear the cache in > postgresql inord