As said before: you need two elephants for replication.
As said before: you need two elephants for replication.
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.
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.
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).
The PostgreSQL User Group Germany is giving a talk and a workshop at the Open Source Day 2008 October 11 in Magdeburg/Germany.
I want to drop a ROLE (previously USER/GROUPs) which is still referenced by object(s) in my database. But PostgreSQL has objections:
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.
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 ;-)
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.
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.