Running .sql files on docker-entrypoint dir

[chbrandt]

At docker-entrypoint:sh:88, shouldn't the username (for running the '.sql' scripts) be $POSTGRES_USER?

[md5]

@chbrandt Why did you close this? It seems like a valid question.

[chbrandt]

@md5 because POSTGRES_USER has the properties NOCREATEDB, NOCREATEROLE and NOREPLICATION, and for some reason I thought that would be necessary. But, in fact, it isn't since POSTGRES_USER is playing in its own db, POSTGRES_DB.
Since I'm newbie, at some point I thought I was wrong. Anyway, if I asked, I should wait some one to answer it...
[]

[md5]

@chbrandt Good point. Since $POSTGRES_USER is given SUPERUSER (if it isn't using the default user postgres), I suppose it would be possible to use that permission to give the user CREATEDB or any of the other permissions as needed in a *.sql file. Since the globbing in bash guarantees an order, it would be a simple matter to ensure that the script that grants those permissions would be run first based on a naming convention.