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 […]
Category Archives: System Administration
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.
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 […]
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 […]
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 […]