Ufdjrw

Multiply Two Integer Polynomials

What does ひと匙 mean in this manga and has it been used colloquially?

Is this app Icon Browser Safe/Legit?

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

Does the shape of a die affect the probability of a number being rolled?

If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?

What is the meaning of Triage in Cybersec world?

How to save as into a customized destination on macOS?

What does Linus Torvalds mean when he says that Git "never ever" tracks a file?

If a Druid sees an animal’s corpse, can they wild shape into that animal?

How can I autofill dates in Excel excluding Sunday?

When should I buy a clipper card after flying to OAK?

Why is the maximum length of OpenWrt’s root password 8 characters?

Why didn't the Event Horizon Telescope team mention Sagittarius A*?

Did 3000BC Egyptians use meteoric iron weapons?

Why isn't airport relocation done gradually?

Is three citations per paragraph excessive for undergraduate research paper?

Worn-tile Scrabble

Pokemon Turn Based battle (Python)

How are circuits which use complex ICs normally simulated?

How technical should a Scrum Master be to effectively remove impediments?

Why not take a picture of a closer black hole?

Identify boardgame from Big movie

FPGA - DIY Programming

Error connecting to posgresql database using pg on windows

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I've got a PostgreSQL database, definitely existing because I can connect to it and make SQL query using psql.

However, when I try to connect with node.js, using the pg client, I've got an error saying that the database does not exist.

Here is how the connection work:

var pg = require('pg');
const connection = new pg.Client(
 host: 'localhost',
 port: 5432,
 database: 'camino',
 user: 'postgres',
 password: 'postgres'
)

connection.connect();

And here is the error I obtained:

In english: The database **camino** does not exist.

Can you enligthen me on this error?

javascript node.js postgresql psql pg

share|improve this question

edited Mar 8 at 9:45

François Romain

4,269125590

asked Mar 8 at 9:30

ChalFloreChalFlore

62

add a comment | 

1

I've got a PostgreSQL database, definitely existing because I can connect to it and make SQL query using psql.

However, when I try to connect with node.js, using the pg client, I've got an error saying that the database does not exist.

Here is how the connection work:

var pg = require('pg');
const connection = new pg.Client(
 host: 'localhost',
 port: 5432,
 database: 'camino',
 user: 'postgres',
 password: 'postgres'
)

connection.connect();

And here is the error I obtained:

In english: The database **camino** does not exist.

Can you enligthen me on this error?

javascript node.js postgresql psql pg

share|improve this question

edited Mar 8 at 9:45

François Romain

4,269125590

asked Mar 8 at 9:30

ChalFloreChalFlore

62

add a comment | 

I've got a PostgreSQL database, definitely existing because I can connect to it and make SQL query using psql.

However, when I try to connect with node.js, using the pg client, I've got an error saying that the database does not exist.

Here is how the connection work:

var pg = require('pg');
const connection = new pg.Client(
 host: 'localhost',
 port: 5432,
 database: 'camino',
 user: 'postgres',
 password: 'postgres'
)

connection.connect();

And here is the error I obtained:

In english: The database **camino** does not exist.

Can you enligthen me on this error?

javascript node.js postgresql psql pg

share|improve this question

edited Mar 8 at 9:45

François Romain

4,269125590

asked Mar 8 at 9:30

ChalFloreChalFlore

62

var pg = require('pg');
const connection = new pg.Client(
 host: 'localhost',
 port: 5432,
 database: 'camino',
 user: 'postgres',
 password: 'postgres'
)

connection.connect();

share|improve this question

edited Mar 8 at 9:45

François Romain

4,269125590

asked Mar 8 at 9:30

ChalFloreChalFlore

62

share|improve this question

edited Mar 8 at 9:45

François Romain

4,269125590

asked Mar 8 at 9:30

ChalFloreChalFlore

62

edited Mar 8 at 9:45

François Romain

4,269125590

edited Mar 8 at 9:45

François Romain

4,269125590

asked Mar 8 at 9:30

ChalFloreChalFlore

62

asked Mar 8 at 9:30

ChalFloreChalFlore

62

1 Answer
1

active

oldest

votes

0

Are you sure you have created the database camino by using the create table syntax found here: https://www.postgresql.org/docs/9.1/sql-createdatabase.html

If you have already done that, Postgresql starts with 3 default databases called: postgres, template0 and template1. Have you tried connecting to the default postgres database and confirmed that it works?

share|improve this answer

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I tried to do so, and managed to connect to those database. I then recreated my database but still didn't manage to connect to it. I've also checked if the user and password I used to connect to the default postgres db are the same that the one I used to create my db...
  
  – ChalFlore
  Mar 13 at 21:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Ok, I uninstalled / reinstalled postgres and it worked.. Still don't know from where this error is coming from however.
  
  – ChalFlore
  Mar 29 at 9:43
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55060256%2ferror-connecting-to-posgresql-database-using-pg-on-windows%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Are you sure you have created the database camino by using the create table syntax found here: https://www.postgresql.org/docs/9.1/sql-createdatabase.html

If you have already done that, Postgresql starts with 3 default databases called: postgres, template0 and template1. Have you tried connecting to the default postgres database and confirmed that it works?

share|improve this answer

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I tried to do so, and managed to connect to those database. I then recreated my database but still didn't manage to connect to it. I've also checked if the user and password I used to connect to the default postgres db are the same that the one I used to create my db...
  
  – ChalFlore
  Mar 13 at 21:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Ok, I uninstalled / reinstalled postgres and it worked.. Still don't know from where this error is coming from however.
  
  – ChalFlore
  Mar 29 at 9:43
  

  
  
  
  

add a comment | 

0

Are you sure you have created the database camino by using the create table syntax found here: https://www.postgresql.org/docs/9.1/sql-createdatabase.html

If you have already done that, Postgresql starts with 3 default databases called: postgres, template0 and template1. Have you tried connecting to the default postgres database and confirmed that it works?

share|improve this answer

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  I tried to do so, and managed to connect to those database. I then recreated my database but still didn't manage to connect to it. I've also checked if the user and password I used to connect to the default postgres db are the same that the one I used to create my db...
  
  – ChalFlore
  Mar 13 at 21:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Ok, I uninstalled / reinstalled postgres and it worked.. Still don't know from where this error is coming from however.
  
  – ChalFlore
  Mar 29 at 9:43
  

  
  
  
  

add a comment | 

Are you sure you have created the database camino by using the create table syntax found here: https://www.postgresql.org/docs/9.1/sql-createdatabase.html

If you have already done that, Postgresql starts with 3 default databases called: postgres, template0 and template1. Have you tried connecting to the default postgres database and confirmed that it works?

share|improve this answer

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1

share|improve this answer

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1

answered Mar 9 at 22:58

thomas vangoidsenhoventhomas vangoidsenhoven

1