Thursday, May 30, 2019

How to create a new database in PostgreSQL

›
postgres=# create role music; CREATE ROLE postgres=# create database musicdb with owner = music; CREATE DATABASE postgres=# Documented he...
Sunday, May 26, 2019

How to display Linux kernel and version information on debian platforms

›
Use the lsb (Linux Standard Base) utility: lsb_release -a Output: No LSB modules are available. Distributor ID: Ubuntu Description: Ubunt...
Wednesday, May 22, 2019

Deprecated security parameter in Oracle 12c: SEC_CASE_SENSITIVE_LOGON

›
Oracle states: "The use of the Oracle instance initialization parameter SEC_CASE_SENSITIVE_LOGON is deprecated in favor of setting t...
Tuesday, May 21, 2019

How to lookup ip addresses from mac addresses on Windows

›
Use the arp utility (Adress Resolution Protocol). arp -a it will print the arp table for you, where you can map ip addresses to mac addr...
Thursday, May 16, 2019

How to compress tables on import

›
Oracle 12c introduces a way to compress tables on the fly, during import using impdp. Use the directive transform=table_compression_cla...
Thursday, May 9, 2019

How to unlock users with expired password in postgreSQL

›
select now()+'90 days' as expiry; expiry ------------------------------- 2019-08-07 10:07:01.172082+02 \gset alter user jim valid...
Monday, May 6, 2019

How to explain a query in PostgreSQL

›
If you are using partitioned tables, make sure you have enabled partition pruning: SET enable_partition_pruning to on; The explain state...