II.Postgresql 9.3 - Text Mode Installation:
1.Download the installer from below link:
3.Provide the base directory for installation We have provided "/opt/PostgreSQL/9.3"
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
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.
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:
Uninstall Postgres Server:
Instead GUI, we need to give Text
Go to /opt/Postgresql/ 9.3/
- 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
http://www.enterprisedb.com/products-services-training/pgdownload
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 numberSpecify 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)
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 PostgresWhen 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 completeAfter 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 timeUninstall Postgres Server:
Instead GUI, we need to give Text
Go to /opt/Postgresql/ 9.3/
./uninstall-Postgresql_complete
No comments:
Post a Comment