New answers tagged

1

What is the full version of PostgreSQL on both master and replica? That looks like it probably was corruption, and taking a new base backup is all you could do (and investigate your hardware, to see if you can figure out why there was corruption). I assume you removed WAL from the replica, not from the master. So it would re-fetch the same WAL files, and ...


0

I have been given a task to set up a development database where all users able to access a given project schema (each project would have its own schema) would be able to do anything to any table, including to tables they do not own. That cannot work, as the documentation states: The right to modify or destroy an object is inherent in being the object's ...


Top 50 recent answers are included