Module3_Installation

Question 1

what is the default OS user when installing postgresql and what is it state?

Answer 1

Default postgres user is created and locked on OS level. idealy create the postgres user and change it’s password before you start.
useradd postgres
passwd postgres

Question 2

what does this commando do:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Answer 2

Install the repository RPM:

Question 3

what does this commando do:
sudo yum install -y postgresql13-server

Answer 3

install postgresql13

Question 4

what does this commando:
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb

Answer 4

initialise the instance

Question 5

how to enable and start the postgresql service:

Answer 5

sudo systemctl enable postgresql-13
sudo systemctl start postgresql-13

Question 6

what is the default postgres DB password?

Answer 6

BLANK. to change this login in the database and “alter user postgres PASSWORD ‘password_here’;

Question 7

what is the default authentication for postgres?

Answer 7

PEER, when you are logged in in the OS you can login to DB as well (not so safe)

Question 8

where can we change Default ENVIRONMENT parameters?

Answer 8

in the BASH_PROFILE