author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Fri, 03 Apr 2015 10:57:19 +0300 | |
changeset 1709 | f34c6bc973cb |
parent 1708 | f1924a82b246 |
child 1710 | 601c31753686 |
postgre.rst | file | annotate | diff | comparison | revisions |
--- 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