Hmm. Also, happy world’s end.
[ Torrent ]
This blog has been updated to WordPress 3.5. Initial impressions:
Overall there isn’t much change (what should I expect here) but the new theme sucks. At least to be used on this blog.
With my move to a better VPS, I changed some things on 0paste:
Worked quite well and much easier to maintain.
For my own reference, after few hours messing around with shit called mail system.
Connecting to PostgreSQL from command line can be a bit confusing.
For starter, just like MySQL, psql
command defaults to connecting to socket instead of tcp. To make matter confusing, most PostgreSQL installation defaults to ident
(also called peer
)authentication for socket connection: it basically matches current user’s username (ssh login, etc) with PostgreSQL equivalent.
So, instead of using this to login from root to PostgreSQL superuser (usually named postgres or pgsql):
# psql -U postgres
you do this (assuming sudo installed):
# sudo -u postgres psql
The configuration for this is located in pg_hba.conf
of PostgreSQL data (or config in Debian) directory (/etc/postgresql/$version/main
in Debian, /usr/local/pgsql/data
in FreeBSD, /opt/PostgreSQL/$version/data
in EnterpriseDB PostgreSQL).
To switch to password based authentication for all methods just replace ident
(or peer
) with md5
in respective lines and reload/restart the service. Don’t forget to set password for postgres user first before changing this otherwise you won’t be able to connect. You can then connect using psql
to any user using password.
By default, CentOS 6 (and other RHEL clones) only provides transmission 2.13. There’s alternative repository from transmission official site but it isn’t really all that “latest” either (and I don’t fancy adding random repositories).
First, compile libevent2:
./configure --prefix=/opt/libevent2 && make && make install
And then compile transmission (hopefully you don’t need the gtk interface):
PKG_CONFIG_PATH=/opt/libevent2/lib/pkgconfig ./configure --prefix=/opt/transmission --disable-nls --enable-daemon
make && make install
Don’t forget to add path to transmission in bash default profile (inĀ /etc/profile.d/custom.sh):
PATH="/opt/transmission/bin:${PATH}"
And done! Enjoy the latest transmission.