You have created a database user named edbuser with password 'password'. Which command grants connection rights to the edbstore database for user edbuser?
Which parameter specifies the number of connections reserved for superusers in PostgreSQL?
You are working as a Postgres DBA. Due to an increase in transactional load on your Postgres instance, the server is experiencing frequent checkpoints. You have decided to increase the WAL area size. You have also decided to upgrade your database instance to PostgreSQL 13. While initializing your database cluster in PostgreSQL 13, you have decided to increase the WAL segment size. Which of the following options can be used with the initdb command to set a custom WAL segment size?
You want to reload the PostgreSQL configuration without restarting the server. Which function should you execute?
Which PostgreSQL backup utility can create backups in custom compressed format?