PostgreSQL

Restricting IP addresses to specific databases

1 Comment / Open Source, PostgreSQL / By / /

Sometimes, you don’t want just anyone talking to your database. In fact, sometimes, you don’t want anyone accessing your database except very specific applications. In this case, I am setting up about 20 databases, each one dedicated to a specific use, and to be accessed only from one IP address each. In this post, I’ll talk about how I first set this up with pg_hba.conf, and then how I altered it to be […]

Restricting IP addresses to specific databases Read More »

The Bacula Tutorial jail server

Leave a Comment / Backups, Bacula, BSDCan, Conventions, DHCP, Disks, File Systems, FreeBSD, Jails, NAT, Operating Systems, pf, PostgreSQL, ssh, ZFS / By /

One of the challenges of providing hands-on demonstrations is giving everyone their own sandbox to play in. I don’t want people to spend time on installing software. I want people to learn about the software in question, specifically Bacula. With this in mind, I’ve been building up a solution based on FreeBSD 9.1, ZFS, and jails. My solution is pretty nifty, but I don’t think it’s anything special. The key is simplicity. The

The Bacula Tutorial jail server Read More »

Deleting old Bacula Volumes

6 Comments / Backups, Bacula, FreeBSD, Open Source, PostgreSQL, ZFS / By /

From time to time, my Bacula – space and time website shows some old jobs that need to be copied to tape. Stuff from 100 days or more. There’s no reason to copy stuff that old to tape. It’s already been copied to tape. So why does it appear? Last night I swapped some tapes in the tape library. This morning they would have been used and recycled. I’ll bet that those tapes

Deleting old Bacula Volumes Read More »

PGCon 2013 call for papers

Leave a Comment / Open Source, PGCon, PostgreSQL / By / /

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 »

Pentabarf travel

Leave a Comment / Open Source, Pentabarf, PostgreSQL / By /

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’

Pentabarf travel Read More »

Bacula volumes – running low on disk space

1 Comment / Bacula, Open Source, PostgreSQL / By /

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 »

Pentabarf authentication issues

Leave a Comment / Open Source, Pentabarf, PostgreSQL / By /

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 »

Pentabarf travel

Leave a Comment / Pentabarf, PostgreSQL / By /

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’

Pentabarf travel Read More »

Scroll to Top