Advertisement
Guest User

Untitled

a guest
Feb 7th, 2017
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.54 KB | None | 0 0
  1. db:
  2. image: postgres:9.4
  3. ports:
  4. - 5432:5432
  5. environment:
  6. POSTGRES_PASSWORD: postgres
  7. POSTGRES_USER: postgres
  8. PGDATA : /var/lib/postgresql/data
  9. volumes:
  10. - /Users/ihorsamusenko/projects/own/docker_php/pgdata:/var/lib/postgresql/data
  11.  
  12. db_1 | initdb: directory "/var/lib/postgresql/data" exists but is not empty
  13. db_1 | If you want to create a new database system, either remove or empty
  14. db_1 | the directory "/var/lib/postgresql/data" or run initdb
  15. db_1 | with an argument other than "/var/lib/postgresql/data".
  16.  
  17. FROM postgres:9.4
  18. COPY pgdata /var/lib/postgresql/data
  19.  
  20. postgres9:
  21. image: postgres:9.4
  22. ports:
  23. - 5432:5432
  24. volumes_from:
  25. - pg_data
  26. environment:
  27. POSTGRES_PASSWORD: postgres
  28. POSTGRES_USER: postgres
  29. PGDATA : /var/lib/postgresql/data/pgdata
  30.  
  31. pg_data:
  32. image: alpine:latest
  33. volumes:
  34. - /var/lib/postgresql/data/pgdata
  35. command: "true"
  36.  
  37. version: '2'
  38.  
  39. services:
  40. postgres9:
  41. image: postgres:9.4
  42. expose:
  43. - 5432
  44. volumes:
  45. - data:/var/lib/postgresql/data
  46.  
  47. volumes:
  48. data: {}
  49.  
  50. $ docker-compose up
  51.  
  52. $ docker exec -it $(docker-compose ps -q postgres9 ) psql -Upostgres -c 'z'
  53.  
  54. $ docker exec -it $(docker-compose ps -q postgres9 ) psql -Upostgres -c 'create table beer()'
  55.  
  56. $ docker exec -it $(docker-compose ps -q postgres9 ) psql -Upostgres -c 'z'
  57.  
  58. Access privileges
  59. Schema | Name | Type | Access privileges | Column access privileges
  60. --------+-----------+-------+-------------------+--------------------------
  61. public | beer | table | |
  62.  
  63. $ docker-compose stop
  64.  
  65. $ docker-compose up
  66.  
  67. $ docker exec -it $(docker-compose ps -q postgres9 ) psql -Upostgres -c 'z'
  68. Access privileges
  69. Schema | Name | Type | Access privileges | Column access privileges
  70. --------+-----------+-------+-------------------+--------------------------
  71. public | beer | table | |
  72.  
  73. $ docker exec -it $(docker-compose ps -q postgres9 ) pg_dump -Upostgres > backup.sql
  74.  
  75. $ docker exec -it $(docker-compose ps -q postgres9 ) psql -Upostgres -c 'delete table beer'
  76.  
  77. $ docker exec -i $(docker-compose ps -q postgres9 ) psql -Upostgres < backup.sql
  78.  
  79. $ docker exec -it $(docker-compose ps -q postgres9 ) psql -Upostgres -c 'z'
  80. Access privileges
  81. Schema | Name | Type | Access privileges | Column access privileges
  82. --------+-----------+-------+-------------------+--------------------------
  83. public | beer | table | |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement