CODEWITHSUNDEEP
npgsqlserenity-platform
ChampR
ChampR

Reputation: 782

PostgresException: 3D000: database "kap_dev" does not exist

I am using serenity with postgres and I have generated a new project using visual studio 2019.

I have followed the tutorial of how to make the app connect with Postgresql.

I have created a new database and user in PgAdmin.

I have enabled the app to run migrations when I run my app.

Here is a sample of my connection string.

  "Data": {
"Default": {
  "ConnectionString": "Server=localhost;  Port=5432;    User Id=kap_dev;  Database=kap_db;  Password=kapap_password;",
  "ProviderName": "Npgsql"
}

However, I get the error

PostgresException: 3D000: database "kap_dev" does not exist.

The issue is that kap_dev is a user and not a database.

I even posted this error to their git-issues but serenity have not responded with a valid answer.

Upvotes: 0

Views: 6872

Answers (4)

Serhat Koçhan
Serhat Koçhan

Reputation: 11

First, create a database named "database_name" using pgAdmin, then run the application.

Upvotes: 0

sahib-sem
sahib-sem

Reputation: 1

Try running migration first before running the project. The database should be created !

Upvotes: -1

Arm21
Arm21

Reputation: 11

You have to create a database which name is the name of your user "kap_dev".

Upvotes: -1

RouteTech
RouteTech

Reputation: 1

might be a typo, no space between User and Id

Upvotes: -2

Related Questions