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 […]
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 »
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 »
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 »
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 »