Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

"createlang: command not found" in postgres

Tags:

postgresql

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.

like image 362
npatel Avatar asked Dec 23 '22 04:12

npatel


1 Answers

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.

like image 51
a_horse_with_no_name Avatar answered Jan 05 '23 18:01

a_horse_with_no_name