database
-
Encrypted Postgres Backups
Today I decided to encrypt all my Postgresql Database Dumps. The OpenSSL command provides a nice tool for helping us encrypt and decrypt database backups in…
-
Change and Update WordPress URLS in Database
After migrating a WordPress site to a new URL either to a live production or a testing development server, the new URL strings in the mysql database…
-
Read-only user in PostgreSQL
Create only read only with limited access to PostgreSQL Database. This user can only SELECT table data and also restricted by schema access.
-
How to monitor sql queries with zabbix
If you want to monitor some parameters in mysql database, you can do it with ODBC monitoring in Zabbix. ODBC monitoring corresponds to the Database…