Create multiple database READonly users for different cluster

[JonhSilver]

I have 15 Postgres 9.6 version clusters runned on different port on same ip, each cluster has near 150 databases

How automatically create read only user for each database on each cluster, using one prefix and cluster and database name as UserName (pref_Cluster1_Db1, pref__Cluster1_Db2 .. pref__Cluster1_Db235) with generate strong password for each user, excluding some db names

And as result create list of username:pass

[wglambert]

You can make a script that will run when the database is being initialized https://github.com/docker-library/docs/tree/master/postgres#initialization-scripts

For help with that I'd try asking over at the Docker Community Forums, Docker Community Slack, or Stack Overflow. Since these repos aren't really a user-help forum

[JonhSilver]

i dont have docker, and dont need it, just want sh script

[wglambert]

Oh, it's pretty neat you should give it a whirl.
But since this repo is for the Docker image of Postgres it's not the right place for questions on scripts or using Postgres itself (rather, for issues related to the way it's packaged into a container format)