The PostgreSQL object-relational database system provides reliability and data integrity
2.3K
The PostgreSQL object-relational database system provides reliability and data integrity
⚠️ This project is no longer maintained. ⚠️
# Define installation folder
export INSTALL_DIRECTORY=/usr/bin
# Use local installation
sudo bin/installer install
# Use remote installation
curl --location "https://gitlab.com/timonier/postgresql/raw/master/bin/installer" | sudo sh -s -- install
Note 1: If you do not define INSTALL_DIRECTORY, installer will use in /usr/local/bin.
Note 2: docker-for-mac users have to configure native NFS server.
Run the command pg_dump:
# See all pg_dump options
pg_dump --help
# Run pg_dump
export PGHOST=postgresql-morgan.docker
export PGPASSWORD=my-super-password
export PGUSER=postgres
pg_dump api --blobs --data-only --disable-triggers --file backup.sql
Run the command psql:
# See all psql options
psql --help
# Run psql
export PGHOST=postgresql-morgan.docker
export PGPASSWORD=my-super-password
export PGUSER=postgres
psql --file backup.sql api
docker pull timonier/postgresql