Yesterday, I mentioned I wanted to compare raidz2 when using 10 disks versus using 8 disks. Along the way, I noticed that my ZFS-setup script needed a change to cope with mixed devices. Once I got past that hurdle, I started adding packages and setting up the system for some very simple tests. The test […]
raidz2: 10 disks vs 8 disks Read More »
The traditional thoughts on ZFS are to have arrays which are a power-of-2 when it comes to number of disks. That means 2, 4, 8, etc. But for raidz1, that would be 3, 5, 9. For my choice of raidz2, it would be 4, 6, and 10. In the system I’m building up now, I
ZFS: raidz2 with 8 or 10 disks? Read More »
I’ve been a fan of PostgreSQL since 2000 when I switched to it from MySQL. I wanted stored procedures and functions. I got that with PostgreSQL. I was used to having such features from my years working with other big databases such as DB2, Oracle, and Sybase. I’ve been moving towards using the custom format
pg_restore: [custom archiver] could not read from input file: end of file Read More »
I attended a few of the talks at PGCon 2013 last month. One talk, for which I took several notes and made a few choice tweets. The main one I’m following up on is using the -Fc option on pg_dump. It was during Magnus Haganders’ talk on PostgreSQL Backup Strategies that I posted that tweet.
Using compression with PostgreSQL’s pg_dump Read More »
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
Restricting IP addresses to specific databases Read More »
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
The Bacula Tutorial jail server Read More »
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
Deleting old Bacula Volumes Read More »
Sometimes, you need to restore. But you don’t know when the file changed. Here’s a simple SQL query which shows me that information: And here is the output Based on that output, I want to look at restoring from Jan 13 and before. That’s when the filesize change last changed from 172KB.
Bacula: When did that file change size? Read More »
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.
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’