Category Archives: databases

Databases: PostgreSQL, MySQL and SQLite

PostgreSQL server: auto vaccum not running and log entry ‘could not bind socket for statistics collector’

I recently had quite a bit of trouble with a PostgreSQL 9.3 server under linux. Auto-vaccum was not running even though it was enabled in the config file. The log file under /var/lib/pgsql/data/pg_log/ had the following entry: 2014-12-02 15:27:36 CET … Continue reading

Posted in databases, IT and computers, linux, troubleshooting | Tagged , , , , , , | Leave a comment

SuSE 12.3 — PostgreSQL 9.2 error: Your database files were created by PostgreSQL version 9.1

I recently had to create some databases at a university SuSE Linux box, but the PostgreSQL installation was completely broken. At first, it looked good: minerva:/var/lib # systemctl start postgresql No errors as expected, but then: minerva:/var/lib # psql psql: … Continue reading

Posted in databases, general, troubleshooting | Tagged , , , , | Leave a comment

POstgreSQL 9 under Linux: Creating a user and a database for her

Here is how to create a PostgreSQL database user and a database for her under Linux. First install the PostgreSQL server from your distribution and start it, e.g., under SuSE as root: root@box> zypper in postgresql-server root@box> /etc/init.d/postgresql start Then … Continue reading

Posted in databases, linux | Tagged , , , , , , | Leave a comment

MySQL under Linux: Creating a user and a database for her

When you install software that uses a database (e.g., a forum on a web server), you usually have to install a database server and prepare a database for it. This article explains how to do this for MySQL under linux. … Continue reading

Posted in databases, linux | Tagged , , , , , | Leave a comment

Creating a Postgresql 9 database at another filesystem path

If you create a new PostgreSQL database but want it to be stored at a specific place in the filesystem (I’ll assume /srv/pgsql/data/ here), you can do this with the CREATE command. In earlier PostgreSQL versions, you could do it … Continue reading

Posted in databases, linux | Tagged , , , , | Leave a comment

Making a backup of the structure of a PostgreSQL database

I’m currently extending a web application that uses a PostgreSQL 8 database to store various data. In situations like these you’ll usually have a web server and a database server installed on your development machine so you can test the … Continue reading

Posted in coding, databases | Tagged , , , , , | Leave a comment