DockerGDL Meetup Demo

DockerGDL Demo

docker search postgres
docker pull postgres

docker images
docker ps -a

docker run -e POSTGRES_PASSWORD=changeme -d postgres
docker log -f {name}
docker inspect {name} | less

#docker run -it --rm jbergknoff/postgresql-client postgresql://postgres:changeme@localhost:5432
#docker run -d --rm jbergknoff/postgresql-client postgresql://postgres:changeme@localhost:5432
#docker load < path_to_postgresql-client

# SQL Part ---------------------------------------
  CREATE TABLE users (
  	id integer,
  	name varchar(200),
  	nick varchar(200)
  );
  commit;
  
  INSERT INTO public.users (id, name, nick)
  VALUES (100, 'Isaias', 'IAX');
  
  SELECT *
    FROM users;
  
  commit;
# END SQL part -----------------------------------

# PSQL Commands
$ psql -h localhost -p 5432 -U postgres postgres
> \l
> \dt

# Explain actual problems
# - Container name, changing IP, Data

# Recover data
docker diff {name}
docker cp {name}:/var/lib/postgresql/data .

docker rm -f {name} <--- DELETE

# run the container to show that data is lost
docker run -d --name mydb -p 5432:5432 -e POSTGRES_PASSWORD=changeme postgres

# running the container again with a volume to load/preserve the database data
docker run -d --name mydb -v ~/Documents/data/:/var/lib/postgresql/data -p 5432:5432 -e POSTGRES_PASSWORD=changeme postgres