Re:What PostgreSQL has over other open source SQL databases:...
by spacemanmatt on Sunday October 25, 2015 @02:56PM
(#10447889)
The thing is, if your database goes down, it likely needs to stay down until you understand why it went down and whether it's business-safe to turn it back. PostgreSQL almost does not crash. And when it does, you should care about your system's stability, and a crash is a giant message about stability.
Plan for uptime and you'll be more likely to get it, than planning around a buggy server process.
(Also, in this case, it would have violated SOX and PCI rules, as well as general sanity, to host a 512GB 64-core server in the cloud)
Re:What PostgreSQL has over other open source SQL databases:...
by taf2 on Sunday October 25, 2015 @10:12AM
(#10446896)
I'm not sure the floating ip solution from digitalocean is going to be the solution - as it looks like it's only for public ip addresses instead of internal ips... Assuming you only want you db listening on internal ip right?
Re:What PostgreSQL has over other open source SQL databases:...
by brianwawok on Sunday November 01, 2015 @09:04AM
(#10486417)
yah so not perfect for sure. With how PG permissions work I am not sure you lose a lot listening on public interface vs digital ocean private but really semi-private interface.
Which you can do, but it takes pgpool + VIP trickery, and is a lot of setup for a small project. Hosted from AWS or similar is a lot better as they do the crazy setup, but not for local setup. Nice Digital Ocean finally got floating IPs this week which should help there (have not looked into if it will work for PG failover).