Presented by:

C0a5fb4638f5f0ad7f53a3e98f13883b

Amul Sul

from EnterpriseDB
No video of the event yet, sorry!

Download slides

It is very important to know what you have at first place when you initialize a database cluster using initdb so that you can make necessary configuration before starting up the server. However, after server start you must know which are the auxiliary processes are forked by the Postgres and their use.

In this talk, which is divided into two parts, first, we will discuss the directory structure created i.e. $PGDATA. All the data and files needed for a database server resides into the data directory. Also, we will have a quick glance over the overall directory structure and various configuration and control files. In the second part, we will have a look over all startup processes which are forked at database server starts including walwritter, autovacuum launcher, stats collector etc. We will also discuss the role and importance of these processes.

Date:
2019 February 14 - 14:45
Duration:
45 min
Room:
Ballroom 3
Conference:
PGConf India, 2019
Language:
Track:
Database Administration
Difficulty:
Beginner

Happening at the same time:

  1. Divide and Conquer data:- Advanced Methods for partitioning and sharding data - Latest developments
  2. Start Time:
    2019 February 14 14:45

    Room:
    Ballroom 4

  3. Restore your backups!
  4. Start Time:
    2019 February 14 14:45

    Room:
    Ballroom 1