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 am guessing that the last two tapes can be reused. I’m also guessing that the first one cannot […]
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 owned by user “pgsql”. This user must also own the server process. The database cluster will be initialized
LANG prevents PostgreSQL initdb Read More »
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 »
With all the databases I run, I need a daily sanity check. I download a copy of each database and do a test load on my system at home. Today I timed that process: $ time ~/bin/backup-supernews.sh … real 77m57.323s user 12m52.610s sys 0m56.136s There are 11 such databases. The dump files range in size from 5K (globals.sql) to 2.8G (freshports.sql). The script that does this is pretty simple, but has evolved over
Database load times Read More »
I’ve been running ads on my websites since early 1999, so nearly 10 years. It was roughly May 2002 that I started using phpPgAds. This was the PostgreSQL version of phpAdsNew. This project became OpenAds and is now known as OpenX. Recently I decided to upgrade to the latest version of OpenX. There was a upgrade path from Openads-PgSQL-2.0.11-pr1, the latest releast of OpenAds to use PostgreSQL, to OpenX 2.6. The first problem
openx upgrade issues Read More »
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
MySQL bought. PostgreSQL not for sale. Read More »
FreshPorts is an automated reporting mechanism for the FreeBSD ports and package. You may be familiar with freshmeat, upon which FreshPorts is loosely based. The major difference is that FreshPorts is 100% automated; everything operates off scripts. Features The key features of FreshPorts includes a powerful search tool and the ability to create custom watch lists that allow you to track changes to any port and receive automated notification via email. FreshPorts uses
Avoiding deadlock on FreshPorts Read More »