PostgreSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 49: | Line 49: | ||
grant all privileges on database postgres to root; | grant all privileges on database postgres to root; | ||
# GRANT | # GRANT | ||
</syntaxhighlight> | |||
== Logout PSQL == | |||
<syntaxhighlight lang="bash"> | |||
# postgres=# | |||
\q | |||
# -bash-4.2$ | |||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 21:01, 15 April 2018
Login to Postgres
# [email protected]:~ #
su - postgres
# Last login: Tue Jan 01 12:00:00 MYT 2013 on pts/0
# -bash-4.2$
psql
# psql (9.6.8)
# Type "help" for help.
#
# postgres=#
Login Error
# [email protected]:~ #
su - postgres psql
# Last login: Tue Jan 01 12:00:00 MYT 2013 on pts/0
# /bin/createuser: /bin/createuser: cannot execute binary file
Creating User
# [email protected]:~ #
su - postgres
# Last login: Tue Jan 01 12:00:00 MYT 2013 on pts/0
# -bash-4.2$
createuser root
# createuser: creation of new role failed: ERROR: role "root" already exists
Creating Database
Until creating root database it's always show error could not change directory to "/root": Permission denied. To overcome this error we should need to create a root database. only for avoid error while login using root user.
# [email protected]:~ #
su - postgres
# Last login: Tue Jan 01 12:00:00 MYT 2013 on pts/0
# -bash-4.2$
createdb root
Grant Privileges
# postgres=#
grant all privileges on database root to root;
# GRANT
# postgres=#
grant all privileges on database postgres to root;
# GRANT
Logout PSQL
# postgres=#
\q
# -bash-4.2$