Verify your knowledge

• Do I have to configure the pg_hba.conf file before starting physical replication?

  Yes, you do.

  See the section Managing streaming replication for more details.

• Is it possible on PostgreSQL to make an asynchronous replication?

  Yes, it is possible; it’s the default configuration.

  See the section Managing streaming replication for more details.

• Is it possible on PostgreSQL to make a synchronous replication?

  Yes, it is possible, by modifying the postgresql.conf on the primary server and the postgresql.auto.conf on the replica server.

  See the section Synchronous replication for more details.

• Is it possible on PostgreSQL to make a cascading replication?

  Yes, it is possible, by using a pg_basebackup command that takes data from the replica server.

  See the section Cascading replication for more details.

• Is it possible to promote a...