Search
 
SCRIPT & CODE EXAMPLE
 

SQL

psql fatal database does not exist

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

psql -U Username DatabaseName 
Comment

psql: error: FATAL: database "odoo" does not exist

# if your database is different as your login name you must add the database name
psql -U Username DatabaseName 
Comment

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
Comment

PREVIOUS NEXT
Code Example
Sql :: union and union all 
Sql :: how to find constraints on a table in oracle 
Sql :: distance calculator from lat long sql query 
Sql :: oracle select partition 
Sql :: sql select merge multiple values 
Sql :: convert sql query to laravel eloquent 
Sql :: condition in orderby mysql 
Sql :: sql first day quarter 
Sql :: backup table mssql 
Sql :: row over partition in sql 
Sql :: mask data in sql 
Sql :: sql query made by rahuldev 
Sql :: Apache Derby: Create SQL Dump with data 
Csharp :: asp.net data annotations email 
Csharp :: unity if in editor 
Csharp :: unity how to convert mouse screen position to world position 
Csharp :: loop over object properties c# 
Csharp :: open scene unity 
Csharp :: object spin unity 
Csharp :: c# check file exists 
Csharp :: unity createassetmenu 
Csharp :: c# get unix timespan 
Csharp :: how to get the startup path in console app 
Csharp :: initialise icollection c# 
Csharp :: stream to byte array c# 
Csharp :: unity script detect if in prefab edition mode 
Csharp :: string to enum c# 
Csharp :: c# replace string case insensitive 
Csharp :: #region in c# 
Csharp :: c# wpf keyinput DeadCharProcessed 
ADD CONTENT
Topic
Content
Source link
Name
5+7 =