From: | Ashok kumar Mani <amani(at)accelaero(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | how to cross check the wal log count from primary and standby ? |
Date: | 2020-04-26 14:10:23 |
Message-ID: | AM0P191MB070834BB0CDEE222BE603BA9AEAE0@AM0P191MB0708.EURP191.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)de284194 log]$
Thanks and Best Wishes
Ashok
+91 81975 99922(WhatsApp)
From | Date | Subject | |
---|---|---|---|
Next Message | Bo Victor Thomsen | 2020-04-26 16:58:07 | Setting up a database with minimum access rights |
Previous Message | Raj kumar | 2020-04-26 12:29:02 | Re: Startup process in slave |