In a previous post, I wrote about a suspected LIMIT problem. It turns out that suspicion proved correct. The solution was to move to a nested query which limits the underlying data and then allows the outer query to grab all the associated fluff that surrounds it. Here is the fix to the original code: […]
A simple nested loop Read More »
The PGCon 2010 schedule has been announced. Have a read of our outstanding lineup, see where people come from to PGCon, and get your registration started.
PGCon 2010 – schedule Read More »
HAST has just been added to FreeBSD: HAST allows to transparently store data on two physically separated machines connected over the TCP/IP network. Those two machines together will be called a cluster and each machine is one cluster node. HAST works in Primary-Secondary (Master-Backup, Master-Slave) configuration, which means that only one of the cluster nodes
HAST – High Availability Storage Read More »
The liveusb-creator is a cross-platform tool for easily installing live operating systems on to USB flash drives. It runs on various operating systems and allows you to create a bootable device from an ISO image. This could be useful for advocacy purposes.
Got ISO? Create USB boot image Read More »
I have about 14,000 data points collected from backups. I started in Oct 2007, but have not done anything with the data. I’d like your help. I have put the data into a PostgreSQL database and dumped it. The dump is here: http://langille.org/tmp/dlt_stats.sql.gz The table looks like: $ psql dan psql (8.4.2) Type “help” for
Both BSDCan and PGCon use Pentabarf for accepting and reviewing proposals for talks. An issue raised in 2009 highlighted the ability to see the speaker name when review the list of submissions. It is a bit of very useful information. This year, I’ve found out that we can see that vital data. Provided the speaker
Pentabarf – seeing the speakers Read More »
Seen this? /libexec/ld-elf.so.1: Shared object “libcroco-0.6.so.3″ not found, required by ” msgfmt” Rebuild gettext. portupgrade -f gettext And try again Port details, not relevant: # less /var/db/ports/postgresql73/options # This file is auto-generated by ‘make config’. # No user-servicable parts inside! # Options for postgresql-server-7.3.21_1 _OPTIONS_READ=postgresql-server-7.3.21_1 WITH_NLS=true WITHOUT_PAM=true WITHOUT_MIT_KRB5=true WITHOUT_HEIMDAL_KRB5=true WITHOUT_OPTIMIZED_CFLAGS=true WITHOUT_LIBC_R=true WITHOUT_TESTS=true WITHOUT_DEBUG=true The building
“libcroco-0.6.so.3” not found Read More »
Pentabarf is the conference tool used by BSDCan and PGCON. I upgraded it recently and ran into trouble. I think that has been resolved now. Since I last upgraded Pentabarf, it went from using svn to using git. Thus, you need a clean checkout of Pentabarf. I copied away the original source before I did
Upgrading Pentabarf Read More »
I use Bacula. To be clear, I wrote part of Bacula (the PostgreSQL part). Today I need to find out what jobs are on each of three tapes. Why? I just happened to cancel a 1.5TB job a few hours before it was to finish. By this time it had written to three tapes. I
What jobs are on these tapes? Read More »
I was looking at RackMonkey and RackTables today. As part of the latter, I was installing PostgreSQL on my FreeBSD workstation. I failed. This had worked many times before, on many other servers. This was the first time I’d seen this particular situation. # /usr/local/etc/rc.d/postgresql initdb The files belonging to this database system will be
LANG prevents PostgreSQL initdb Read More »