Development

FreshPorts processes the cvs commit logs from the FreeBSD cvs-all mailing list. It parses these emails into XML. FreeBSD is in the process of moving to svn. This email will demonstrate of the differences between the two email formats and highlight any issues that might surround the move to processing svn instead of cvs logs. […]

One issue which has interested me for a while is moving databases from one server to another. My traditional approach involves taking down the website, dumping the database, copying the dump file, loading it up, and then changing the DNS to point to the new server. With the goal of minimizing downtime, I’ve been considering

I ran into an interesting problem while upgrading the production FreshPorts server. Specifically, this error: select PortsUpdatingAdd(E’20080708′::date, E’users of emulators/qemu-devel’, E’nox@FreeBSD.org’, EE’ The port has been updated to a 20080620 SVN snapshot, which uses the new (incompatible) kqemu-kmod-devel port that now also works for the 32 bit “qemu” executable on amd64. If you upgrade qemu-devel

This post started off as a database move but a software upgrade got in the way. I tried this move before, but failed to notice that the cvs-all subscription was not correct. This was a combination of DNS and subscription issues. They are now fixed. Let us try moving the database now. $ time pg_dump

It’s time. FreshPorts has been running on the BETA server for quite some time. It is time to move back to production. This will involve a pg_dump, an rsync, another pg_dump, another rsync, a load, a change to DNS, and a redirect in Apache. We’ll see how it goes. The time is now 8:19 PM

The fix: $ cvs di -ub port.pm Index: port.pm =================================================================== RCS file: /home/repositories/freshports-1/scripts/port.pm,v retrieving revision 1.52 diff -u -b -r1.52 port.pm — port.pm 6 Jun 2008 18:13:41 -0000 1.52 +++ port.pm 10 Aug 2008 21:09:51 -0000 @@ -160,6 +160,7 @@ # we are updating # NOTE: NULLIfEmpty invokes db_escape + # these items were escaped

The FreshPorts website has moved. It was at 216.168.29.4 and is now at 64.147.113.42, on the other side of the country. If your DNS is lagged, you will be redirected from http://www.freshports.org/ to http://beta.freshports.org/. Once your DNS catches up, you won’t be directed. This wonderful solution is accomplished with this directive on the old website:

A very key point in this article. Product vs project. Read: http://people.planetpostgresql.org/greg/index.php?/archives/120-Postgres-is-not-for-sale.html

Want $200? Free admission to BSDCan? And tutorials? Read this: http://blog.kozubik.com/john_kozubik/2007/12/bounty-posted-f.html

I’ve found work. Details here.