PostgreSQL/PgLoader

From Chorke Wiki
Revision as of 06:35, 3 December 2024 by Shahed (talk | contribs) (→‎Playground)
Jump to navigation Jump to search
cat << EXE | sudo bash
apt-get update;echo
apt list -a --upgradable
apt-get install -y pgloader
EXE

Migration

cat << DDL | mysql
CREATE DATABASE IF NOT EXISTS academia;
CREATE USER 'chorke'@'%' IDENTIFIED BY 'sadaqah!';
GRANT ALL PRIVILEGES ON academia.* TO 'chorke'@'%';
FLUSH PRIVILEGES;
DDL

Playground

pgloader -h
pgloader -V

References