# remove folders and hidden files check with ls -a to get names.
# NEEDS TO BE DONE AS root so login as - su
rm -rf /var/lib/pgsql/*
rm -rf /var/lib/pgsql/backups/*
rm -rf /var/lib/pgsql/data/*
# check on fedora page for database initialization and enabling on boot
# add new user
sudo -u postgres psql postgres
# enter system password
# create user
CREATE USER username WITH PASSWORD 'secret';
# optional add options
ALTER USER username WITH [options]
CREATE DATABASE username OWNER username; # no login if no database
# change configuration on pg_hba.conf to:
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5