Automatically create database about postgres HOT 8 CLOSED

Isn't this going to be application specific, especially since most apps will have some default schema and stuff to push in, too?

from postgres.

It's useful for the case where an application expects a database to exist and automatically populates it with tables.

from postgres.

The initdb that is run in the entrypoint when starting postgres automatically creates a postgres database. Here is what I find via psql:

postgres=# \l
                             List of databases
   Name    |  Owner   | Encoding  | Collate | Ctype |   Access privileges   
-----------+----------+-----------+---------+-------+-----------------------
 postgres  | postgres | SQL_ASCII | C       | C     | 
 template0 | postgres | SQL_ASCII | C       | C     | =c/postgres          +
           |          |           |         |       | postgres=CTc/postgres
 template1 | postgres | SQL_ASCII | C       | C     | =c/postgres          +
           |          |           |         |       | postgres=CTc/postgres
(3 rows)

Does it need more than this? This is exactly what is there by default on a normal apt-get install postgresql. We tell it not to do the initdb so it can be done in the entrypoint (after any volume mounts).

from postgres.

Oh, cool. Is the "postgres" database empty and usable for user data?

from postgres.

No relations found. All the system data is in pg_catalogue.

from postgres.

Perfect! Could we make clear in the description that there is a user postgres without auth and a database postgres that can be used for user data?

from postgres.

Yes, we are working to make the docker hub descriptions part of the git, so that it is easier to update (with a PR). I will add it to our list to update it.

from postgres.

Perfect. Thanks @yosifkit!

from postgres.