Ufdjrw

What does "I’d sit this one out, Cap," imply or mean in the context?

Do sorcerers' subtle spells require a skill check to be unseen?

How can we prove that any integral in the set of non-elementary integrals cannot be expressed in the form of elementary functions?

Method to test if a number is a perfect power?

How to Reset Passwords on Multiple Websites Easily?

How to be diplomatic in refusing to write code that breaches the privacy of our users

How do scammers retract money, while you can’t?

Two monoidal structures and copowering

What is the difference between "behavior" and "behaviour"?

Is there a problem with hiding "forgot password" until it's needed?

How to check is there any negative term in a large list?

Increase performance creating Mandelbrot set in python

How to pronounce the slash sign

Avoiding estate tax by giving multiple gifts

Balance Issues for a Custom Sorcerer Variant

Is `x >> pure y` equivalent to `liftM (const y) x`

Is this apparent Class Action settlement a spam message?

A particular customize with green line and letters for subfloat

What does the word "Atten" mean?

Do all network devices need to make routing decisions, regardless of communication across networks or within a network?

Was Spock the First Vulcan in Starfleet?

Why didn't Theresa May consult with Parliament before negotiating a deal with the EU?

Risk of infection at the gym?

How to write papers efficiently when English isn't my first language?

why does my primary server display sent_location vs replay_location and others value

PostgreSQL 9.1 streaming replication restore_command: special meaning of exit code 255?Bad value for type timestamp on production serverWhy does this query causes sequential scan?Why does a missing primary key/unique key cause deadlock issues on upsert?PostgreSQL Connection Failover using jdbc string error in Java ApplicationBarman server unable to connect to PrimaryERROR: integer out of range In postgresqlstandby crashes on receiving INSERT/DELETE query instead of throwing error messagerepmgr - Automate process of making primary to standby after failoverPgpool executes queries on standby nodes instead of master when replication is behind in standby

0

Ok, I have a primary(9.6.9) and a replica(9.6.12) PostgreSQL server.

I have read the formal definition over here

But I fail to understand why does all of these information i.e replay_location, flushed_location, write_location (when I run select * from pg_stat_replication) is displayed on my primary server display. Since the doc says clear say it is supposed to be part of this standby server.

and when I run pg_stat_replication on the standby or replica server I see nothing.

Any anyone explains why is this so?

Any clue?

postgresql postgresql-9.6

share|improve this question

asked Mar 7 at 12:49

NoobieNoobie

9012

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Understood because of the standby server generally sent this information to the primary
  
  – Noobie
  Mar 13 at 14:39
  

  
  
  
  

add a comment | 

0

Ok, I have a primary(9.6.9) and a replica(9.6.12) PostgreSQL server.

I have read the formal definition over here

But I fail to understand why does all of these information i.e replay_location, flushed_location, write_location (when I run select * from pg_stat_replication) is displayed on my primary server display. Since the doc says clear say it is supposed to be part of this standby server.

and when I run pg_stat_replication on the standby or replica server I see nothing.

Any anyone explains why is this so?

Any clue?

postgresql postgresql-9.6

share|improve this question

asked Mar 7 at 12:49

NoobieNoobie

9012

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Understood because of the standby server generally sent this information to the primary
  
  – Noobie
  Mar 13 at 14:39
  

  
  
  
  

add a comment | 

Ok, I have a primary(9.6.9) and a replica(9.6.12) PostgreSQL server.

I have read the formal definition over here

But I fail to understand why does all of these information i.e replay_location, flushed_location, write_location (when I run select * from pg_stat_replication) is displayed on my primary server display. Since the doc says clear say it is supposed to be part of this standby server.

and when I run pg_stat_replication on the standby or replica server I see nothing.

Any anyone explains why is this so?

Any clue?

postgresql postgresql-9.6

share|improve this question

asked Mar 7 at 12:49

NoobieNoobie

9012

share|improve this question

asked Mar 7 at 12:49

NoobieNoobie

9012

share|improve this question

asked Mar 7 at 12:49

NoobieNoobie

9012

asked Mar 7 at 12:49

NoobieNoobie

9012

asked Mar 7 at 12:49

NoobieNoobie

9012