Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # How to install PostgreSQL on Ubuntu
- https://www.linuxcapable.com/how-to-install-postgresql-on-ubuntu-22-04-lts/
- #Install_PostgreSQL
- https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-22-04
- # How To Change The Password of a PostgreSQL User
- https://www.postgresqltutorial.com/postgresql-administration/postgresql-change-password/
- # Install pgAdmin 4 (APT)
- https://www.pgadmin.org/download/pgadmin-4-apt/
- sudo apt update
- sudo apt install postgresql postgresql-contrib
- sudo systemctl start postgresql.service
- systemctl status postgresql
- # Configure UFW Firewall
- sudo ufw enable
- sudo ufw allow proto tcp from 192.168.1.0/24 to any port 5432
- # Create User & Database
- sudo su - postgres -c "createuser <name>"
- sudo su - postgres -c "createdb <namedb>"
- sudo -i -u postgres
- psql
- ALTER ROLE <username> WITH PASSWORD <'password'>;
Add Comment
Please, Sign In to add comment