< Home - < Back

postgresql


Information about the package, postgresql, which is shipped with common Linux distributions. The postgresql package is designed for, PostgreSQL client programs.


Package Name:

postgresql

Summary:

PostgreSQL client programs

Description:

PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). The postgresql package includes the client programs and libraries that you'll need to access a PostgreSQL DBMS server. These PostgreSQL client programs are programs that directly manipulate the internal structure of PostgreSQL databases on a PostgreSQL server. These client programs can be located on the same machine with the PostgreSQL server, or may be on a remote machine which accesses a PostgreSQL server over a network connection. This package contains the docs in HTML for the whole package, as well as command-line utilities for managing PostgreSQL databases on a PostgreSQL server. If you want to manipulate a PostgreSQL database on a local or remote PostgreSQL server, you need this package. You also need to install this package if you're installing the postgresql-server package.

Architecture:

x86_64

Version:

8.4.20

Release:

8.el6_9

Size:

2.6 M

Repository:

updates

From Repository:

Licence:

PostgreSQL



Handy Yum Commands for postgresql


Control the postgresql package with the following handy commands outlined below.


Command

Description of Command

yum install postgresql

This command will install postgresql on the server.

yum remove postgresql

This command will un-install postgresql on the server. When you run this command, you will be asked if you are sure that you want to remove postgresql, so you have to manually confirm that you want to do this.

yum -y remove postgresql

This command will un-install postgresql on the server. When you run this command with th e -y flag, you will not be prompted to check that you are sure you want to remove the package - so be sure you absolutely want to remove postgresql when using the -y flag.

yum update postgresql

This command will update postgresql to the latest version. When you run this command, you will be asked if you are sure that you want to remove postgresql, so you have to manually confirm that you want to do this.

yum -y update postgresql

This command will update postgresql to the latest version. When you run this command with the -y flag, you will not be prompted to check that you are sure you want to remove the package - so be sure you absolutely want to remove postgresql when using the -y flag.

yum info postgresql

This command will show you core information about the postgresql package.

yum deplist postgresql

This command will show you the dependencies for postgresql. Thankfully, when using Yum, if dependencies are required, these are also installed at the same time so you don't have to worry too much about that.

yum check-update postgresql

This command will check if there is an update waiting on postgresql. When you run this command this will return nothing if there is nothing to update, or, will return the package name if the package is due to be updated.