Spaces:
Running
Running
| #!/bin/bash | |
| # PostgreSQL setup script | |
| sudo apt-get update | |
| sudo apt-get install -y postgresql postgresql-contrib | |
| # Create database and user | |
| sudo -u postgres psql <<EOF | |
| CREATE DATABASE mydb; | |
| CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypassword'; | |
| GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser; | |
| EOF | |