I have a PostgreSQL server with several databases running on it. One of the databases is called
postgres, and it was there right from the beginning. I could not see any tables inside and I've never used it explicitly, but I noticed, that any user is allowed to create tables within the database (this is not what I want - I do not want any users except the administrator to create any tables anywhere).
I have a feeling that it is some kind of a special database that is required for a normal operation of the server, but what is exactly its purpose? What kind of data is (or could be) stored inside? Does it hold the metadata about other databases (e.g. the
information_schema?). Can something nasty happen, if I revoke
connect privilege to this database from public? Or if I even drop it?
I googled for half an hour, but always got completely unrelated stuff, because the word
postgres is also used for the user
postgres and the DBMS itself.