NabismoPrime on Nostr: Have been testing a distributed relay deployment using a PostgreSQL database cluster ...
Have been testing a distributed relay deployment using a PostgreSQL database cluster and woke up this morning to find the public schema either corrupted or completely deleted on both the master and the read replicas.
Have been doing all sorts of diagnostic work and log searching and still can't figure out what happened here lol. It always pays to make backups of your backups.
Published at
2024-06-02 14:47:25Event JSON
{
"id": "826942960bfd97c567050e50927a1412346de4e223469a7ce010778d838c5e71",
"pubkey": "4503baa127bdfd0b054384dc5ba82cb0e2a8367cbdb0629179f00db1a34caacc",
"created_at": 1717332445,
"kind": 1,
"tags": [],
"content": "Have been testing a distributed relay deployment using a PostgreSQL database cluster and woke up this morning to find the public schema either corrupted or completely deleted on both the master and the read replicas.\n\nHave been doing all sorts of diagnostic work and log searching and still can't figure out what happened here lol. It always pays to make backups of your backups.\n\nhttps://image.nostr.build/276f77708b5e2a4eb0e0fc35bc18477c01c2368f0a7bdb17206c8ea66929bdbb.gif\n\n",
"sig": "92a93e50b2da12654bcce9ab8e15d0fbc7eb089e070a9a3ab7104c86b0a5843e9eb638e01793fbe04152bd4c3c7d86f4cdc4e9ba3b0202a0e2919a71dc9acdac"
}