PostgresqlHelp

Two Methods of installing PostgreSQL 10

PostgreSQL can be installed by means of two ways

1. Installing from source
2. 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 resolve

https://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 Background processes

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 collector

PostgreSQL: 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

1. PostgreSQL: Logger process
2. PostgreSQL: WAL writer process:

PostgreSQL: logger 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.

PostgreSQL Background writer

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.

PostgreSQL Interview Questions

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 postgreshelp@gmail.com/admin@postgreshelp.com.

We will publish the questions along with the answers or we will open the answer to the comments.

Have a happy learning!!