We have a Linux server (Redhat Enterprise 6) running a multi-site installation of Mediawiki. In total, we have today 120 unique wiki’s, each having its one Postgresql 9.1 database. Suddenly the server stopped responding. In Apache webserver, the total number concurrent apache processes went up to Apache’s max-client setting in httpd.conf, and people couldn’t log…
We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication you can add these 3 lines to your current pg_hba.conf file: host all username 127.0.0.1/32 ldap ldapserver=”ourserver.uib.no” ldapbasedn=”ou=people,dc=uib,dc=no” host all username 129.177.XXX.YYY/32 ldap ldapserver=”ourserver.uib.no” ldapbasedn=”ou=people,dc=uib,dc=no” local all username ldap ldapserver=”ourserver.uib.no” ldapbasedn=”ou=people,dc=uib,dc=no”…
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 to: http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=9140 My solution was this: Established a new Postgresql server in a virtual enviroment (vmware, test-machine), and import the old and the new (upgraded) database. # Log in to Prod server ssh…
We wrote an improved postgresql dump bash script for Postgresql version 9.1. This one will save each dump file with the name: database_name_DAYNAME.sql.bz2 In this way, we would only have 7 backups at any time, because each file will be overwritten after seven days. Since our backup system (TSM) saves 7 versions of each file,…
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 ## This scripts dumps all the databases in a Postgres 8.1 server, localhost ## 2 dump files are made for each database. One with Inserts another without. ## some variables, change them to…