Postgre Tutorial advanced
sudo apt update sudo apt install postgresql postgresql-contrib sudo -i -u postgres psql Create user CREATE USER sandy WITH PASSWORD yourpassword; \du ===========gran access ALTER USER sandy WITH SUPERUSER; ===========create db CREATE DATABASE books ; ===========set db to user GRANT ALL PRIVILEGES ON DATABASE " books " to sandy ; \du ==========Login db psql -h localhost -d dbname -U userdb -p 5432 Export pg_dump -U sandy -h localhost -p 5432 books > books130622.sql Import psql -U sandy -h localhost -p 5432 books < books130622.sql