On a UNIX system, what is the best way to prevent all non-local connections to the postmaster?

After a PostgreSQL installation, how will you create the database cluster?

How will you change the TCP port which PostgreSQL will listen to?

What is the name of the special time input with value 00:00:00.00 UTC?

While creating a table with a field of the serial type, a sequence will be created.

How do you alter a column to forbid null values?

Which of the following statements will create a table special_products which is a child of the table store_products?

How will you rank text search results?

If max_connections is 10 and 10 connections are currently active, how can you be sure the superuser will be available to connect?

Which of the following statements will create a table with a multidimensional array as second column?

Consider the following empty table:

CREATE TABLE example (

    a integer,

    b integer,

    c integer,

    UNIQUE (a, c)

);

Which of the following inserts will cause an error?