{"id":3180,"date":"2023-01-22T18:19:36","date_gmt":"2023-01-22T05:19:36","guid":{"rendered":"https:\/\/www.talkcrypto.org\/blog\/?p=3180"},"modified":"2023-11-28T00:38:57","modified_gmt":"2023-11-27T11:38:57","slug":"btree_gist-extension-is-required","status":"publish","type":"post","link":"https:\/\/www.talkcrypto.org\/blog\/2023\/01\/22\/btree_gist-extension-is-required\/","title":{"rendered":"Btree_gist extension is required"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>$ subql-node -f .\n2023-01-22T05:06:23.893Z INFO Current @subql\/node version is 1.17.1\n2023-01-22T05:06:24.321Z INFO indexer manager start\n2023-01-22T05:06:27.209Z INFO Historical state is enabled\n2023-01-22T05:06:27.211Z ERROR Having a problem when syncing schema Error: Btree_gist extension is required to enable historical data, contact DB admin for support<\/code><\/pre>\n\n\n\n<p>If you have come across this error then you&#8217;ll have to run the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE EXTENSION IF NOT EXISTS btree_gist;<\/code><\/pre>\n\n\n\n<p>But where do you run this? This is a SQL command so you need to run it within postgres. First log in.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>psql -U postgres<\/code><\/pre>\n\n\n\n<p>Note, you might have to create a user with the following command first.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/usr\/local\/opt\/postgres\\@14\/bin\/createuser -s postgres<\/code><\/pre>\n\n\n\n<p>Then when you run the SQL command, you should see this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"391\" height=\"50\" src=\"https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/image.png\" alt=\"\" class=\"wp-image-3181\" srcset=\"https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/image.png 391w, https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/image-300x38.png 300w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>If you have come across this error then you&#8217;ll have<\/p>\n","protected":false},"author":1,"featured_media":3407,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-3180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-indexing"],"featured_image_urls":{"full":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist.jpg",960,540,false],"thumbnail":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist-150x150.jpg",150,150,true],"medium":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist-300x169.jpg",300,169,true],"medium_large":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist-768x432.jpg",640,360,true],"large":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist.jpg",640,360,false],"1536x1536":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist.jpg",960,540,false],"2048x2048":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist.jpg",960,540,false],"chromenews-featured":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist.jpg",960,540,false],"chromenews-large":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist-825x540.jpg",825,540,true],"chromenews-medium":["https:\/\/www.talkcrypto.org\/blog\/wp-content\/uploads\/2023\/01\/bgist-590x410.jpg",590,410,true]},"author_info":{"info":["seandotau"]},"category_info":"<a href=\"https:\/\/www.talkcrypto.org\/blog\/category\/indexing\/\" rel=\"category tag\">Indexing<\/a>","tag_info":"Indexing","comment_count":"0","_links":{"self":[{"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/posts\/3180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/comments?post=3180"}],"version-history":[{"count":1,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/posts\/3180\/revisions"}],"predecessor-version":[{"id":3182,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/posts\/3180\/revisions\/3182"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/media\/3407"}],"wp:attachment":[{"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/media?parent=3180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/categories?post=3180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.talkcrypto.org\/blog\/wp-json\/wp\/v2\/tags?post=3180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}