--open terminal
CTRL + ALT + T
--access root
sudo su -
--install postgres
apt-get install postgresql postgresql-contrib
--configure postgres to start upon server boot
update-rc.d postgresql enable
--install pgadmin
sudo apt-get install pgadmin4
--start postgres
service postgresql start
--set password
sudo su -
psql
alter user postgres with password 'xxx'
--open pgadmin
--right click servers -> create -> server
--gereral -> name: localhost
--connection -> address: 127.0.0.1 -> password: xxx
--save
reference:
https://www.youtube.com/watch?v=-LwI4HMR_Eg
https://www.godaddy.com/garage/how-to-install-postgresql-on-ubuntu-14-04/
https://www.liquidweb.com/kb/what-is-the-default-password-for-postgresql/
http://www.indjango.com/ubuntu-install-postgresql-and-pgadmin/
https://milq.github.io/useful-terminal-commands-ubuntu-debian/
Ctrl + Alt + H - show hidden files
https://www.howtogeek.com/howto/ubuntu/view-hidden-files-and-folders-in-ubuntu-file-browser/
No comments:
Post a Comment