Docker postgres create database12/7/2023 ![]() ![]() Sending build context to Docker daemon 4.096kB Postgres latest 4b52913b0a3a 8 days ago 313MBĭocker run -name 683dd2ba4015 -p 5432:5432 -v /opt/import1:/docker-entrypoint-initdb.d/ -e POSTGRES_HOST_AUTH_METHOD=trust -d docker psĬONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMESĥ3a6f7972b91 postgres "docker-entrypoint.s…" 6 minutes ago Up 6 minutes 0.0.0.0:5432->5432/tcp 683dd2ba4015įull logs for your reference, cat Dockerfileįrom docker build -tag sathyadev/postgres:0.1. Sathyadev/postgres latest 683dd2ba4015 About an hour ago 313MB create a directory in your local and mount with docker as -v /opt/import1:/docker-entrypoint-initdb.d/Ĭat /opt/import/setup.sql cat /opt/import1/setup.sqlĬREATE TABLE my_app_db.access_master ("ACCESS_ID" character varying COLLATE pg_catalog."default" NOT NULL,"ROLE_ID" character varying COLLATE cat Dockerfile. ![]() "ROLE_ID" character varying COLLATE pg_catalog."default" ![]() 08:49:25.794 UTC LOG: database system is ready to accept connections 08:49:25.789 UTC LOG: database system was shut down at 08:49:25 UTC PostgreSQL init process complete ready for start up. 08:49:25.675 UTC LOG: database system is shut down 08:49:25.657 UTC LOG: background worker "logical replication launcher" (PID 53) exited with exit code 1 08:49:25.656 UTC LOG: aborting any active transactions 08:49:25.654 UTC LOG: received fast shutdown request usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/imcsysdb.sql 08:49:25.433 UTC LOG: database system is ready to accept connections My container logs : 08:49:25.428 UTC LOG: database system was shut down at 08:49:25 UTC "ROLE_ID" character varying COLLATE pg_catalog."default",Ībove script helping to create Database but not schema/tables. "ACCESS_ID" character varying COLLATE pg_catalog."default" NOT NULL, sql file into docker entrypoint.ĬOPY my-app-db-ddl.sql /docker-entrypoint-initdb.d/ĭDL file contents: CREATE SCHEMA MY_APP_DB When container gets launched, I also want the schema and tables to be created in it. I am trying to launch a postgres database container. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |