New answers tagged

1

No other clean up should be required. If you are really worried, you can watch your database size with: select pg_database_size('your_database'); To make sure it shrinks by about the amount you expected. It could take until the end of the next checkpoint to fully clean up. If you were dropping tens of thousands of small tables is where you have you to ...


1

Based on the replies you gave to my comments you must figure out how to resolve the duplicate keys issue. Also I do not think that master-slave replication is appropriate in this case. I would, after making sure that there are no duplicate keys, use pg_dump to transfer your data into AmazonRDS one by one. Perform checks after every database that you do. If ...


0

BLOB, TEXT, GEOMETRY, and JSON columns cannot be assigned a default value. http://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html What you are in essence asking -- without realizing it, presumably -- is how to force MySQL to revert to its old, incorrect behavior of ignoring your incorrect table definition and pretending that you really said ...



Top 50 recent answers are included