# HG changeset patch # User Oleksandr Gavenko # Date 1428047839 -10800 # Node ID f34c6bc973cb45aa79beeffb7b4de1a966d1425c # Parent f1924a82b2462359aed4ef49a30f2ef1a2ef793f Create local host superuser. diff -r f1924a82b246 -r f34c6bc973cb postgre.rst --- a/postgre.rst Fri Apr 03 10:05:03 2015 +0300 +++ b/postgre.rst Fri Apr 03 10:57:19 2015 +0300 @@ -23,6 +23,13 @@ $ su - mypguser $ psql mypgdatabase +In order to create local host superuser:: + + $ sudo su - postgres + $ createuser --superuser USER + $ exit + $ sudo -u USER psql + .. https://wiki.debian.org/PostgreSql @@ -33,7 +40,7 @@ Default database is ``postgres``. -To list databases:: +To list databases and database locales:: $ psql -U pgadmin -l