PostgreSQL can be installed by means of two ways
- Installing from source
- Installing binary packages
Each method has its own advantages and disadvantages, however, we will limit this post to learn how to install PostgreSQL using binaries packages.
How to resolvehttps://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6Server-x86_64/repodata/repomd.xml: [Errno 14] problem making ssl connection
While I was installing PostgreSQL 10 on my Linux 6, I got the below error.
PostgreSQL has numerous background processes each has its own role to play for the successful functioning of the database.
List of PostgreSQL background processes:
In the last post we discussed about checkpoint process, in this tutorial we will discuss about PostgreSQL: Autovacuum launcher process.postgreSQLpostgreSQL Autovacuum launcher autovacuum launcher process
Autovacuum launcher is an optional process and it is enabled by default in PostgreSQL. This process automates the execution of vacuum and analyzes commands based on a few parameters.
In the last post we discussed about checkpoint process, in this tutorial we will discuss about PostgreSQL: stats collectorPostgreSQL: stats collector
The stats collector process collects statistics about the database. It’s an optional process with the default value as on.
The process keeps track of access to tables and indexes in both disk-block and individual row-terms.
In the last post we discussed about checkpoint process, in this tutorial we will discuss about
- PostgreSQL: Logger process
- PostgreSQL: WAL writer process:
logger process is a background process that captures log messages sent to stderr and redirects them into log files.
The process works when logging_collector parameter is enabled.
In the last post we discussed about checkpoint process, in this tutorial we will discuss about “postgres: Background writer”
Background writer writes dirty buffers into the datafiles.PostgreSQL: Background writer :
postgres: Background writer is started by the postmaster process during the start of instance.
Friends! If you had given any interview on PostgreSQL and you would like to share your interview experience to the PostgreSQL community around the globe? then please send your questions and answers to firstname.lastname@example.orgemail@example.com.
We will publish the questions along with the answers or we will open the answer to the comments.
Have a happy learning!!