Free Download PostgreSQL 9.4.0
close

USER LOGIN

Username
Password
or
create an account
Download » Windows » Internet » Web Servers » PostgreSQL
Your rating: you are not logged in
5 Stars Award
No screenshots available
Developer
Product Homepage
Date Added
License Free (Freeware)
Last Week / All Time Downloads 1 / 11,849
Filename / Size
postgresql-9.4.0-1-windows.exe / 56.0MB
MD5 Checksum
72C138A882988DA8C3477636A35A1413
OS Support Windows All

Description

A powerful, open source object-relational database system

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data. Some general PostgreSQL limits are included in the table below.

Featureful and Standards Compliant

PostgreSQL prides itself in standards compliance. Its SQL implementation strongly conforms to the ANSI-SQL:2008 standard. It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels. And while PostgreSQL has a fully relational system catalog which itself supports multiple schemas per database, its catalog is also accessible through the Information Schema as defined in the SQL standard.

Data integrity features include (compound) primary keys, foreign keys with restricting and cascading updates/deletes, check constraints, unique constraints, and not null constraints.

It also has a host of extensions and advanced features. Among the conveniences are auto-increment columns through sequences, and LIMIT/OFFSET allowing the return of partial result sets. PostgreSQL supports compound, unique, partial, and functional indexes which can use any of its B-tree, R-tree, hash, or GiST storage methods.

GiST (Generalized Search Tree) indexing is an advanced system which brings together a wide array of different sorting and searching algorithms including B-tree, B+-tree, R-tree, partial sum trees, ranked B+-trees and many others. It also provides an interface which allows both the creation of custom data types as well as extensible query methods with which to search them. Thus, GiST offers the flexibility to specify what you store, how you store it, and the ability to define new ways to search through it --- ways that far exceed those offered by standard B-tree, R-tree and other generalized search algorithms.

GiST serves as a foundation for many public projects that use PostgreSQL such as OpenFTS and PostGIS. OpenFTS (Open Source Full Text Search engine) provides online indexing of data and relevance ranking for database searching. PostGIS is a project which adds support for geographic objects in PostgreSQL, allowing it to be used as a spatial database for geographic information systems (GIS), much like ESRI's

SDE or Oracle's Spatial extension.

Other advanced features include table inheritance, a rules systems, and database events. Table inheritance puts an object oriented slant on table creation, allowing database designers to derive new tables from other tables, treating them as base classes. Even better, PostgreSQL supports both single and multiple inheritance in this manner.

The rules system, also called the query rewrite system, allows the database designer to create rules which identify specific operations for a given table or view, and dynamically transform them into alternate operations when they are processed.

The events system is an interprocess communication system in which messages and events can be transmitted between clients using the LISTEN and NOTIFY commands, allowing both simple peer to peer communication and advanced coordination on database events. Since notifications can be issued from triggers and stored procedures, PostgreSQL clients can monitor database events such as table updates, inserts, or deletes as they happen.

Highly Customizable

PostgreSQL runs stored procedures in more than a dozen programming languages, including Java, Perl, Python, Ruby, Tcl, C/C++, and its own PL/pgSQL, which is similar to Oracle's PL/SQL. Included with its standard function library are hundreds of built-in functions that range from basic math and string operations to cryptography and Oracle compatibility. Triggers and stored procedures can be written in C and loaded into the database as a library, allowing great flexibility in extending its capabilities. Similarly, PostgreSQL includes a framework that allows developers to define and create their own custom data types along with supporting functions and operators that define their behavior. As a result, a host of advanced data types have been created that range from geometric and spatial primitives to network addresses to even ISBN/ISSN (International Standard Book Number/International Standard Serial Number) data types, all of which can be optionally added to the system.

Just as there are many procedure languages supported by PostgreSQL, there are also many library interfaces as well, allowing various languages both compiled and interpreted to interface with PostgreSQL. There are interfaces for Java (JDBC), ODBC, Perl, Python, Ruby, C, C++, PHP, Lisp, Scheme, and Qt just to name a few.

PostgreSQL 100% CLEAN Certification

Badge

PostgreSQL has been tested by Soft82.com team against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean. Our editors will recheck this software periodically to assure that it remains clean.

View Antivirus Report

Version History

Product Date Added
PostgreSQL 9.4.0 December 24, 2014 - Latest Version
PostgreSQL 9.4.0 RC1 December 05, 2014
PostgreSQL 9.3.5.1 July 28, 2014

PostgreSQL Download Link For Your Website

If you want to place a Download Link for PostgreSQL on your website just insert the following code:

download PostgreSQL 9.4.0 download PostgreSQL 9.4.0

HTML - Copy the code below

FACEBOOK/TWITTER - Copy the code below

WIKI - Copy the code below

BBCode - Copy the code below

If you want you can use one of the logos below:

Soft82 logo
Soft82 logo

PostgreSQL User Reviews

Write a Review

Please log in to write a review

New Web Servers Software

Windows

fserv

January 27, 2015

Fast, small and free HTTP server
Check If URLs Exist (Is Valid) Software

Check If URLs Exist (Is Valid) Software

January 27, 2015

Verify web site links
Windows

Lookup Column

January 23, 2015

Powerful component suite that significantly enhances and extends standard lookup functionality
Serviio

Serviio

January 21, 2015

A free media server
Wing FTP Server

Wing FTP Server

January 20, 2015

A highly functional, easy-to-use and secure FTP Server solution
Apache Logs Viewer

Apache Logs Viewer

January 19, 2015

A tool to monitor/view and analyze apache log files
Wild media server (UPnP, DLNA, HTTP)

Wild media server (UPnP, DLNA, HTTP)

January 16, 2015

Provides media resources (photographs, audio and video files) on your computer to other UPnP (DLNA)
Windows

MobaSSH Professional

January 16, 2015

Enhanced SSH server for Windows with Unix tools and much more
MobaXterm Portable

MobaXterm Portable

January 14, 2015

Toolbox for remote computing
Windows

Media Browser Server

January 14, 2015

Media Browser energizes your media
priPrinter Server

priPrinter Server

January 13, 2015

A network based print preview solution
Active Directory Reports

Active Directory Reports

January 13, 2015

Save yourself hours of scripting active directory reports
BlissRADIUS

BlissRADIUS

January 10, 2015

High performance RADIUS billing solution
Windows

Muse Proxy

January 10, 2015

A highly customizable multi-platform proxy server
AccessToFile

AccessToFile

January 10, 2015

AccessToFile is a tool to export Access data to file
Windows

Node.js

January 9, 2015

A platform built on Chrome JavaScript runtime for easily building fast, scalable network apps
NeoLoad

NeoLoad

January 6, 2015

The web testing solution for optimizing all your applications
Windows

QueueMonitor

January 6, 2015

Aonitor and automate your MSMQ queues
AMPPS

AMPPS

January 5, 2015

A WAMP, MAMP and LAMP stack of Apache, MySQL, MongoDB, PHP, Perl & Python
POP3conneX

POP3conneX

January 5, 2015

A POP3 gateway to automatically download your incoming POP3/IMAP4 mail from multiple remote servers

Last Week Most Downloaded Web Servers Products

SafeIP

SafeIP

32 downloads

Hide your IP address and protect your online identity with SafeIP
Google Chrome Frame

Google Chrome Frame

17 downloads

An open source plug-in that seamlessly brings Google Chrome's open
Windows

Apache HTTP Server

12 downloads

An effort to develop and maintain an open-source HTTP server for modern operating systems including
Windows

fserv

10 downloads

Fast, small and free HTTP server
Advanced Onion Router

Advanced Onion Router

9 downloads

A portable client and server for the Tor network
Navicat for PostgreSQL

Navicat for PostgreSQL

9 downloads

An easy-to-use graphical tool for PostgreSQL database administration
Windows

Auto WebSubmit

8 downloads

Program designed to submit your website to hundreds of search engines and directories
JumpBox for the PunBB Discussion Forums Software

JumpBox for the PunBB Discussion Forums Software

8 downloads

JumpBox makes using server software quick and simple
Wing FTP Server

Wing FTP Server

7 downloads

A highly functional, easy-to-use and secure FTP Server solution
SMTP Relay Server

SMTP Relay Server

7 downloads

Create your own SMTP/POP3/IMAP4 mail server and run it on any Windows computer

All Time Most Downloaded Web Servers Products

JumpBox for the PunBB Discussion Forums Software

JumpBox for the PunBB Discussion Forums Software

12,968 downloads

JumpBox makes using server software quick and simple
PostgreSQL

PostgreSQL

11,849 downloads

A powerful, open source object-relational database system
Apache Tomcat

Apache Tomcat

6,636 downloads

An open source software implementation of the Java Servlet and JavaServer Pages technologies
Windows

Administration Pack for IIS

6,222 downloads

collection of tools and UI Extensions to help you administer your IIS 7.0 server.
PS3 Media Server

PS3 Media Server

5,814 downloads

A DLNA compliant Upnp Media Server for the PS3, written in Java, with the purpose of streaming
Advanced Forum

Advanced Forum

4,465 downloads

Small but still powerful forum for your website
Google Chrome Frame

Google Chrome Frame

4,418 downloads

An open source plug-in that seamlessly brings Google Chrome's open
VMware Server

VMware Server

3,916 downloads

Partition your physical server into multiple virtual machines
Windows

Microsoft Office Migration Planning Manager

3,539 downloads

A group of tools designed to help administrators
Navicat Lite for MySQL

Navicat Lite for MySQL

3,488 downloads

A powerful Database administration and development tool for MySQL.
Soft82 logo
Free Newsletter

Join our low-volume monthly free newsletter that will deliver latest freeware and shareware news straight to your inbox!

Your e-mail
Icon
link to us | site map | submit software | advertise | contact | privacy policy | mobile
Copyright © 2006 - 2015 SOLUTIONS AND CONSULTING S.R.L. - All rights reserved.