PostgreSQL

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

psql -c "ALTER USER usuario WITH PASSWORD 'nueva_password'"


#> en postgres ruby
apt install libpq-dev
gem install pg


#> en django python
pip install psycopg2-binary

# ------------------------------_

#Cuando se actualiza postgres y aparece este tipo de errores
```
WARNING:  database "reviews_main3" has a collation version mismatch
DETAIL:  The database was created using collation version 2.38, but the operating system provides version 2.39.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE reviews_main3 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
```

sudo -u postgres psql
\c reviews_main3
ALTER DATABASE reviews_main3 REFRESH COLLATION VERSION;
\q

CREATE USER heber SUPERUSER;
ALTER USER heber WITH PASSWORD 'heber';

ALTER USER tournament WITH PASSWORD 'dosber/2023';