ads' corner

Replication - you need two elephants for this

As said before: you need two elephants for replication.


xPyrus community framework released by UniHelp e.V.

UniHelp e.V. - a registered student association in Magdeburg/Germany - announces the release of xPyrus, a framework for operating communities and document sharing platforms.

The framework is based on PHP 5 and PostgreSQL and has been running the students’ community UniHelp.de (a platform for exchanging study-related documents and connecting students) in Magdeburg since 2002.

The entire framework is released under the GNU Affero General Public License v3 at xpyrus.org. A Unix-based server is required for installation and use of all features, however, a hosting service can be provided by UniHelp e.V. on request, especially for student organizations.


Single line input for psql copy command

I have the following problem:

A database server and another client machine. I have to execute several \copy commands in psql on the client machine to retrieve data and store the output in CSV files. The PostgreSQL COPY command is not an option because it stores the results on the database server, not the client machine. All \copy commands are executed from several files containing SQL commands, which are concated together by a Makefile and feeded into psql. So far so good.


Keysigning party at European PGDay 2008 in Prato

There will be a keysigning party at PGDay.(it|eu) in Prato/Italy. The event is the last track on Friday in the evening, probably around 16:50-17:30 (that’s 4:50-5:30 pm).


Open Source Day in Magdeburg/Germany

The PostgreSQL User Group Germany is giving a talk and a workshop at the Open Source Day 2008 October 11 in Magdeburg/Germany.


role ... cannot be dropped because some objects depend on it

I want to drop a ROLE (previously USER/GROUPs) which is still referenced by object(s) in my database. But PostgreSQL has objections:


Magdeburger Open-Source-Tag im Oktober 2008

Am 11. Oktober 2008 findet an der Universität Magdeburg der Magdeburger Open-Source-Tag statt. Bis zum 7. September können noch interessante Vorträge eingereicht werden.


PostgreSQL Schulung

Die Open Source School hat neben einigen anderen Lehrgängen auch eine Schulung für PostgreSQL im Programm. Dieses Posting hier nicht nicht ganz uneigennützig, wenn man sich anschaut, wer diese Schulung halten wird ;-)


create language if not exist

In a customer project I have to setup a database from a Makefile. Part of my problem: on Windows the installer may or may not install plpgsql into template1, therefore in consequence this language may or may not be activated in every new database. But that’s not predictable. This problem can appear on different Linux/Unix distributions too.


You need two elephants for replication

FOSDEM 2008 in Brussels is a smashing success. As you remember we have a shared devroom together with the BSD projects. So far it seems we are one of the few devrooms who have a full schedule for both days - some other projects (who particulary got a bigger devroom) only had talks for one day or worse.