Connect to Postgres and create a test database (your prompt will change):

docker exec -it postgres-dev bash;

psql -U postgres;

CREATE DATABASE testdb;

Now connect to the database and insert some sample data:

\c testdb;

CREATE TABLE FRUIT( ID INT PRIMARY KEY NOT NULL, INVENTORY CHAR(25) NOT NULL, QUANTITY INT NOT NULL );

INSERT INTO FRUIT (ID,INVENTORY,QUANTITY) VALUES (1, 'Bananas', 132), (2, 'Apples', 165), (3, 'Oranges', 219);

Check your commands succeeded:

SELECT * FROM FRUIT;

Quit the Postgres container:

\q

exit

Now, let's check that the data was persisted and is accessible on another node.

Start by removing the Postgres container: docker kill postgres-dev

Switch to another node with ssh [email protected] and start a new Postgres instance with pgdata mounted:

docker run -d --name postgres-dev -v pgdata:/var/lib/postgresql/data --volume-driver=storageos -e POSTGRES_PASSWORD=storageos -e PGDATA=/var/lib/postgresql/data/pgdata postgres

Connect to your test database:

docker exec -it postgres-dev bash

psql -U postgres

\c testdb

Insert more data, then check that there are four records in the table:

INSERT INTO FRUIT (ID,INVENTORY,QUANTITY) VALUES (4, 'Peaches', 203);

SELECT * FROM FRUIT;