POSTGRESQL INSTALL INSTALL
POSTGRESQL INSTALL DRIVER
POSTGRESQL INSTALL FULL
POSTGRESQL INSTALL SOFTWARE
POSTGRESQL INSTALL CODE

> Package postgresql93.x86_64 0:9.3.6-1PGDG.rhel6 will be installed > Package postgresql93-server.x86_64 0:9.3.6-1PGDG.rhel6 will be installed > Processing Dependency: libossp-uuid.so.16()(64bit) for package: postgresql93-contrib-9.3.86_64 > Processing Dependency: libpq.so.5()(64bit) for package: postgresql93-contrib-9.3.86_64 > Processing Dependency: postgresql93 = 9.3.6 for package: postgresql93-contrib-9.3.86_64

> Package postgresql93-contrib.x86_64 0:9.3.6-1PGDG.rhel6 will be installed

POSTGRESQL INSTALL INSTALL

Hence we go ahead and install them: ~]# yum install postgresql93-server postgresql93-contrib However the above two will also install the client side utility as well. Also there is another one listed above which is called “postgresql93.x86_64”, this installs the client side only which is useful for testing whether you can connect to your postgresql db from another machine. The two rpms we have shown in bold above are the ones we need. Name and summary matches only, use 'search all' for tmp]# Postgresql93-test.x86_64 : The test suite distributed with PostgreSQL

Postgresql93-server.x86_64 : The programs needed to create and run a PostgreSQL server

POSTGRESQL INSTALL CODE

Postgresql93-python.x86_64 : Development module for Python code to access a PostgreSQL DB Postgresql93-pltcl.x86_64 : The Tcl procedural language for PostgreSQL Postgresql93-plpython.x86_64 : The Python procedural language for PostgreSQL Postgresql93-plperl.x86_64 : The Perl procedural language for PostgreSQL

POSTGRESQL INSTALL DRIVER

Postgresql93-odbc.x86_64 : PostgreSQL ODBC driver Postgresql93-libs.x86_64 : The shared libraries required for any PostgreSQL clients Postgresql93-jdbc.x86_64 : JDBC driver for PostgreSQL Postgresql93-docs.x86_64 : Extra documentation for PostgreSQL Postgresql93-devel.x86_64 : PostgreSQL development header files and libraries Postgresql93-contrib.x86_64 : Contributed source and binaries distributed with PostgreSQL Postgresql93.x86_64 : PostgreSQL client programs and libraries Postgresql93-python-debuginfo.x86_64 : Debug information for package postgresql93-python Postgresql93-odbc-debuginfo.x86_64 : Debug information for package postgresql93-odbc Postgresql93-jdbc-debuginfo.x86_64 : Debug information for package postgresql93-jdbc Postgresql93-debuginfo.x86_64 : Debug information for package postgresql93 In my case, the I want to install postresql v9.3, so that’s what I’ll search for tmp]# yum search 'postgresql93' rw-r-r- 1 root root 442 pgdg-93-oraclelinux.repo This hasn’t actually installed postgres yet, it only installed the postgres yum repo, which in my case is the yum repo for postgres 9.3, which is the version I am interested tmp]# ls -l /etc// | grep 'pgdg'

Then, while in that directory, install it using yum:Īlternatively we can combine the above curl+yum commands into a single command, and run the following command instead of the above 2 commands: yum install First decide on which postgresql rpm package you want.

POSTGRESQL INSTALL SOFTWARE

Installing the PostgreSQL software on your serverįirst download the rpm, using curl/wget. Remotely connect to the new db using the new db user account.Connect to the new db using the new db user account.

POSTGRESQL INSTALL FULL

Create a new DB user account and give it full access to the new db.

Create your very first PostgreSQL DB – in our case we are going to create a db called “reviewdb”.

Installing the PostgreSQL software on your server.

You can find all my latest posts on medium.

Postgresql install