su postgres
psql
CREATE ROLE xxxx WITH LOGIN ENCRYPTED PASSWORD 'xxxxx';
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO ahmed;
ALTER USER ahmed WITH SUPERUSER;
# TYPE DATABASE USER ADDRESS METHOD
local all user md5
host all all 127.0.0.1/32 md5
host all all ip address/32 md5
host all all ::1/126 md5