planet.postgresql.org planet.postgresql.org

Luca Ferrari: Single User Mode and -P flag

How to allow corrupted catalogs repair. Single User Mode and -P flag It could happen that you can no more connect to the database because an error on a catalog happens. PostgreSQL is rock-solid, so this usually does not happen, but in the case of disk corruption (or sometimes because of poor human behavior), the system could be not able to connect to the database because the system catalogs for that database are bad. When the...