PostgreSQL

Copying to tape, missed something….

2 Comments / Bacula / By / /

I recently wrote about copying jobs with a very good backup tool. My goal was to keep copies of the backups on both disk and tape. Since then, I started playing around with a little webpage to keep tabs on what’s in my tape libary. Today I noticed a little problem. I have backups from 75 days ago that are waiting to be copied to tape.

I’ll just let you think about why this happened. Yesterday, this queue held jobs that were about 16 hours old. How did this old job get into the queue?

Copying to tape, missed something…. Read More »

Carved in stone

Leave a Comment / PostgreSQL / By / /

This was said by me on IRC today: You say ‘ignoring a large user base’ as if there is something wrong with that. PostgreSQL has a long history of not catering to the masses. This is what makes it such a great tool. Only well thought out and well conceived features go into PostgreSQL. And someone else said: those 3 statements should be carved to stone :) Done. Later, I added: Features get

Carved in stone 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 »

PGCon 2009 Schedule released

Leave a Comment / Conferences, PGCon, PostgreSQL / By / /

The preliminary PGCon 2009 schedule has been released. PGCon is the premiere PostgreSQL conference. It is simply the best place to meet other PostgreSQL people and learn more. The talks are absolutely amazing, not to mention the great social atmosphere. If you’re looking to hire any PostgreSQL talent, PGCon is the place to be. You’ll find more PostgreSQL people (DBAs, coders, web developers, core contributers) than at any other conference. If you’re looking

PGCon 2009 Schedule released Read More »

Scroll to Top