CODEWITHSUNDEEP
postgresql
npatel
npatel

Reputation: 263

"createlang: command not found" in postgres

I am trying to get musicbrainz database on my MacOS 10.12 from https://bitbucket.org/lalinsky/mbslave/overview

I have 10.5 version of postgres.

In the link, third step needs a command which says "createlang plpgsql musicbrainz"

I get "createlang: command not found" error for that.

Can someone help me with this? I am completely new to postgres.

Upvotes: 9

Views: 6075

Answers (2)

clemens
clemens

Reputation: 17722

You should check if createlang is installed:

ls $(dirname $(which psql))

The listing should include createlang.

If it isn't installed you might execute equivalent commands in psql. Something similar to this:

> psql musicbrainz
psql (10.5)
Type "help" for help.

musicbrainz# CREATE LANG plpgsql;

Upvotes: 1

user330315
user330315

Reputation:

Quote from the release notes

Remove createlang and droplang command-line applications (Peter Eisentraut)

These had been deprecated since PostgreSQL 9.1. Instead, use CREATE EXTENSION and DROP EXTENSION directly.

Additionally there is no reason to use createlang plpgsql (or create lang plpgsql) at all anymore.

Since Postgres 9.0 PL/pgSQL is automatically available in any newly created database.

So just skip that line.

Upvotes: 16

Related Questions