DROP SCHEMA public CASCADE; CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO public; PGPASSWORD='password' pg_dumpall \ --host=pgsql \ --port=5432 \ --username=sail \ --clean \ --if-exists \ --file=pgsql-full.sql PGPASSWORD='password' psql \ --host=pgsql \ --port=5432 \ --username=sail \ --dbname=postgres \ --file=pgsql-full.sql