"createlang: command not found" in postgres

Question

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.

Iam using postgres but in window but maybe the first thing always error in execute command using postgres is path.. — dwir182
– dwir182, Commented Aug 31, 2018 at 3:26

user330315 · Accepted Answer · 2018-08-31 05:46:40Z

16

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.

answered Aug 31, 2018 at 5:46

user330315

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

Comments

clemens · Accepted Answer · 2022-03-02 05:23:39Z

1

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;

edited Mar 2, 2022 at 5:23

answered Aug 31, 2018 at 4:33

clemens

17.9k12 gold badges52 silver badges71 bronze badges

Collectives™ on Stack Overflow

"createlang: command not found" in postgres

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related