PostgreSQL – How to Create Database

To create a new database in PostgreSQL, you can use the CREATE DATABASE statement. Here is the basic syntax for this statement:

Replace database_name with the name of the database that you want to create. For example, to create a database named my_database, you would use the following statement:

This will create a new database with the specified name. You can then connect to the database and start creating tables, indexes, and other database objects within it.

How to set up Streaming Replication in Postgres

To set up streaming replication in PostgreSQL, you need to perform the following steps:

  1. Set up the master server and the standby server. The master server is the primary server that will receive all the write operations, while the standby server will receive a copy of all the changes made on the master server and will be used for failover in case the master server becomes unavailable.
  2. On the master server, edit the postgresql.conf configuration file and set the wal_level parameter to hot_standby. This will enable the master server to keep a sufficient amount of transaction log data (WAL) to allow the standby server to connect and apply the changes.
  3. Restart the master server for the changes to take effect.
  4. On the standby server, edit the postgresql.conf configuration file and set the hot_standby parameter to on. This will enable the standby server to connect to the master server and start receiving the changes.
  5. In the recovery.conf file on the standby server, add the following lines to specify the connection details for the master server:
Continue reading “How to set up Streaming Replication in Postgres”

Vacuuming in PostgreSQL

Is Vacuuming important in Postgresql

PostgreSQL is a database management system, and as such, vacuuming is an important maintenance task to help keep the database running efficiently. Vacuuming helps to clean up dead tuples (rows that have been deleted or obsoleted) and free up space on the database, which can help to improve performance and prevent the database from becoming bloated or fragmented. It’s generally recommended to vacuum a PostgreSQL database regularly to help maintain its health and performance.

Continue reading “Vacuuming in PostgreSQL”