Skip to content

Latest commit

 

History

History
56 lines (40 loc) · 1.4 KB

README.md

File metadata and controls

56 lines (40 loc) · 1.4 KB
Raw

PostgreSQL Schema for Testing

What

Contains various psotgresql schemas, with a way to deploy all of them in a single postgresql docker container locally.

Purpose

This is just a combination of random schemas, which are perfect for your performance, load, or any other testing you may have with Postgresql instance. Some most notable things in here:

  • Pagila
  • AdventureWorks (caveat: schema only, no data)
  • Table with 1600 columns (max in PostgreSQL)
  • Schema with > 100 tables

How to use

## Clone the repo
git clone [email protected]:Navusas/postgres-test-schema.git
cd postgres-test-schema/

## Use docker-compose
docker-compose up

Connect using this connection string:

Host=localhost;Port=5432;Database=postgres;Username=postgres;Password=123456

Alternatively, you can run it using Docker:

## Clone the repo
git clone [email protected]:Navusas/postgres-test-schema.git
cd postgres-test-schema/

# Create volume
docker volume create pgdata
# Run container
docker run -d --name pagila \
       -v $(pwd):/docker-entrypoint-initdb.d/ \
       -v pgdata:/var/lib/postgresql/data \
       -p 5432:5432 \
       -e POSTGRES_PASSWORD=123456 \
       -e POSTGRES_USER=postgres \
       postgres:13.2

Mentions