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.
|
|
#!/bin/sh
# Run `postgres` container named `postgres` in docker network `localnet` # Create a network, if not exists: `docker network create localnet`
docker run --name postgres -d -p 5432:5432 --network localnet \
-e POSTGRES_USER=odoo_user \
-e POSTGRES_PASSWORD=odoo_password \
-e POSTGRES_DB=odoo \
postgres:latest
# Login to pg cli PGPASSWORD=postgres psql -h 127.0.0.1 -U postgres -p 5432
# Create user called 'odoo_user' CREATE ROLE odoo_user with LOGIN \password odoo_user # Enter a password, such as: odoo_password, which is an extremely bad password btw.
# Recreate database quickly. drop database odoo; create database odoo with encoding 'utf-8' owner odoo_user;
# Try logging in as odoo_user PGPASSWORD=odoo_password psql -h 172.17.0.1 -p 5432 -U odoo_user -d odoo
|