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.
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
7.Select an installation locale.
select the locale (By default it is  Default locale) Locale  [Default locale]  C  en_AG  en_AG.utf8  en_AU.utf8  en_BW.utf8  en_CA.utf8  en_DK.utf8  en_GB.utf8  en_HK.utf8  en_IE.utf8  en_IN  en_IN.utf8  en_NG  en_NG.utf8  en_NZ.utf8  en_PH.utf8  en_SG.utf8  en_US.utf8  en_ZA.utf8  en_ZW.utf8  POSIX Please choose an option  : 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.
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.
Installing 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:
Run the bash file for the first time
Uninstall Postgres Server:
Instead GUI, we need to give Text
Go to /opt/Postgresql/ 9.3/