Pull this repo down to set up a safe experimentation environment for Postgres. This uses docker-compose with a local directory to make an ephemeral postgres instance available for experimentation and testing. It also includes pgAdmin for exploration and other situations where a GUI is preferable.
Prerequisites: The only prerequisite should be that docker is installed on your machine.
- Clone this repo into a local project folder.
git clone git@github.com:aeschylus/db-sandbox.git - To start the postgres and pdAdmin servers,
cdinto the project directory and rundocker-compose upin the command line. - You can connect to the postgres container's shell by running
docker exec -it db-sandbox-postgres sh. This will present a new command prompt, indicating that you are now inside the container that houses the postgres instance. - Once inside the container, run
psql pg_defaultto use postgres. You may now create a new database, for example.
Data is stored in the postgres-data directory of this project. Periodically copy this directory elsewhere if you need to keep the results.
When you are done developing cd into the root project directory (the one this README is in) and run docker compose down
You can check (or locally change) the settings for the db in the docker-compose.yml file.
The sandbox includes pgAdmin4 pre-configured to connect to the database. Visit localhost:5050 to open the dashboard. A dummy admin account has been pre-configured. The "email" is admin@admin.com and the password is root. You may be asked for the password to connect to postgres. The password for that is also root.
The connection details are included in the docker-compose.yml file as environment variables. The password for the postgres user is root and the user is root. Naturally this is only appropriate for local experimentation.