Not trying to dissuade you from using PG, just letting you know I might have a learning curve is there are issues.
On Oct 30, 2017 7:39 AM, "Dave Morriss" <[email protected]> wrote: > 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
