Skip to content
Helge's blog

Helge's blog

  • Home
  • Unix commands

Category: Postgresql

Idle in transaction – DELETE waiting

31 August, 2015 Helge Apache, bash, Postgresql Leave a comment

We have a Linux server (Redhat Enterprise 6) running a multi-site installation of Mediawiki. In total, we have today 120

Continue reading

Authenticate Postgresql client agains backend ldap

16 February, 2015 Helge Ldap, Postgresql Leave a comment

We have a Postgresql server open to many different people at our organization. In order to add a ldap authentication

Continue reading

Open Journal System missing email logs

31 March, 2014 Helge bash, Postgresql Leave a comment

I upgraded our Open Journal Systems from 2.2.2 to 2.4.2 and afterwards we saw the email logs were gone. This

Continue reading

Postgresql 9.1 BACKUP DUMP BASH script

5 March, 2014 Helge bash, Database, Linux, Postgresql Leave a comment

We wrote an improved postgresql dump bash script for Postgresql version 9.1. This one will save each dump file with

Continue reading

Postgresql 8.1 database bash dump script

11 June, 2012 Helge Database, Linux, Postgresql 2 comments

I’ve wrote a simple bash script to dump databases from a Postgresql 8.1 database server which uses the pg_dump and

Continue reading

Recent Posts

  • Moving a Linux server PHP application with PHP 8.2 + OCI8 to a Docker-Based PHP 8.3 Setup
  • Stream Twitch in a WordPress post
  • WordPress can be used for online courses
  • Use openssl to encrypt secrets
  • Find the country of the IP from your logs

Recent Comments

  • AI Education Elphy on WordPress can be used for online courses
  • HSK 3.0 vocabulary on WordPress can be used for online courses
  • TikTok Story Viewer on Do you have too many emails? More than 100 000 or so? Can’t find old emails anymore?
  • MPP Viewer Online on Extract img url links from HTML document
  • MPP Viewer Online on Do you have too many emails? More than 100 000 or so? Can’t find old emails anymore?

Recent Comments

  • AI Education Elphy on WordPress can be used for online courses
  • HSK 3.0 vocabulary on WordPress can be used for online courses
  • TikTok Story Viewer on Do you have too many emails? More than 100 000 or so? Can’t find old emails anymore?
  • MPP Viewer Online on Extract img url links from HTML document
  • MPP Viewer Online on Do you have too many emails? More than 100 000 or so? Can’t find old emails anymore?

Categories

  • Apache
  • bash
  • Cygwin
  • Database
  • Docs
  • Editor
  • Education
  • Email
  • Firewall
  • Git
  • Imap
  • Landscapes
  • Ldap
  • Linux
  • Mail
  • Me "blogging"
  • Mediawiki
  • Moodle
  • Mysql
  • Online courses
  • Open source
  • Perl
  • PHP
  • Postgresql
  • Science
  • Security
  • Stream
  • Technology
  • UiB
  • Uncategorized
  • Version control
  • Video
  • Virtual server
  • Windows
  • Wordpress
  • Wordpress plugin
  • zsh
WordPress Theme: Tortuga by ThemeZee.