Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- wangalex1@ubuntu:~$ scp /home/wangalex1/Downloads/zen.dump admin@84.201.162.218:zen.dump 100% 7145KB 2.2MB/s 00:03
- wangalex1@ubuntu:~$ ssh admin@84.201.162.218
- Welcome to Ubuntu 18.04.3 LTS (GNU/Linux 4.15.0-55-generic x86_64)
- * Documentation: https://help.ubuntu.com
- * Management: https://landscape.canonical.com
- * Support: https://ubuntu.com/advantage
- * Overheard at KubeCon: "microk8s.status just blew my mind".
- https://microk8s.io/docs/commands#microk8s.status
- * Canonical Livepatch is available for installation.
- - Reduce system reboots and improve kernel security. Activate at:
- https://ubuntu.com/livepatch
- Last login: Sun Dec 15 17:12:10 2019 from 128.68.154.145
- admin@automation-test1:~$ createdb zen --encoding='utf-8'
- createdb: could not connect to database template1: FATAL: role "admin" does not exist
- admin@automation-test1:~$ sudo -u postgres psql;
- psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1))
- Type "help" for help.
- postgres=# createdb zen --encoding='utf-8'
- postgres-# \c zen
- You are now connected to database "zen" as user "postgres".
- zen-# pg_restore -d zen zen.dump
- zen-# \q
- admin@automation-test1:~$ sudo -u postgres psql;
- psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1))
- Type "help" for help.
- postgres=# pg_restore -d zen zen.dump
- postgres-# \l
- postgres-# \c zen
- You are now connected to database "zen" as user "postgres".
- zen-# \dt
- Did not find any relations.
- zen-# \d
- Did not find any relations.
- zen-#
Add Comment
Please, Sign In to add comment