Unanswered: PostgreSQL databases keep crashing-How to build failover
I'm a SQL Server DBA, but have recently started at a company that is currently in a postgresQL enivorment and as of late their database has been crash at night.
They are currently looking for a quick and dirty failover solution, while a long term solutioon is in place.
What are some quick and dirty soultions that can be put in place for if the database goes down, we can still keep the frontend up and going with a switch over to another source?
Any thouhts, ideas, and solutions I'm all open to hearing.
Postgres crashing is something very unusual.
You should first investigate what exactly is the reason for the crash. Very often bad hardware (harddisk, memory) can cause this and that should be fixed in the first place.
Replication to a standby is built right into Postgres