Search For Answers
What is Postgres?
Last updated: March 28, 2011
PostgreSQL, is simply Postgres which is an object-relational database management system. It is released under an MIT-style license and it is free and open source software. As like many other open-source programs, PostgreSQL is not controlled by any single company. It is a global community of developers and companies develops the system.
It is a unified database server with a single storage engine. This server can handle multiple concurrent connections from clients. In order to achieve that purpose, it starts a new process ("forks") for each connection. With the introduction of that, the client and the new server process communicate without intervention by the original postmaster process. Thus, the postmaster is always running, waiting for client connections, whereas client and associated server processes are going on. These processes are invisible to the user.
We have aready mentioned that the PostgreSQL is a single storage engine database server as opposed to MySQL which has two layers, an upper SQL layer and a set of storage engines.
In order to work on the postgres database, you have to login as the "postgres" user (which is configured by default during Postgresql installation).