Posts

Showing posts from 2019

How to install and initialize the PostgreSQL instance after installation

How to install and initialize the PostgreSQL instance after installation. In this post we will discuss how to install postgres server and initialize the service for first time. Also we discuss how to do all activity in RHEL6/7 servers. You can also follow other topics: psql: could not connect to server: Permission denied Reset Postgress user password in PostgreSQL Method 1:- How to install and initialize the PostgreSQL instance after installation Step1: Install postgres server # yum install postgres-server Step2: Check postgres version # postgres -V -bash: postgres: command not found Step3: Check postgres   service name # systemctl list-units --type service --all postgres.service    not-found       active    exited   postgres.service Step4: Find installation directory # find / -name postgres* /sys/fs/cgroup/systemd/system.slice/postgres.service /etc/selinux/targeted/active/...