Monday, November 4, 2019

Install Postgres version 10.10 on Linux 64 machine

Download postgres from postgres source website and proceed as below:

[oracle@prod u01]$ cd stage/
[oracle@prod stage]$ ls -ltr
-rw-r--r--  1 root daemon  128913813 Nov  2 20:13 postgresql-10.10-2-linux-x64.run

RunInstaller should be run from super user

[root@prod stage]# ./postgresql-10.10-2-linux-x64.run
----------------------------------------------------------------------------
Welcome to the PostgreSQL Setup Wizard.

----------------------------------------------------------------------------
Please specify the directory where PostgreSQL will be installed.

Installation Directory [/opt/PostgreSQL/10]: /u01/postgres

----------------------------------------------------------------------------
Select the components you want to install; clear the components you do not want
to install. Click Next when you are ready to continue.

PostgreSQL Server [Y/n] :Y

pgAdmin 4 [Y/n] :Y

Stack Builder [Y/n] :Y

Command Line Tools [Y/n] :Y

Is the selection above correct? [Y/n]: Y

----------------------------------------------------------------------------
Please select a directory under which to store your data.

Data Directory [/u01/postgres/data]:

----------------------------------------------------------------------------
Please provide a password for the database superuser (postgres). A locked Unix
user account (postgres) will be created if not present.

Password :
Retype password :
----------------------------------------------------------------------------
Please select the port number the server should listen on.

Port [5432]:

----------------------------------------------------------------------------
Advanced Options

Select the locale to be used by the new database cluster.

Locale

[1] [Default locale]
[2] aa_DJ
..
....
[718] zu_ZA.utf8
Please choose an option [1] :

----------------------------------------------------------------------------
Pre Installation Summary

The following settings will be used for the installation::

Installation Directory: /u01/postgres
Server Installation Directory: /u01/postgres
Data Directory: /u01/postgres/data
Database Port: 5432
Database Superuser: postgres
Operating System Account: postgres
Database Service: postgresql-10
Command Line Tools Installation Directory: /u01/postgres
pgAdmin4 Installation Directory: /u01/postgres/pgAdmin 4
Stack Builder Installation Directory: /u01/postgres

Press [Enter] to continue:

----------------------------------------------------------------------------
Setup is now ready to begin installing PostgreSQL on your computer.

Do you want to continue? [Y/n]: y

----------------------------------------------------------------------------
Please wait while Setup installs PostgreSQL on your computer.

 Installing
 0% ______________ 50% ______________ 100%
 #########################################

----------------------------------------------------------------------------
Setup has finished installing PostgreSQL on your computer.

Once installer process completed check postgres background processes:

[root@prod stage]# su - postgres
-bash-4.1$ ps -fu postgres
UID         PID   PPID  C STIME TTY          TIME CMD
postgres   6527      1  0 20:51 ?        00:00:00 /u01/postgres/bin/postgres -D /u01/postgres/data
postgres   6528   6527  0 20:51 ?        00:00:00 postgres: logger process
postgres   6530   6527  0 20:51 ?        00:00:00 postgres: checkpointer process
postgres   6531   6527  0 20:51 ?        00:00:00 postgres: writer process
postgres   6532   6527  0 20:51 ?        00:00:00 postgres: wal writer process
postgres   6533   6527  0 20:51 ?        00:00:00 postgres: autovacuum launcher process
postgres   6534   6527  0 20:51 ?        00:00:00 postgres: stats collector process
postgres   6535   6527  0 20:51 ?        00:00:00 postgres: bgworker: logical replication launcher
postgres   7530   7529  0 21:00 pts/0    00:00:00 -bash
postgres   7590   7530  0 21:00 pts/0    00:00:00 ps -fu postgres

-bash-4.1$  ps -ef | egrep "pg|postgres"
postgres   6527      1  0 20:51 ?        00:00:00 /u01/postgres/bin/postgres -D /u01/postgres/data
postgres   6528   6527  0 20:51 ?        00:00:00 postgres: logger process
postgres   6530   6527  0 20:51 ?        00:00:00 postgres: checkpointer process
postgres   6531   6527  0 20:51 ?        00:00:00 postgres: writer process
postgres   6532   6527  0 20:51 ?        00:00:00 postgres: wal writer process
postgres   6533   6527  0 20:51 ?        00:00:00 postgres: autovacuum launcher process
postgres   6534   6527  0 20:51 ?        00:00:00 postgres: stats collector process
postgres   6535   6527  0 20:51 ?        00:00:00 postgres: bgworker: logical replication launcher
root       7529   3639  0 21:00 pts/0    00:00:00 su - postgres
postgres   7530   7529  0 21:00 pts/0    00:00:00 -bash
postgres   7662   7530  0 21:01 pts/0    00:00:00 ps -ef
postgres   7663   7530  0 21:01 pts/0    00:00:00 egrep pg|postgres


Regards,

No comments:

Post a Comment