[GENERAL] Restoring database data after error at "multixact wraparound"

Hi, Recently two of our database servers crashed and won't start. The errors in postgres logs are: Server 1: 2017-07-16 11:36:12 UTC PANIC: could not access status of transaction 392483501 2017-07-16 11:36:12 UTC DETAIL: Could not read from file "pg_multixact/members/14077" at offset 90112

Re: [GENERAL] Failed DNF dependency in Fedora

It is fixed now. Thanks! Clodoaldo On Sun, Jul 16, 2017 at 8:39 AM, Devrim Gündüz wrote: > > Hi Clodoaldo, > > On Sat, 2017-07-15 at 08:38 -0300, Clodoaldo Neto wrote: > > While installing Psycopg2 for Python2 in Fedora 26 having Postgresql 9.6: > > > > # dnf install python-psycopg2 > > Last me

[GENERAL] Storing LOs outside the database and having a proper cleanup-mechanism to prevent dangling files

Hi.   After struggeling with storing LOs in the database and making efficient backups/restore-routines I've decided to move LOs out of the DB and use a "filename"-column containing an UUID referencing the file one the filesystem. Having this schema I need a robust book-keeping mechanism so I kno