how to cross check the wal log count from primary and standby ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Classification: External


Dear All,

 

The below error I have pulled from master database after shutting down the standby database then I tried to shutdown master but I got the FATEL error,

Later after shuttindown the standby service ( postgresql-10.service) then master db is shutdown now.

 

 

Someone Let me know how to validate the wal log file count with primary and standby ?

 

 

 

scp: /data/ARCHIVELOG/000000010000001C000000AA: No space left on device

2020-04-26 13:50:26 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:50:26 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001C000000AA 172.29.7.194:/data/ARCHIVELOG/000000010000001C000000AA

2020-04-26 13:50:26 GMT  WARNING:  archiving write-ahead log file "000000010000001C000000AA" failed too many times, will try again later

2020-04-26 13:53:08 GMT  LOG:  received fast shutdown request

2020-04-26 13:53:08 GMT  LOG:  aborting any active transactions

2020-04-26 13:53:08 GMT  LOG:  worker process: logical replication launcher (PID 6648) exited with exit code 1

2020-04-26 13:53:08 GMT  LOG:  shutting down

2020-04-26 13:54:24 GMT [unknown] [unknown]LOG:  connection received: host=[local]

2020-04-26 13:54:24 GMT postgres postgresFATAL:  the database system is shutting down

2020-04-26 13:54:41 GMT [unknown] [unknown]LOG:  connection received: host=[local]

2020-04-26 13:54:41 GMT postgres postgresFATAL:  the database system is shutting down

packet_write_wait: Connection to 172.29.7.194 port 22: Broken pipe

lost connection

2020-04-26 13:54:56 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:54:56 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001D0000000A 172.29.7.194:/data/ARCHIVELOG/000000010000001D0000000A

ssh: connect to host 172.29.7.194 port 22: Connection refused

lost connection

2020-04-26 13:54:57 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:54:57 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001D0000000A 172.29.7.194:/data/ARCHIVELOG/000000010000001D0000000A

ssh: connect to host 172.29.7.194 port 22: Connection refused

lost connection

2020-04-26 13:54:58 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:54:58 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001D0000000A 172.29.7.194:/data/ARCHIVELOG/000000010000001D0000000A

2020-04-26 13:54:58 GMT  WARNING:  archiving write-ahead log file "000000010000001D0000000A" failed too many times, will try again later

ssh: connect to host 172.29.7.194 port 22: Connection refused

lost connection

2020-04-26 13:54:58 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:54:58 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001D0000000A 172.29.7.194:/data/ARCHIVELOG/000000010000001D0000000A

ssh: connect to host 172.29.7.194 port 22: Connection refused

lost connection

2020-04-26 13:54:59 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:54:59 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001D0000000A 172.29.7.194:/data/ARCHIVELOG/000000010000001D0000000A

ssh: connect to host 172.29.7.194 port 22: Connection timed out

lost connection

2020-04-26 13:57:09 GMT  LOG:  archive command failed with exit code 1

2020-04-26 13:57:09 GMT  DETAIL:  The failed archive command was: scp pg_wal/000000010000001D0000000A 172.29.7.194:/data/ARCHIVELOG/000000010000001D0000000A

2020-04-26 13:57:09 GMT  WARNING:  archiving write-ahead log file "000000010000001D0000000A" failed too many times, will try again later

2020-04-26 13:57:10 GMT  LOG:  database system is shut down

[postgres@de284194 log]$

 

 

Thanks and Best Wishes

Ashok

+91 81975 99922(WhatsApp)


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux