PostgreSQL

(tag)

  • CentOS 7 VM for WordPress and MythTV – Post install setup

    In the post CentOS 7 base VM for WordPress and MythTV I described how to create a base CentOS 7 VM. This post describes follows on from that post and describes the post installation tasks to make the VM a good solid base for me to run WordPress or MythTV. When setting up a Linux server… read more…

    CentOS 7 VM for WordPress and MythTV – Post install setup
  • Resetting a PostgreSQL root password

    Recently I upgraded to the latest Postgres version. I had a number of pain points doing this including not being able to start the DBs because the version upgrade was too big – had to export from old version and import to new. But one of the problems was that for some reason my password… read more…

    Resetting a PostgreSQL root password
  • Problems with single quotes, JSP and PostgreSQL

    I have a small web app that updates various PostgreSQL tables. I recently updated from Fedora 14 to Fedora 18 and as a result PostgreSQL was updated and I expect JDK as well. All of a sudden I notice I couldn’t update rows which contained strings when the strings had single quotes in them. I… read more…

    Problems with single quotes, JSP and PostgreSQL