Category Archives: System Administration

Creating users in PostgreSQL

This one has thrown me one too many times, and short of a better place to note this sequence of commands down, I’m posting it here.

postgres=> CREATE USER new_user WITH PASSWORD 'SuperSecurePassword';
CREATE ROLE
postgres=> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO new_user;
GRANT
postgres=> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO new_user;
GRANT
postgres=> GRANT USAGE ON SCHEMA public TO new_user;
GRANT
postgres=> \q

Configuring pfSense to work with BT Infinity native IPv6

A quick post this one. I’ve been scouring the internet trying to find the right settings in order to connect up my pfSense to use BT Infinity’s native IPv6 implementation. Finally found the magic combination, which I’m sharing here for future reference, and hopefully help anyone else that might find this post.

Continue reading “Configuring pfSense to work with BT Infinity native IPv6” »

Setting up WordPress behind Amazon Cloudfront

You all know that feeling (well, I hope you do!) that when a spike in traffic occurs on your WordPress site, that the miniature server you have it running on very quickly runs out of resources. Apache’s good like that. Taking up all the resources with its large number of processes consuming oodles of memory each. How on earth can you possibly fix it, especially when you’re running on a tight budget and upgrading the server for that once-in-a-blue-moon you get a spike in traffic? Well, Amazon Cloudfront to the rescue!

Continue reading “Setting up WordPress behind Amazon Cloudfront” »

Making WordPress’s qTranslate plugin work on different domain names

Recently I was handed a WordPress site for a client that used qTranslate for various versions of their website in different languages. The caveat was that each language needed its own domain name, not a subdomain, path or query string of the main one. For sure I could have redirected the welsh domain to the english version with the /cy/ path in it, but I had a better idea. Use nginx. This is utterly genius.

Continue reading “Making WordPress’s qTranslate plugin work on different domain names” »

Fedora 16 to 17 upgrade

I finally had the opportunity to upgrade my laptop from Fedora 16 to 17. When I installed 16 originally, within the week 17 came out, and I was too busy to do anything about it. Granted now 18 is in beta, and is likely to be released tomorrow now that I’ve done this upgrade, I wanted to post about an issue that I came across that no one seems to have touched on much, or at least there’s no real mention of it online. Only by chance did using a couple of tricks combined sort the problem out.

Continue reading “Fedora 16 to 17 upgrade” »