fix pgadmin container exit issue

[tonyqus]

Reference: https://stackoverflow.com/questions/65036797/pgadmin-container-kills-postgres-when-using-docker-compose

I always got the following error from pgadmin container and then exit code 1

'test@user' does not appear to be a valid email address. Please reset the PGADMIN_DEFAULT_EMAIL environment variable and try again.

• I also added a specific volume for pgadmin - pgadmindata.
• 8080 port is occupied in most cases (same on my box). I changed it to 5433.
• depends_on helps make sure pgadmin container starts after pg database container starts

[tonyqus]

while running pg_restore in the docker container, I always getting the following error even if I dropped schema public.

pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 3; 2615 2200 SCHEMA public postgres pg_restore: error: could not execute query: ERROR: schema "public" already exists Command was: CREATE SCHEMA public;

pg_restore: from TOC entry 2935; 0 0 ACL TABLE pg_stat_database postgres
pg_restore: error: could not execute query: ERROR: role "datadog" does not exist Command was: GRANT SELECT ON TABLE pg_catalog.pg_stat_database TO datadog;

pg_restore: warning: errors ignored on restore: 2

Looks it's better to specify the image tag of the postgresql. The behavior of different pg versions are different according to this post.

Question: which version of pg do you use to generate the dump file?

[bruno-garcia]

Question: which version of pg do you use to generate the dump file?

postgres 10 IIRC

[bruno-garcia]

Not sure what's going on but CI isn't running

[bruno-garcia]

CI doesn't really verify this file so merging