How to PostgreSQL- Getting started
In this guide, You will learn PostgreSQL through many practical examples. PostgreSQL is a fully featured object-relational database with many enterprise features.
PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system.
It is also highly extensible and allows users to define internal functions in C, C++, Java, Perl, TCL, Python, Ruby, PHP and PL/PgSQL.
PostgreSQL is developed by the PostgreSQL Global Development Group, a diverse group of many companies and individual contributors. PostgreSQL is free and open source software. Its source code is available under PostgreSQL license.
- Easy to install and configure
- The Web Control Panel
- Adminer administration frontend for PostgreSQL
- Webmin modules for configuring PostgreSQL.
- PostgreSQL is configured to listen on its default port on all interfaces by default, and accept connections from all hosts.
- PostgreSQL password encryption enabled by default (security).
- The Postgres user is trusted when connecting over local Unix sockets (convenience).
- PostGIS support.
Featured companies Apple, Fujitsu, Red Hat, Cisco, Juniper Network, etc. are using built products and solutions using PostgreSQL.
No default passwords: For security reasons, there are no default passwords. All passwords are set at system initialization time.
Ignore SSL browser warning: browsers don’t like self-signed SSL certificates, but this is the only kind that can be generated automatically without paying a commercial Certificate Authority.
If you need any support, an active community is available to help. You can always find the answers from the PostgreSQL’s community for the issues that you may have when working with PostgreSQL.
MySQL vs PostgreSQL
|Name||MySQL X||PostgreSQL X|
|Database model||Relational DBMS||Relational DBMS|
|Developer||Oracle||PostgreSQL Global Development Group|
|License||Open Source||Open Source|
|Implementation language||C and C++||C|
|Server operating systems||FreeBSD, Linux, OS X, Solaris, Windows||FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix, Windows
|APIs and other access methods||ADO.NET, JDBC, ODBC||Native C library,Streaming API for large objects, ADO.NET, JDBC, ODBC|
|Server-side scripts||yes||user defined functions|
|Partitioning methods||horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric||no, but can be realized using table inheritance|
|Replication methods||Master-master replication, Master-slave replication||Master-slave replication|
|Consistency concepts||Immediate Consistency||Immediate Consistency|
|User concepts||Users with fine-grained authorization concept||fine grained access rights according to SQL-standard|