Found how to escape @ characters in Subversion managed file names?. The short answer is that you add an extra ‘@’ character at the end of the file name…
Author Archives: Jay Jay
Let’s Encrypt & Nginx
An article about Let’s Encrypt & Nginx…
SQL Injection Cheat Sheet
Some notes on SQL injection…
PHP values
Modern Educayshun
Modern Educayshun. Didn’t like it.
Taking things literally
Reply
I’m a thief. I take things literally.
Putting SELinux in Permissive mode on Fedora
See here for details. Basically edit /etc/selinux/config and change ‘enforcing’ to ‘permissive’.
How to downgrade a package in Debian using apt-get and apt-cache
See here. Basically:
dpkg --list apt-cache showpkg packagename apt-get install packagename=version echo "packagename hold" | sudo dpkg --set-selections
Administering PostgreSQL
So I found this article which said:
$ sudo -u postgres psql
postgres=> alter user postgres password 'apassword'; postgres=> create user your-user createdb createuser password 'passwd'; postgres=> create database your-db-name owner your-user; postgres=> \q
Note: to enable password logins for the ‘postgres’ admin account, edit: /etc/postgresql/9.4/main/pg_hba.conf and after this line:
local all postgres peer
Add this line:
local all postgres md5
How do I list all databases and tables using psql?
So I found this which said:
- \list or \l
- list all databases
- \dt
- list all tables in the current database