The PGCon 2013 Call for papers is out. It’s been out for over two weeks. Had you heard about it already? If you have not already submitted, please do so. The deadline for submissions (19 Jan) is just over a month away. That time will fly past. Please don’t leave it to the last minute. If you are doing something interesting with PostgreSQL, please submit a proposal. You might be one of the […]
PGCon 2013 call for papers 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 = ‘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 in order to force the recycling of older expired (but still on disk) Volumes. NOTE: actually, I did
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 is very useful, both in a negative and a positive fashion. The error upon login was: You are
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 IN SELECT conference_phase_conflict.conflict FROM conflict.conference_phase_conflict INNER JOIN conference ON ( conference.conference_id = conference_id AND conference.conference_phase = conference_phase_conflict.conference_phase )
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 a few requests for a group trip to Burger Works, Haveli, and Royal Thai for dinner. We’ll definitely
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 turn up. Two weeks from today, the final day of PGCon 2011 will start. While it becomes cliche
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 of tutorials on 17-18 May 2011. PGCon is the place to meet, discuss, build relationships, learn valuable insights,
PGCon 2011 is just two weeks away Read More »