Tag Info

Hot answers tagged

3

EBS snapshots are atomic, they're a point-in-time. This means that for PostgreSQL, so long as all the datadir including WAL, and all tablespaces are in the same EBS volume, starting from a snapshot is equivalent to starting after an unclean shutdown (crash), which PostgreSQL is designed to do reliably every time. You do not need to stop I/O to the volume to ...


2

Your problem has nothing to do with missing databases. You real problem stems directly from the way you logged in to MySQL. First, look at your comment SHOW DATABASES; => information_schema, test. SELECT USER(); => root@localhost SELECT CURRENT_USER(); => @localhost SHOW GRANTS; => GRANT USAGE ON *.* TO ''@'localhost' Note the difference ...


2

Amazon's packages for PostgreSQL will upgrade from 9.1 to 9.2 as if that was a normal minor update. It isn't; see the PostgreSQL version policy, which makes it clear that the major version is "x.y", eg "9.1", "9.2", etc. This version policy may be weird and perhaps unwise, but it's also widely understood and something you would expect packagers to ...



Only top voted, non community-wiki answers of a minimum length are eligible