psoos.blogspot.com
Bernd's Blog: Januar 2010
http://psoos.blogspot.com/2010_01_01_archive.html
Keine Posts. Alle Posts anzeigen. Keine Posts. Alle Posts anzeigen. I'm working as a database consultant and developer at credativ GmbH, Mönchengladbach, Germany. Mein Profil vollständig anzeigen. Von pelmazo klug geschissen. Setting a Session Parameter Overrides OFE. Magnus Hagander's PostgreSQL blog. Locating the recovery point just before a dropped table. PostgreSQL 9.6 Feature: pg stat activity - wait event. PgAdmin 4 - The elephant nears the finish line. Where lies the truth?
psoos.blogspot.com
Bernd's Blog: Februar 2011
http://psoos.blogspot.com/2011_02_01_archive.html
Donnerstag, 3. Februar 2011. FOSDEM, the same procedure as every year. So FOSDEM starts this weekend again.and again i will attend, especially on sunday. Meet the PostgreSQL guys, hear the talks in the PostgreSQL devroom. And maybe get some other interesting news from the community. I'm working as a database consultant and developer at credativ GmbH, Mönchengladbach, Germany. Mein Profil vollständig anzeigen. Von pelmazo klug geschissen. Setting a Session Parameter Overrides OFE. Where lies the truth?
psoos.blogspot.com
Bernd's Blog: Februar 2010
http://psoos.blogspot.com/2010_02_01_archive.html
Samstag, 20. Februar 2010. Is coming up soon. CeBIT. March 2th to March 6th) is one of the biggest shows for IT and PostgreSQL will have a booth in the Open Source Project Lounge, organized by Andreas Scherbaum. I will staff the booth with Andreas on friday, 2010-03-05. If you are interested, feel free to meet us in hall 2, maybe we see us on friday! I'm working as a database consultant and developer at credativ GmbH, Mönchengladbach, Germany. Mein Profil vollständig anzeigen. Von pelmazo klug geschissen.
psoos.blogspot.com
Bernd's Blog: Building Slony-I on OSX
http://psoos.blogspot.com/2010/11/building-slony-i-on-osx.html
Freitag, 5. November 2010. Building Slony-I on OSX. Just stumpled across this today while trying to build a fresh git clone of Slony-I on my MacBook; To build Slony-I on a OSX box (in my case 10.6.4), you might do the following on your box:. Configure - prefix=$PGSQL HOME - with-pgconfigdir=$PGSQL HOME/bin. Configure: error: Headers for libpqserver are not found in the includeserverdir. This is the path to postgres.h. Please specify the includeserverdir with. Ah okay, it is indeed failing compiling the c...
psoos.blogspot.com
Bernd's Blog: Dezember 2008
http://psoos.blogspot.com/2008_12_01_archive.html
Donnerstag, 11. Dezember 2008. How to get a table's OID. I often get questions from customers trying to work with OIDs of relations they need to add somewhere (three times just this week). For example, someone wants to add a special autovacuum configuration for a specific table. He then needs to find out the OID of the relation. People often tend to use the following query then:. SELECT oid FROM pg class WHERE relname = 'foo' AND relkind = 'r';. SELECT 'foo': regclass: oid;. INSERT INTO pg autovacuum.
psoos.blogspot.com
Bernd's Blog: 10 years of computer science in Aalen
http://psoos.blogspot.com/2010/11/10-years-of-computer-science-in-aalen.html
Samstag, 13. November 2010. 10 years of computer science in Aalen. On Saturday i was invited to my old university where i formerly studied computer science. I was asked to give a lightning talk about my work and experiences after my studies. I did my diploma thesis back in 2006 about PostgreSQL and still have the opportunity to work with and on PostgreSQL during my employment at credativ. In my talk i've summarized what it means to work with open source and my fields of activity. Where lies the truth?
psoos.blogspot.com
Bernd's Blog: Dezember 2009
http://psoos.blogspot.com/2009_12_01_archive.html
Mittwoch, 2. Dezember 2009. PostgreSQL and its increasing popularity. So i had just another PostgreSQL course at the LinuxHotel in Essen. As always, i enjoyed working there with people interested in learning PostgreSQL within a very nice atmosphere. The reason i'm blogging about this, is that i'm really impressed how PostgreSQL has gained momentum over the last three years. I'm working as a database consultant and developer at credativ GmbH, Mönchengladbach, Germany. Mein Profil vollständig anzeigen.
psoos.blogspot.com
Bernd's Blog: September 2009
http://psoos.blogspot.com/2009_09_01_archive.html
Dienstag, 22. September 2009. The new stable branch 2.0 of Slony-I. Is out for a while now. Time to blog about one of my favorite new features there, cloning an existing node without doing an initial SUBSCRIBE. Normally administrators have to perform a subscription for each new node they want to add to their Slony-I cluster. This initial subscription procedure uses PostgreSQL's COPY. In PostgreSQL 8.4 there exists a new pg restore method, parallel restore (see the pg restore -j. We assume master.db a...
psoos.blogspot.com
Bernd's Blog: April 2011
http://psoos.blogspot.com/2011_04_01_archive.html
Donnerstag, 21. April 2011. Yes, there is one (at least). Yesterday it occured to me again, that i was asked for german literature about PostgreSQL 9.0 and the lack thereof. Okay, there is one.look for ISBN-13 978-3897216617 ;). PostgreSQL Administration 2nd Edition is available since the very early days of 2011 and covers various topics about PostgreSQL 9.0 Administration, in addition to the first edition which covers up to 8.3 only. Seems people got confused about this. Mein Profil vollständig anzeigen.
psoos.blogspot.com
Bernd's Blog: Januar 2011
http://psoos.blogspot.com/2011_01_01_archive.html
Freitag, 21. Januar 2011. PostgreSQL vs. libreadline on OSX. Today Thom Brown posted a bug report. To pgsql-bugs, where he asked for a potential issue with the interactive terminal psql. As the following reply from Tom Lane explained, this is a long standing issue with the libedit package Apple ships with OSX. Yes, libedit, since libreadline under OSX is just a symlink to libedit:. Ls -la /usr/lib/libreadline.dylib. There were several discussions. I always recommend to use MacPorts. Is the default locati...
