Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Text Mode Installation

II.Postgresql 9.3 - Text Mode Installation:
Download the edb software following link https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
  • To specify that the installer should run in text mode, include the –mode text command line option when invoking the installer. Text-mode installations are useful if you need to install on a remote server using ssh tunneling (and have access to a minimal amount of bandwidth), or if you do not have access to a graphical interface.
  • In text mode, the installer uses a series of command line questions to establish the configuration parameters. Text-mode installations are valid only on Linux or Mac systems.
  • You must assume superuser privileges before performing a text-mode installation. At any point during the installation process, you can press Ctrl-C to abort the installation. 
  • To perform a text-mode installation on a Linux system, navigate to the directory that contains the installation binary file and enter:
# ./postgres-version-platform.run --mode text
1.Download the installer from below link:

2.Goto the location of PostgreSQL 9.2 installer(postgresql-9.2.5-1-linux-x64.run) and run the installer in text mode as below

 ./postgresql-9.3.2.-3-linux-x64.run --mode text 
When the installation begins, the text mode installer welcomes you to the Setup Wizard (shown As Below)

3.Provide the base directory for installation We have provided "/opt/PostgreSQL/9.3" 
Installation Directory [/opt/PostgreSQL/9.3]:
4.Provide the data directory location We have  provided "/opt/PostgreSQL/9.3/data"
Data Directory [/opt/PostgreSQL/9.3/data]: 
5.You must provide a password for the database superuser . The specified password must conform to any security policies (minimum length, use of special characters, and so on) in place on the host. After entering a password in the Password field, confirm the password and press Enter to continue.
Password :
6.provide the port number
Specify a listener port for the service.When prompted, enter the Port that the PostgreSQL service will monitor for connections.By default, PostgreSQL chooses the first available port 
Port [5433]:
7.Select an installation locale.

select the locale (By default it is [1] Default locale)
[1] [Default locale] [2] C
[3] en_AG
[4] en_AG.utf8
[5] en_AU.utf8 [6] en_BW.utf8 [7] en_CA.utf8 [8] en_DK.utf8 [9] en_GB.utf8 [10] en_HK.utf8 [11] en_IE.utf8 [12] en_IN
[13] en_IN.utf8 [14] en_NG [15] en_NG.utf8 [16] en_NZ.utf8 [17] en_PH.utf8 [18] en_SG.utf8
[19] en_US.utf8
[20] en_ZA.utf8
[21] en_ZW.utf8
[22] POSIX
Please choose an option [1] : 1 
8.Setup is ready to begin the installation process.
Do you want to continue? [Y/n]: y
------------------ Please wait while Setup installs PostgreSQL on your computer.
9.Installing Postgres
When the setup wizard has gathered the information that it needs to perform the installation, it will prompt you that it is ready to begin installing PostgreSQL. Press Enter to continue.

0% ______________ 50% ______________ 100% 
10.The setup wizard informs you when the installation is complete
After the installation, you need to set environment variables. There is a pg_env.sh file in which all environment variables are exported in /opt/PostgreSQL92(which base installation directory). You can run that file to set env settings Or you can set it in .bash_profile where every postgres user login env file gets run.
Open the bash file $vi .bash_profile   and Enter the below line:

source /opt/PostgreSQL92/pg_env.sh
Run the bash file for the first time
Uninstall Postgres Server:
Instead GUI, we need to give Text
Go to /opt/Postgresql/ 9.3/



Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

Postgres Streaming Replication Configuration

vacuumlo - removing large objects orphans from a database PostgreSQL