On 30/10/17 13:55, Josh Knapp wrote: > I'm not the biggest fan of PGSQL from the administration side. This > probably stems from that I have not had a ton of experience messing with it > except in very specific use cases. > > What tools are available if a table gets corrupted or messed up from an > improper shutdown? Is it a case of purely restoring from backup?
I don't have a lot of experience as a site admin (I was designing a Pg system at work at one time to do Identity Management & Provisioning but it never came to anything and the place is now an Oracle shop). Yes, recovery from a backup is an option. It's what I'd do if I lost one of the Pg databases I use for personal projects, but there's much more I believe. For example, I just take a SQL dump of schema and table contents, but there are more sophisticated backups available including tablespaces, WAL logs, etc. https://wiki.postgresql.org/wiki/Corruption My main motivation in using PostgreSQL to prototype a new database design is that it's a much more fully featured database engine compared to MySQL/MariaDB. This may be a personal prejudice because MySQL didn't even have foreign keys when I was first learning to use PostgreSQL, but MySQL still does not implement a lot of the standard SQL features compared to Pg. Dave -- Dave Morriss, Edinburgh, Scotland, UK | [email protected] _______________________________________________ Hpr mailing list [email protected] http://hackerpublicradio.org/mailman/listinfo/hpr_hackerpublicradio.org
