You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

25 lines
791 B

2 years ago
  1. #!/bin/sh
  2. # Run `postgres` container named `postgres` in docker network `localnet`
  3. # Create a network, if not exists: `docker network create localnet`
  4. docker run --name postgres -d -p 5432:5432 --network localnet \
  5. -e POSTGRES_USER=odoo_user \
  6. -e POSTGRES_PASSWORD=odoo_password \
  7. -e POSTGRES_DB=odoo \
  8. postgres:latest
  9. # Login to pg cli
  10. PGPASSWORD=postgres psql -h 127.0.0.1 -U postgres -p 5432
  11. # Create user called 'odoo_user'
  12. CREATE ROLE odoo_user with LOGIN
  13. \password odoo_user
  14. # Enter a password, such as: odoo_password, which is an extremely bad password btw.
  15. # Recreate database quickly.
  16. drop database odoo;
  17. create database odoo with encoding 'utf-8' owner odoo_user;
  18. # Try logging in as odoo_user
  19. PGPASSWORD=odoo_password psql -h 172.17.0.1 -p 5432 -U odoo_user -d odoo