我尝试创建一个POSTGRES数据库映像,其中所有数据库和模式都在启动时初始化,如下所示:
version: '3.8'
services:
iamstorepg:
image: library/postgres:10
environment:
- POSTGRES_DB=pgiam
- POSTGRES_USER=iam
- POSTGRES_PASSWORD=iam
ports:
- 5432:5432
restart: always
volumes:
- "./schema1.sql:/docker-entrypoint-initdb.d/1-schema.sql"
- "./schema2-db.sql:/docker-entrypoint-initdb.d/2-schema.sql"
在这里,在第二个SQL文件中,我尝试创建另一个DB,并使用所有需要的表初始化它,如下所示,
CREATE DATABASE DB1
WITH
OWNER = iam
ENCODING = 'UTF8'
CONNECTION LIMIT = -1;
GRANT ALL PRIVILEGES ON DATABASE DB1 to iam;
/*\connect DB1;
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO iam;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO iam;*/
---
-- Drop table
DROP TABLE IF exists DB1.public.user_involvements;
----- New proposition user-rol -> role-resource relationship one to many
-- Create User-roles table (authorisations or involvements , however you would like to call it)
CREATE TABLE pgiamrolestore.public.tb1(
id uuid NOT NULL,
path varchar(255) NOT NULL,
code varchar(255) not null,
is_active bool NOT null default true
);
这里的问题是,即使第二个数据库正在创建,我不能指定表中,这个表TB1正在创建第一个数据库'PGIAM'。有什么办法可以解决这个问题?
1条答案
按热度按时间xytpbqjk1#
我将sql文件更改为shell,可以运行\c命令切换数据库,如下所示,