Public Repository

Last pushed: 3 years ago
Short Description
1C PostgreSQL
Full Description

Container for Postgres 1C version

PostgreSQL with 1C patch

Supports tags

Run

To run container with fix volume name use:

docker run -d -p 5432:5432 -v /path/on/host/1c_postgres_data:/var/lib/postgresql/data --name 1c_postgres --restart=always temrdm/1c_postgres:9.2-1C

Config

Set password for role postgres:

psql -h localhost -U postgres -c "alter user postgres with password 'password';"

Create 1c database admin role:

createuser -dP -h localhost -U postgres <username>

Create default user database:

psql -h localhost -U postgres -c "create database <username> with owner <username>;"

Change postgres auth method:

docker exec -it 1c_postgres /bin/bash
cat > "$PGDATA"/pg_hba.conf <<EOS
# TYPE  DATABASE    USER    ADDRESS         METHOD
local   all         all                     trust
host    all         all     127.0.0.1/32    trust
host    all         all     ::1/128         trust
host    all         all     0.0.0.0/0       md5
EOS

Restart postgres:

docker restart 1c_postgres
Docker Pull Command
Owner
temrdm