Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag

On Wed, Aug 05, 2020 at 06:36:15PM +, Mariya Rampurawala wrote: > What I want to understand is that, in case of replication link > failure, there will still be inserts happening at the master > node. In that case, how will the slave know if it is up-to-date? It cannot do that by itself, which

Re: Check replication lag

On Thu, Aug 6, 2020 at 7:02 AM Sreejith P wrote: > IN SYNC mode of replication what would be the impact on Master DB server in > terms of over all performance ? The pg_stat_replication columns write_lag, flush_lag and replay_lag are designed tell you how long to expect commits to take for synch

Re: Doubt in pgbase

Thanks, I'll check it out. On Thu, 6 Aug, 2020, 07:51 Ian Barwick, wrote: > On 2020/08/06 11:10, Rama Krishnan wrote: > > Hi Experts, > > > > > > > > Can anyone explain me how the pg base backup will works? > > Have you seen the documentation page? > > https://www.postgresql.org/docs/curren

Re: Doubt in pgbase

On 2020/08/06 11:10, Rama Krishnan wrote: Hi Experts, Can anyone explain me how the pg base backup will works? Have you seen the documentation page? https://www.postgresql.org/docs/current/app-pgbasebackup.html It contains an explanation of how pg_basebackup works. Regards Ian Barwi

Doubt in pgbase

Hi Experts, Can anyone explain me how the pg base backup will works? Thanks Rama Krishnan

Re: Unexplained disk usage in AWS Aurora Postgres

On Tue, Aug 4, 2020 at 4:39 AM Chris Borckholder < chris.borckhol...@bitpanda.com> wrote: > Hi! > > We are experiencing a strange situation with an AWS Aurora postgres > instance. > The database steadily grows in size, which is expected and normal. > After enabling logical replication, the disk us

Postgres, High Availability, patching servers sequentially

Hi: version 9.6 on linux Our IT dept configured our DB to be "High Availability" a couple months back. I believe this means there's a backup server and disks that mirror the main and can kick in should main go down. They need to install a patch on the servers which will require server downtime.

Re: [EXTERNAL] RE: PostgreSQL-12 replication. Check replication lag

Hi Ahmed, Can you please elaborate? One way I found to check the time lag is this: postgres=# SELECT CASE WHEN pg_last_wal_receive_lsn() = pg_last_wal_replay_lsn() THEN 0 ELSE EXTRACT (EPOCH FROM now() - pg_last_xact_replay_timestamp()) END AS log_delay; What I want to understand is that,

Check replication lag

Hi, Am using SELECT (now() - pg_last_xact_replay_timestamp()) < '1’) min for identifying replication lag. Is there any better option available in postgres 10. IN SYNC mode of replication what would be the impact on Master DB server in terms of over all performance ? Thanks Sreejith. --

RE: PostgreSQL-12 replication. Check replication lag

Hi, You could achieve that with a combination of those functions and querying the pg_stat_replication on either side of your setup. Regards, [Fuji Xerox Australia] Nawaz Ahmed Database Administrator Fuji Xerox Australia Pty. Limited 8 Khartoum Rd, Macquarie Park NSW 2113 Australia | P: 02 9856

Re: ERROR: canceling statement due to user request

Le mer. 5 août 2020 à 11:57, Pavel Stehule a écrit : > > > st 5. 8. 2020 v 12:51 odesílatel FOUTE K. Jaurès > napsal: > >> Ok, >> Just want if we can avoid this error message, With some config for >> exemple ? >> > > it is not possible > Ok Thx for feedback > > Pavel > >> >> Le mer. 5 août 2020

Re: ERROR: canceling statement due to user request

File a bug report to that these messages are Informationals instead of errors. On 8/5/20 5:50 AM, FOUTE K. Jaurès wrote: Ok, Just want if we can avoid this error message, With some config for exemple ? Le mer. 5 août 2020 à 11:07, Paul Förster > a écrit :

Re: ERROR: canceling statement due to user request

st 5. 8. 2020 v 12:51 odesílatel FOUTE K. Jaurès napsal: > Ok, > Just want if we can avoid this error message, With some config for exemple > ? > it is not possible Pavel > > Le mer. 5 août 2020 à 11:07, Paul Förster a > écrit : > >> Hi Jaurès, >> >> > On 05. Aug, 2020, at 11:35, FOUTE K. Jau

Re: ERROR: canceling statement due to user request

Ok, Just want if we can avoid this error message, With some config for exemple ? Le mer. 5 août 2020 à 11:07, Paul Förster a écrit : > Hi Jaurès, > > > On 05. Aug, 2020, at 11:35, FOUTE K. Jaurès > wrote: > > > > Hello, > > > > How can I Solve this error ? > > > > ERROR: canceling statement du

Re: ERROR: canceling statement due to user request

st 5. 8. 2020 v 12:07 odesílatel Paul Förster napsal: > Hi Jaurès, > > > On 05. Aug, 2020, at 11:35, FOUTE K. Jaurès > wrote: > > > > Hello, > > > > How can I Solve this error ? > > > > ERROR: canceling statement due to user request > > simple: don't make the user hit ctrl-c or otherwise interr

Re: ERROR: canceling statement due to user request

Hi Jaurès, > On 05. Aug, 2020, at 11:35, FOUTE K. Jaurès wrote: > > Hello, > > How can I Solve this error ? > > ERROR: canceling statement due to user request simple: don't make the user hit ctrl-c or otherwise interrupt a transaction in progress. As soon, as a transaction is interrupted,

Re: ERROR: canceling statement due to user request

st 5. 8. 2020 v 11:35 odesílatel FOUTE K. Jaurès napsal: > Hello, > > How can I Solve this error ? > > ERROR: canceling statement due to user request > You cannot handle this exception. What is a problem with it? It is normal situation - statement was cancelled. Regards Pavel > Best Regard

ERROR: canceling statement due to user request

Hello, How can I Solve this error ? ERROR: canceling statement due to user request Best Regards, -- Jaurès FOUTE

Re: Track pgsql steps

Hi st 29. 7. 2020 v 19:55 odesílatel Olivier Leprêtre napsal: > Hi, > > > > I have a rather long pgsql procedure and I would like to detect which step > is currently executing (subscript 1,2,3…). Due to transaction isolation, > it’s not possible to make it write in a table or get nexval from a s