Postgresql: Difference between revisions

From DWIKI
Line 37: Line 37:


==List users==
==List users==
su to postgres, psql and then \du
su to postgres, psql and then  
\du
 
 
==Delete user==
drop user

Revision as of 12:08, 10 May 2019

Links

Installation

Postgresql on freebsd


(pg_ctl: could not read file "/usr/local/pgsql/data/postmaster.opts") : After installing and creating db: As user pgsql

/usr/local/bin/postmaster -D /usr/local/pgsql/data
pg_ctl stop

Ater which it should be possible to run ( as root again)

/usr/local/etc/rc.d/postgresql start

FAQ

Create user

su - postgres
createuser


or in psql:

CREATE DATABASE yourdbname
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass'
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser

ERROR: character 'xxx' of encoding "UTF8" has no equivalent in "LATIN9" locale

Check

show server_encoding
show client_encoding
\encoding

List users

su to postgres, psql and then

\du


Delete user

drop user