Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Installation Of Postgresql Using Text Mode Method on linux Example With Screenshot

II.Postgresql 9.3 - Text Mode Installation:
  • 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
$. .bash_profile
Uninstall Postgres Server:
Instead GUI, we need to give Text
Go to /opt/Postgresql/ 9.3/


Popular posts from this blog

7 Steps to configure BDR replication in postgresql

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

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory