September 2, 2018 | In: Programovanie
Postgresql pridanie usera
Pred spustenim servera, treba zmenit ownera na subore : server.key
chown postgres.postgres /var/lib/postgresql/8.4/main/server.key
V novsich verziach to mozno netreba.
potom prihlasit sa na psql
1. su – postgres
psql
vytvorenie noveho superuser
CREATE ROLE mysuperuser2 WITH SUPERUSER CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD ‘mysuperpass2’; // heslo musi byt v uvodzovkach
a potom sa da zvysok upravit v pgadmine
Comments are closed.