How to drop a database in postgres sql using node.js?

Question

I am trying to drop a database called test from node.js postgres sql but it is not working.

var express = require('express');
var app = express();
var pg = require('pg');
var pgp = require('pg-promise')();

// Connect to PostgreSQL database
var connectionString = process.env.DATABASE_URL || 'postgres://postgres:pass123@localhost:5432/test';
var db = pgp(connectionString);
db.connect();


  db.query("DROP DATABASE test").then(function()
  {
    //createDatabases(db);
  }).catch(function(err)
  {
    console.log(err);
  });

But I am getting an error

{ [error: cannot drop the currently open database]
  name: 'error',
  length: 87,
  severity: 'ERROR',
  code: '55006',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'dbcommands.c',
  line: '834',
  routine: 'dropdb' }

Does anyone know how to fix it?

Thanks

You shouldn't call db.connect(); there. And you shouldn't include pg there. — vitaly-t
– vitaly-t, Commented Aug 7, 2016 at 18:00

Paul · Accepted Answer · 2016-08-06 22:37:03Z

6

As the error says, you can't be connected to the DB in question to drop it. You can connect to a different DB in order to do so, or use a tool like pgtools

var pgtools = require('pgtools');

// This can also be a connection string
// (in which case the database part is ignored and replaced with postgres)

const config = {
  user: 'postgres',
  password: 'some pass',
  port: 5432,
  host: 'localhost'
}


pgtools.dropdb(config, 'test-db', function (err, res) {
  if (err) {
    console.error(err);
    process.exit(-1);
  }
  console.log(res);
});

answered Aug 6, 2016 at 22:37

Paul

36.4k12 gold badges98 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

vapurrmaid Over a year ago

Thanks for posting this, just confirmed this worked very well, running from win10 git bash!

Collectives™ on Stack Overflow

How to drop a database in postgres sql using node.js?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related