Idle in transaction – DELETE waiting
We have a Linux server (Redhat Enterprise 6) running a multi-site installation of Mediawiki. In total, we have today 120 unique wiki’s, […]
Category: Postgresql
Authenticate Postgresql client agains backend ldap
We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication you can […]
Open Journal System missing email logs
I upgraded our Open Journal Systems from 2.2.2 to 2.4.2 and afterwards we saw the email logs were gone. This was related […]
Postgresql 9.1 BACKUP DUMP BASH script
We wrote an improved postgresql dump bash script for Postgresql version 9.1. This one will save each dump file with the name: […]
Postgresql 8.1 database bash dump script
I’ve wrote a simple bash script to dump databases from a Postgresql 8.1 database server which uses the pg_dump and pg_dumpall. #!/bin/bash […]