Create a weather station inside a Martha using a RaspberryPi
First connect to default postgres user:
sudo -u posgres psql
Then add first real user:
CREATE USER XXX WITH PASSWORD 'YYY';
Create new database:
CREATE DATABASE ZZZ;
Add priviledges to user:
GRANT ALL PRIVILEGES ON DATABASE ZZZ TO XXX;