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 »
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
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
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
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
Avoiding deadlock on FreshPorts Read More »