Here is the start of a query for pulling out travel requirements for conference attendees. SELECT P.last_name, P.first_name, CPT.arrival_from, CPT.arrival_to, CPT.need_accommodation FROM conference_person_travel CPT, conference_person CP, conference C, person P WHERE CPT.need_accommodation AND CPT.conference_person_id = CP.conference_person_id AND P.person_id = CP.person_id AND CP.conference_id = C.conference_id AND C.acronym = ‘BSDCan2015’
I have been using Bacula since early 2004. That’s nearly 9 years of great backups. Back in early 2010, I set up a multi-terabyte system in my basement with commodity hardware. Today, after about 18 months of backups, it’s starting to fill up. Now is the time to start restricting the creation of new Volumes
Bacula volumes – running low on disk space Read More »
I encountered this situation recently. I had consolidated two logins. One was for 2012, the other for 2011. It’s better to reuse your login from previous years instead of creating a new one each year. Why? It lets the program committee see what you’ve submitted in previous years. They can see your previous acceptances/rejections. That
Pentabarf authentication issues Read More »
The list of talks and speakers for PGCon 2012 has been released. For 2012, we once again have a strong collection of talks that will appeal to a wide range of attendees.
PGCon 2012 schedule released Read More »
Here is the start of a query for pulling out travel requirements for conference attendees. SELECT P.last_name, P.first_name, CPT.arrival_from, CPT.arrival_to, CPT.need_accommodation FROM conference_person_travel CPT, conference_person CP, conference C, person P WHERE CPT.need_accommodation AND CPT.conference_person_id = CP.conference_person_id AND P.person_id = CP.person_id AND CP.conference_id = C.conference_id AND C.acronym = ‘BSDCan2012’
After a very long effort, this is the solution: CREATE OR REPLACE FUNCTION conflict.conflict_statistics(conference_id integer, OUT conflict_level text, OUT conflicts integer) RETURNS SETOF record LANGUAGE plpgsql AS $function$ #variable_conflict use_variable DECLARE conflict TEXT; conflict_rows INTEGER; BEGIN FOR conflict_level IN SELECT conflict_level.conflict_level FROM conflict.conflict_level WHERE conflict_level.conflict_level ‘silent’ ORDER BY rank LOOP conflicts = 0; FOR conflict
PGCon 2011 has started. The formal schedule says Tuesday, but people have already started to arrive in Ottawa and many more start their journeys today. Late last week, there was another flurry of registrations coming in. I saw some today. I expect another peak on Monday as last minute decisions are made. There have been
I’ve been in Ottawa for a week now, preparing for both BSDCan 2011 and for PGCon 2011. Pretty much everything is done. The t-shirts are ordered. The lanyards, tote bags, and Google goodies are ready to go. The hard stuff is done. What’s left is mostly logistics, coordination, timing, and organization. And for you to
PGCon – we’re ready. Are you? Read More »
PGCon is just two weeks away. Based on previous years, half of you register between today and the conference. I don’t know why… it just happens that way. Yes, it means our attendance will double in the next two weeks. PGCon 2011 will be on 19-20 May 2011 at University of Ottawa, with two days
PGCon 2011 is just two weeks away Read More »
PGCon is an annual conference for users and developers of PostgreSQL, a leading relational database, which just happens to be open source. PGCon is the place to meet, discuss, build relationships, learn valuable insights, and generally chat about the work you are doing with PostgreSQL. If you want to learn why so many people are