Created
April 24, 2013 01:05
-
-
Save davetapley/5448794 to your computer and use it in GitHub Desktop.
PostgreSQL roles issue on Ubuntu 10.04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
vagrant@heroku:~$ sudo su postgres | |
$ psql | |
psql (9.1.9) | |
Type "help" for help. | |
postgres=# SELECT rolname FROM pg_roles; | |
rolname | |
---------- | |
postgres | |
vagrant | |
(2 rows) | |
postgres=# \q | |
could not save history to file "/home/postgres/.psql_history": No such file or directory | |
$ | |
vagrant@heroku:~$ psql | |
psql: FATAL: database "vagrant" does not exist | |
Confirmed I have a DB for vagrant
:
postgres=# \list
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
vagrant | vagrant | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
pg_hba.conf
: