PostgreSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 31: | Line 31: | ||
== Creating Database == | == Creating Database == | ||
Until creating '''root database''' it's always show error <code>could not change directory to "/root": Permission denied</code>. To overcome this error we should need to create a root database. only for avoid error while login using root user. | Until creating '''root database''' it's always show error <code>could not change directory to "/root": Permission denied</code>. To overcome this error we should need to create a '''root database'''. only for avoid error while login using '''root user'''. | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
# [email protected]:~ # | # [email protected]:~ # | ||
Revision as of 20:55, 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