Open Source

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall

Leave a Comment / Backups, FreeBSD, Open Source, PostgreSQL / By /

See also mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. I’m linking this because I use both articles on a regular basis. Sometimes you want a user which can only dump the database, but nothing else. Fortunately, I searched, and found a solution. I’m writing it down so I only have to search this blog. I want the user rsyncer […]

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall Read More »

Trying iocage to get an old version of FreeBSD

Leave a Comment / FreeBSD, iocage, Jails / By /

Sometimes you just need that old version. So I installed it. FreeBSD 9.3 Sorry, but this article is light. I stopped taking notes after a bit…. We created a VM via VMware, put FreeBSD 11.1 on it, over ZFS. Then install iocage. This is what it looked like: What did it just install? This: $ zfs list -r zroot/iocage NAME USED AVAIL REFER MOUNTPOINT zroot/iocage 825M 30.2G 25K /iocage zroot/iocage/download 180M 30.2G 23K

Trying iocage to get an old version of FreeBSD Read More »

Adding IPv6 to an Nginx website on FreeBSD / FreshPorts

Leave a Comment / DNS, FreeBSD, iocage, nginx, nsupdate, pf, poudriere / By /

FreshPorts recently moved to an IPv6-capable server but until today, that capability has not been utilized. There were a number of things I had to configure, but this will not necessarily be an exhaustive list for you to follow. Some steps might be missing, and it might not apply to your situation. All of this took about 3 hours. We are using: FreeBSD 11.1 Bind 9.9.11 nginx 1.12.2 The server configuration This is

Adding IPv6 to an Nginx website on FreeBSD / FreshPorts Read More »

Moving bacula-sd into a FreeBSD jail

Leave a Comment / Backups, Bacula, FreeBSD, Open Source, py-iocage / By /

In this post: Bacula 7.4 FreeBSD 11.1 py-iocage 0.9.9.2 I recently wrote about Converting a Dell R710 into a ZFS-based FreeBSD 11.1 tape library bacula-sd and then about getting the drives ready. That system, henceforth referred to as the r710 is now ready for the Bacula setup. Last night I created a jail and installed the software I’ll need. Most of this was done via Ansible. I also configured Bacula both on the

Moving bacula-sd into a FreeBSD jail Read More »

R710 – getting the drives ready

Leave a Comment / Disks, File Systems, FreeBSD, Open Source, smartctl, ZFS / By /

I recently installed 6 SSDs into an R710. In this post, I will describe what I did to the empty SSDs before I started using them. short test I ran a short test on each one of the drives. I already had smartctl. $ sudo smartctl -t short /dev/da0 smartctl 6.6 2017-11-05 r4594 [FreeBSD 11.1-RELEASE-p1 amd64] (local build) Copyright (C) 2002-17, Bruce Allen, Christian Franke, www.smartmontools.org === START OF OFFLINE IMMEDIATE AND SELF-TEST

R710 – getting the drives ready Read More »

Converting a Dell R710 into a ZFS-based FreeBSD 11.1 tape library bacula-sd

Leave a Comment / Disks, FreeBSD, hardware, Open Source / By /

If you’ve read even a little of what I’ve written, the following points will not come as a surprise: I like FreeBSD I’m a fan of backups I use Bacula I like ZFS I have tape libraries In this post, I will cover all of the above and more. Photos will be included. New gear Full disclosure: the following links contain my Amazon referrer code. On the left is the ICY DOCK 2.5″

Converting a Dell R710 into a ZFS-based FreeBSD 11.1 tape library bacula-sd Read More »

x8dtu

Leave a Comment / hardware, ZFS / By /

NOTE: this post has been replaced by a newer version. The older post is still available This is x8dtu (named after the SuperMicro motherboard). This is the new FreshPorts server. In short: FreeBSD 11 booting off a mirrored pair of zfsroot SSDs 4.5TB of mirrored ZFS 196612 MB of RAM (yeah, that’s 196GB of RAM) SuperMicro X8TDU motherboard Intel Xeon E5620 @ 2.40GHz (two of those, giving 16 CPUs) NOTE: this post replaces

x8dtu Read More »

Moving FreshPorts

Leave a Comment / DNS, FreeBSD, FreshPorts, PostgreSQL / By /

Today I moved the FreshPorts website from one server to another. My goal is for nobody to notice. In preparation for this move, I have: DNS TTL reduced to 60s Posted to Twitter Updated the status page Put the website put in offline mode: Sorry, the website is offline from 2017-11-05 17:01, for approximately 3 hours. It is now 2017-11-05 17:01. That works for both http and https: [dan@air01:~] $ wget -S http://www.freshports.org

Moving FreshPorts Read More »

Dumping PostgreSQL 9.4 to upgrade to PostgreSQL 9.6

Leave a Comment / ezjail, FreshPorts, Jails, PostgreSQL / By /

FreeBSD 10.3 & PostgreSQL 9.4 on the old server, and FreeBSD 11.1 & PostgreSQL 9.6 on the new server. As part of the move from the old FreshPorts server (photos) to the new FreshPorts server, I’ll need to dump the database and copy it over. What? No zfs send? There is no ZFS on the old server. The rule of thumb when upgrading a PostgreSQL database is to dump with the pg_dump client

Dumping PostgreSQL 9.4 to upgrade to PostgreSQL 9.6 Read More »

Scroll to Top