Database

July 11, 2019 / 1 min read

Postgres: role “postgres” does not exist

Fix FATAL: role “postgres” does not exist with Postgres.app on MacOs

Java Spring Spring Boot Database Postgres PostgreSQL

Read →

July 6, 2017 / 1 min read

PostgreSQL format decimal separator from point to comma

How to change the decimal separator without changing the representation in the Postgres database

Postgres Database Decimal separator How to PostgreSQL

Read →

November 23, 2016 / 1 min read

View data in embedded hypersonic database in Liferay

How to connect to Liferay’s embedded Hypersonic DB (jdbc:hsqldb:file:…;readonly=true) to inspect data.

Liferay Embedded Database Database

Read →

November 19, 2016 / 1 min read

Database: Upgrade old PostgreSQL to new database version

Step-by-step commands to upgrade PostgreSQL clusters between versions on Ubuntu.

PostgreSQL Database Upgrade Postgres How to

Read →

June 14, 2014 / 1 min read

Database: Check the connection usage on Oracle DB

SQL query example to list Oracle resource limits (processes, sessions) when not unlimited.

Oracle Oracle DB Database Connection Limit SQL

Read →