PostgreSQL

How much are those volumes in the library?

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

I pretty much ignore my tape library. It asks for tapes when it runs out. However, I think I should be looking ahead and anticipating requests. Thus, I came up with this SQL query: [dan@ngaio:~] $ psql bacula psql (8.4.5) Type “help” for help. bacula=# SELECT mediaid, volumename, volstatus, slot, inchanger, pool.name, volbytes FROM media, pool WHERE media.poolid = pool.poolid AND volumename LIKE ‘ETU0%’ AND inchanger != 0 ORDER BY slot; mediaid | […]

How much are those volumes in the library? Read More »

Sending out a URL for password reset

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

Quite some time ago, FreshPorts and The FreeBSD Diary both moved from clear text passwords to password hashes. As such, you are no longer able to recover your password. You had to email me. This is extra work for everyone. Let us automate this. The first, step, is a table: create table user_password_reset( user_id int not null, date_requested timestamp with time zone default (‘now’::text)::timestamp(6) with time zone, ip_address inet not null, token text

Sending out a URL for password reset Read More »

A simple nested loop

Leave a Comment / FreshPorts, PostgreSQL / By / /

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: $ cvs di -ub commits_by_committer.php Index: commits_by_committer.php =================================================================== RCS file: /home/repositories/freshports-1/classes/commits_by_committer.php,v retrieving revision 1.3 diff -u -b -r1.3

A simple nested loop Read More »

HAST – High Availability Storage

2 Comments / FreeBSD, Open Source, PostgreSQL / By / /

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 can be active at any given time. Active node will be called Primary node. This is the node

HAST – High Availability Storage Read More »

Graphing

5 Comments / Open Source, PostgreSQL / By / / ,

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 help. dan=# \d dlt_stats Table “public.dlt_stats” Column | Type | Modifiers ————-+—————————–+——————————————————– id | integer | not null

Graphing Read More »

Pentabarf – seeing the speakers

Leave a Comment / Bacula, BSDCan, Conferences, FreeBSD, FreshPorts, Mountain Bikes, Open Source, Pentabarf, PGCon, PostgreSQL / By /

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 role has been set to confirmed. I think Pentabarf design assumes that you have created a talk, and

Pentabarf – seeing the speakers Read More »

“libcroco-0.6.so.3” not found

Leave a Comment / Open Source, PostgreSQL / By /

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 errors: [root@pg73 /usr/ports/databases/postgresql73-server]# ldd `which msgfmt ` /usr/local/bin/msgfmt: libgettextsrc-0.17.so => /usr/local/lib/libgettextsrc-0.17.so (0x800655000) libgettextlib-0.17.so => /usr/local/lib/libgettextlib-0.17.so (0x80078f000) libcroco-0.6.so.3 =>

“libcroco-0.6.so.3” not found Read More »

Upgrading Pentabarf

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

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 this: git clone git://github.com/nevs/pentabarf.git Then I copied over my existing configuration files: rails/config/*.yml files Then I ran a

Upgrading Pentabarf Read More »