Verify your knowledge

• What is the pg_ctl command?

  pg_ctl is a command shipped with PostgreSQL that allows you to start, restart, stop, and do other actions on the cluster. It is often used as the way to manage the whole cluster. See the pg_ctl section for more details.

• What is a template database?

  A template database is a database that can be used as a base to clone another (new) database that will initially include the same objects. See the The template databases section for more details.

• What is the psql command?

  psql is the official client application to connect to a PostgreSQL database. It is a command - line application that can be used to enter SQL statements and get results out of the cluster. It is shipped with every version of PostgreSQL. See the The psql command-line client section for more details.

• What is a connection string?

  A connection string is a URI that specifies all the properties required to connect to a database, often including the username, the host, the database, and so on. See the The connection string scction for more details.

• What are the psql special commands?

  The special commands are all the short commands that begin with a backslash symbol, like, for example, \d. They are informative commands valid only within the psql client. See the A glance at the psql commands section for more details.