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