The Best PostgreSQL Web Hosting
Three of the webhosts on our list support PostgreSQL. Since it is not used often in free open-source PHP applications that are included in many hosting packages (e.g. WordPress), support for it can be difficult to find. If you have a PostgreSQL application or will be creating one for your website, we recommend IX Webhosting. They allow unlimited PostgreSQL databases and provide a generous 10GB size limit. IX Webhosting also provides:
- Their own state-of-the-art Data Centers with modern, up to date servers
- .htaccess editing, custom error pages and customizable PHP.ini files
- $150 of Advertising Credits
- 15 Dedicated IP Addresses
- 3 Free Lifetime Domain Names
PostgreSQL Web Hosting Ratings | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
Host Name | Plan | Unlimited | Uptime | Money Back |
Web Host Ratings |
|||||
Unlimited Pro $7.95/mo |
99.9% | 30 Days | ||||||||
Professional $6.95/mo |
99.9% | 30 Days | ||||||||
Professional $6.95/mo |
99.9% | 30 Days | ||||||||
Click Here for our Detailed Web Host Comparison |
What is PostgreSQL?
PostgreSQL, also known as Postgres, is an object-relational database management system (ORDBMS) released under a BSD-style license and is thus free, open source software. As with many other open source programs, PostgreSQL is not controlled by any single company, but has a global community of developers and companies to develop it. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.
The program runs on a host’s server, so in order to use a web application that has a Postgres database backend, your host must support it. In web hosting accounts, pgAdmin or phpPgAdmin (a free web-based interface based on phpMySQL) is often used to access and administer your PostgreSQL databases. It is used on very high-profile websites including Yahoo! for web user behavioral analysis, MySpace is using Aster nCluster Database (which is built on unmodified PostgreSQL) for data warehousing, OpenStreetMap, Sony Online multiplayer online games, BASF’s shopping platform for their agribusiness portal and Skype’s central business databases.
PostgreSQL is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL92 and SQL99 data types, including
- INTEGER
- NUMERIC
- BOOLEAN
- CHAR
- VARCHAR
- DATE
- INTERVAL
- TIMESTAMP
It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, Perl, Python, Ruby, .Net, Tcl and ODBC among others, and has excellent documentation.
By Type:
Business Hosting:
Software Support:
Web Applications: