If you define the
sourceType property as
empty you will be able to create a Data Image that is completely empty, with no content on it.
In this case we want to create a PostgreSQL Data Image whose source is
empty and is named
In this tutorial we will create an
empty Data Image and then use it to create a Data Container. We will then inspect the Data Container.
Create a file
development.yamlwith your Data Image specifications.sourceType: emptyname: devengine: postgresqlversion: 11.0
Run the following command to create a Data Image.$ spawnctl create data-image -f ./development.yamlData image 'dev' created!
You can verify your Data Image by running the following command.$ spawnctl get data-imagesNAME IMAGE ID ENGINE STATUS MESSAGE CREATEDdev 10001 PostgreSQL 2 Created 2 minutes ago
Create a Data Container from the newly created Data Image.$ spawnctl create data-container --image devData container 'dev-rambbomj' created!-> Host=instances.spawn.cc;Port=53223;User ID=<some_user_id>;Password=<some_password>;
You can verify your Data Container was properly created by running the following command.$ spawnctl get data-containersNAME CONTAINER ID REVISION STATUS MESSAGE ENGINE CREATEDdev-rambbomj 10001 rev.0 2 Running PostgreSQL 1 minute ago
You should now be able to connect to your database and execute queries.
In this example we connect to the PostgreSQL Data Container (database) using psql.$ psql -h instances.spawn.cc -p 53223 -U <some_user_id>Password for user <some_user_id>:psql (10.5, server 11.0 (Debian 11.0-1.pgdg90+2))SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)Type "help" for help.<some_user_id>=# \dtDid not find any relations.
Notice the create database or Data Container has no tables on it.