Skip to content

Latest commit

 

History

History
30 lines (18 loc) · 1.09 KB

create-user-db.md

File metadata and controls

30 lines (18 loc) · 1.09 KB
Raw

Create PostgreSQL users and databases

Command to create PostgreSQL users and correspondingly named databases.

Environment Configuration

Use --link <postgres container name>:postgres to automatically specify the required variables.

Or alternatively specify the individual variables:

  • DATABASE_HOST = IP / hostname of PostgreSQL server.
  • DATABASE_PORT = TCP Port of PostgreSQL service.
  • DATABASE_USER = Administrative user eg postgres with SUPERUSER privileges.
  • DATABASE_PASS = Password of administrative user.

Options

  • --no-create-database don't create database
  • <username> - required
  • <password> - option. If not specified then a random password will be generated.

Example Usage

Create foo user with full privileges to a database with the same name:

docker run --rm -i -t -e DATABASE_HOST=172.19.66.4 -e DATABASE_USER=root -e DATABASE_PASS=foo docker.io/panubo/postgres-toolbox create-user-db foo foopass

Using Docker links to postgres container:

docker run --rm -i -t --link myserver:postgres docker.io/panubo/postgres-toolbox create-user-db foo foopass