Python Podcast

dataanalytics

💥 Downtime isn’t an option.

In this new DZone article, learn how to proactively prepare your #PostgreSQL database for disaster recovery—ensuring high availability, data integrity, and business continuity.

🔗 Read now: https://hubs.la/Q03qGDPh0

For more information on pgEdge, visit: https://hubs.la/Q03qGHYs0

#tech #data #database #developer #opensource #pgEdge #datascience #dataanalytics #devcommunity #dba

Check the PostgreSQL Log Files
Start by inspecting the log files. Typically, you'll find the log files in /var/log/postgresql/ or $PGDATA/pg_log. Within the log files, entry headers indicate the severity level of the log entry; for example:

Shell
1 ERROR: could not read block 128 in file "base/16384/12571": read only @ of 8192 bytes
2 PANIC: invalid page in block 42 of relation base/16384/16728
3 LOG: startup process (PID 1234) was terminated by signal 6: Aborted
4 FATAL: the database system is in recovery mode

ALT

0 0 0 View Post & Replies See Original

Now I've switched from my old instance to this new one, I figured I'd re-post an #introduction tweet

Hi, I'm Matt!

Married to my wonderful wife! Got a #Doggo

#Tech #Timepieces #Tinkering #Tabletop are my interests

I #SelfHost a bunch of things, I like #HomeAutomation with #HomeAssistant, I'm interested in #DataAnalytics and seeing what I can learn from data in my house

Fuck the Tories
Punch a Nazi
Eat the rich

😃

Edited 3y ago

0 0 0 View Post & Replies See Original