Open Source

Speakers and travel

The following query pulls back the speakers and their travel: SELECT distinct S.name, S.email, CP.conference_person_id, arrival_from, arrival_to, arrival_number, arrival_date, arrival_time, departure_from, departure_to, departure_number, departure_date, departure_time FROM event E, view_event_person P, view_mail_all_speaker S, conference_person CP, conference_person_travel CPT WHERE E.event_id = P.event_id AND P.person_id = S.person_id AND E.conference_id = 7 AND CP.conference_id = E.conference_id AND E.event_state = ‘accepted’ AND E.event_state_progress NOT IN (‘rejected’, ‘canceled’) AND P.event_role_name = ‘Speaker’ AND S.person_id = CP.person_id AND CPT.conference_person_id = […]

Speakers and travel Read More »

PGCon – keynote… made your travel bookings yet?

Although PGCon 2011 is just 9 weeks away, that time will fly past. People will start gathering in Ottawa early in the week for the two days of tutorials followed by two days of talks. PGCon is also a social event, so there will be many opportunities to mingle and meet other members of your PostgreSQL community. We’ve already started booking the travel and accommodation for some of our speakers. From its initial

PGCon – keynote… made your travel bookings yet? Read More »

PGCon 2011 – registration now open

Registration for PGCon 2011 has opened. The list of talks is impressive. You’ll find something there for everyone. Again this year, as every year, we bring together developers and users from all over the world to meet and to learn from each other. PGCon has a consistent history of providing high quality for low cost. You’ll be sure to come away with amazing ideas for your projects. You will meet people you don’t

PGCon 2011 – registration now open Read More »

PGCon 2011 – schedule released

The list of talks and speakers for PGCon 2011 has been released. For 2011, we once again have a strong collection of talks that will appeal to a wide range of attendees. Registration will open later this week. Be sure to start making your travel plans. Of particular note is the excitement within the GIS community regarding the Using PostgreSQL for Flight Planning talk by Blake Crosby. We also have a Facebook and

PGCon 2011 – schedule released Read More »

Pentabarf – exporting the schedule

When exporting a Pentabarf schedule, your talks must be accepted and reconfirmed in order to appear on in the schedule. Not just accepted. In this article, we assume your conference id = 7. Adjust to suit your situation. This query gives you a list of the accepted talks: SELECT event_id FROM event WHERE conference_id = 7 AND event_state = ‘accepted’; This query refines the data so you get the accepted talks which will

Pentabarf – exporting the schedule Read More »

PGCon 2011 – schedule delayed

On Saturday, I tweeted that the schedule for PGCon 2011 would be released. I was wrong. We are having a hard time choosing from amongst all the talks we have received. Choice is a fine problem to have, but we apologize for the delay. All submitters have been emailed about this delay. The Call For Papers timetable has this past Saturday as the deadline for us to notify the submitters. We apoligized to

PGCon 2011 – schedule delayed Read More »

Copying to tape, missed something….

I recently wrote about copying jobs with a very good backup tool. My goal was to keep copies of the backups on both disk and tape. Since then, I started playing around with a little webpage to keep tabs on what’s in my tape libary. Today I noticed a little problem. I have backups from 75 days ago that are waiting to be copied to tape.

I’ll just let you think about why this happened. Yesterday, this queue held jobs that were about 16 hours old. How did this old job get into the queue?

Copying to tape, missed something…. Read More »

Carved in stone

This was said by me on IRC today: You say ‘ignoring a large user base’ as if there is something wrong with that. PostgreSQL has a long history of not catering to the masses. This is what makes it such a great tool. Only well thought out and well conceived features go into PostgreSQL. And someone else said: those 3 statements should be carved to stone :) Done. Later, I added: Features get

Carved in stone Read More »

Oh damn! I should have used screen!

I’m sure you’ve had one of these moments: ssh to a server start a long running command wanted to disconnect and go home Oh Damn! I should have used screen! I have long wanted such a tool Now there appears to be a solution. reptyr seems to fit the bill. That URL also describes a few other tools: screenify retty I’m hoping someone will port this to FreeBSD soon.

Oh damn! I should have used screen! Read More »

Scroll to Top