Below are the steps for enabling archive mode or wal archiving in postgres. STEPS TO ENABLE ARCHIVE MODE IN POSTGRES: 1. Check archive setting in the postgres config file: postgres=# select name,setting from pg_settings where name like ‘archive%’ ; name | setting ————————-+———— archive_cleanup_command | archive_command | (disabled) archive_mode | off — >>> archive_timeout | […]

Creating a database in postgres is very easy and it takes just few seconds. create database command is used to create the database.In this tutorial we will show different option with create database command.   NOTE – > When we install and initialise postgres cluster, by default two template database will be created, one is […]

1. Main content of this paper PostgreSQL 12 installation PostgreSQL 12 basic configuration PostgreSQL 12 remote access configuration PostgreSQL basic management 2. Environmental information and scope of application Environmental information Software Edition CentOS 7.6 Release PostgreSQL 12.x Scope of application Software Edition CentOS CentOS 7.x PostgreSQL 9.x-12.x 2、 PostgreSQL installation 1. Import Yum source sudo […]