Technical notes‎ > ‎

Using PostgreSQL

posted Nov 2, 2017, 12:22 AM by Le Tuan Anh   [ updated Nov 2, 2017, 1:21 AM ]

Installation

dnf install postgresql postgresql-server
# setup DB
postgresql-setup --initdb

Start/stop services

systemctl start postgresql

by default, postgres use ident mode (system user account) for login, so there is no default password. To change this, update this file:
/var/lib/pgsql/data/pg_hba.conf

su - postgres
psql
\password
\q


[TO BE UPDATED]
Comments