Psql fatal database does not exist

# So you do not have to create a database with your role name

psql -U Username DatabaseName

Source: stackoverflow.com

Psql database does not exist

It appears that your package manager failed to create the database named $user for you. The reason that

psql -d template1

works for you is that template1 is a database created by postgres itself, and is present on all installations. You are apparently able to log in to template1, so you must have some rights assigned to you by the database. Try this at a shell prompt:

createdb
and then see if you can log in again with

psql -h localhost

Fatal database postgres does not exist

psql -d template1

Source: stackoverflow.com

Similar codes

3 votes103 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote110 views1 answer
Delete duplicate rows
SQL
4 votes107 views1 answer
Sql quote in string
SQL
1 vote129 views1 answer
Mysql select all and rename one
SQL
3 votes53 views2 answers
Mysql sum with condition
SQL
1 vote107 views1 answer
Get create table query existing table mysql
SQL
6 votes102 views2 answers
Psql load dump
SQL
1 vote99 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote103 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote120 views1 answer
Command to give readonly access to a postgres sql user
SQL