From tsimon@neteven.com Thu Feb 4 14:01:04 2016 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRKT2-00029l-1v for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:01:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRKT1-0004xg-HC for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:01:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aRKRK-0001w1-Sw for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 13:59:19 +0000 Received: from mail4.neteven.com ([5.135.111.119]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRKRH-00037P-Ke for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 13:59:17 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail4.neteven.com (Postfix) with ESMTP id 31973A14FE for ; Thu, 4 Feb 2016 14:59:13 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at mail4.neteven.com Received: from mail4.neteven.com ([127.0.0.1]) by localhost (mail4.neteven.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6MdrRbhaOBZN for ; Thu, 4 Feb 2016 14:59:13 +0100 (CET) To: "pgsql-admin@postgresql.org" From: Thomas SIMON Subject: Postgres 9.5 pg_prewarm Message-ID: <56B35934.7060209@neteven.com> Date: Thu, 4 Feb 2016 14:59:16 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------------030408050007090108030206" X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------030408050007090108030206 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hi all, I have just migrated my db to PG 9.5, an I would like to use pg_prewarm contrib function, but when I want to use it, I have an error message I don't understand : It should do this : 1. postgres=# select pg_prewarm('foo'); 2. pg_prewarm 3. ------------ 4. 113278 5. (1 row) but it do that : psql (9.5.0) postgres=# create extension pg_prewarm; CREATE EXTENSION db=# select pg_prewarm('accounts'); ERROR: function pg_prewarm(unknown) does not exist LINE 1: select pg_prewarm('accounts'); ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. (table accounts exists) Does anyone have an idea ? Thanks, thomas -- Thomas --------------030408050007090108030206 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Hi all,

I have just migrated my db to PG 9.5, an I would like to use pg_prewarm contrib function, but when I want to use it, I have an error message I don't understand :


It should do this :

  1. postgres=# select pg_prewarm('foo');  
  2.  pg_prewarm  
  3. ------------  
  4.      113278  
  5. (1 row) 


but it do that :

psql (9.5.0)
postgres=# create extension pg_prewarm;
CREATE EXTENSION

db=# select pg_prewarm('accounts');
ERROR:  function pg_prewarm(unknown) does not exist
LINE 1: select pg_prewarm('accounts');
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

(table accounts exists)


Does anyone have an idea ?

Thanks,
thomas

-- 

Thomas
--------------030408050007090108030206-- From gilberto.castillo@etecsa.cu Thu Feb 4 14:10:07 2016 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRKbn-0002WY-37 for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:10:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRKbm-0007jH-MH for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:10:06 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aRKbl-0007fU-OU for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 14:10:05 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRKbh-0003MI-VE for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 14:10:04 +0000 Received: from mn3.etecsa.cu (unknown [192.168.91.45]) by imx6.etecsa.cu (Postfix) with ESMTP id 9AC16FB for ; Thu, 4 Feb 2016 09:09:58 -0500 (CST) Received: (qmail 15254 invoked by uid 11185); 4 Feb 2016 14:08:55 -0000 Received: from 192.168.91.6 by mn3.etecsa.cu (envelope-from , uid 502) with qmail-scanner-2.08 (spamassassin: 3.2.5. Clear:RC:1(192.168.91.6):. Processed in 0.029185 secs); 04 Feb 2016 14:08:55 -0000 Received: from unknown (HELO webmail.etecsa.cu) ([192.168.91.6]) (envelope-sender ) by mn2.etecsa.cu (qmail-ldap-1.03) with SMTP for ; 4 Feb 2016 14:08:55 -0000 Received: from 192.168.207.54 (SquirrelMail authenticated user gilberto.castillo) by webmail.etecsa.cu with HTTP; Thu, 4 Feb 2016 09:09:58 -0500 (GMT+5) Message-ID: <40044.192.168.207.54.1454594998.squirrel@webmail.etecsa.cu> In-Reply-To: <56B35934.7060209@neteven.com> References: <56B35934.7060209@neteven.com> Date: Thu, 4 Feb 2016 09:09:58 -0500 (GMT+5) Subject: Re: [MASSMAIL]Postgres 9.5 pg_prewarm From: "Gilberto Castillo" To: "Thomas SIMON" Cc: "pgsql-admin@postgresql.org" Reply-To: gilberto.castillo@etecsa.cu User-Agent: SquirrelMail/1.4.8-5.el5_4.10 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 90716 [Feb 04 2016] X-KLMS-AntiSpam-Version: 5.5.6 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Moebius-Timestamps: 3946765, 3946964, 3946727 X-KLMS-AntiSpam-Info: LuaCore: 410 410 49d6adb4cfedb86232574c1077a0d70dd74e781b, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2016/02/04 07:28:40 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2016/02/04 08:14:00 #6892526 X-KLMS-AntiVirus-Status: Clean, skipped X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org > Hi all, > > I have just migrated my db to PG 9.5, an I would like to use pg_prewarm > contrib function, but when I want to use it, I have an error message I > don't understand : > > > It should do this : > > 1. postgres=# select pg_prewarm('foo'); > 2. pg_prewarm > 3. ------------ > 4. 113278 > 5. (1 row) > > > > but it do that : > > psql (9.5.0) > postgres=# create extension pg_prewarm; > CREATE EXTENSION > > db=# select pg_prewarm('accounts'); > ERROR: function pg_prewarm(unknown) does not exist > LINE 1: select pg_prewarm('accounts'); > ^ > HINT: No function matches the given name and argument types. You might > need to add explicit type casts. > > (table accounts exists) > > > Does anyone have an idea ? > Use squeme example... foo.accountes -- Saludos, Gilberto Castillo ETECSA, La Habana, Cuba -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin From SimpsonJ@imsweb.com Thu Feb 4 14:29:07 2016 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRKuB-0003OK-Ni for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:29:07 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRKuB-0006gE-95 for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 14:29:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aRKsU-0003lW-40 for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 14:27:22 +0000 Received: from util-st-02.imsweb.com ([204.132.58.65]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRKsK-0004PI-Mj for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 14:27:20 +0000 Received: from THALASSA.omni.imsweb.com (thalassa.omni.imsweb.com [172.22.64.102]) by util-st-02.imsweb.com (Postfix) with ESMTP id 79544E19A2; Thu, 4 Feb 2016 09:27:10 -0500 (EST) Received: from NAIAD.omni.imsweb.com (172.22.64.103) by THALASSA.omni.imsweb.com (172.22.64.102) with Microsoft SMTP Server (TLS) id 15.0.1156.6; Thu, 4 Feb 2016 09:27:08 -0500 Received: from NAIAD.omni.imsweb.com ([172.22.64.103]) by NAIAD.omni.imsweb.com ([172.22.64.103]) with mapi id 15.00.1156.000; Thu, 4 Feb 2016 09:27:08 -0500 From: "Simpson, John (IMS)" To: Thomas SIMON , "pgsql-admin@postgresql.org" Subject: Re: Postgres 9.5 pg_prewarm Thread-Topic: [ADMIN] Postgres 9.5 pg_prewarm Thread-Index: AQHRX1RJsN27SRt+mkSIZCFrG/K7058b8T3Q Date: Thu, 4 Feb 2016 14:27:06 +0000 Message-ID: References: <56B35934.7060209@neteven.com> In-Reply-To: <56B35934.7060209@neteven.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [204.132.58.76] Content-Type: multipart/alternative; boundary="_000_a5198320e3e342b0a5063628efda4b04NAIADomniimswebcom_" MIME-Version: 1.0 X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_a5198320e3e342b0a5063628efda4b04NAIADomniimswebcom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 WW91IG5lZWQgdG8gY3JlYXRlIHRoZSBleHRlbnNpb24gaW4gdGhlIGRhdGFiYXNlIHRoYXQgeW91 IHdhbnQgdG8gdXNlIGl0IGluLiBGcm9tIHRoZSBvdXRwdXQgdGhhdCB5b3UgcG9zdGVkLCBpdCBs b29rcyBsaWtlIHlvdSBjcmVhdGVkIHRoZSBleHRlbnNpb24gaW4gdGhlIOKAnHBvc3RncmVz4oCd IGRhdGFiYXNlIGJ1dCB5b3UgdHJpZWQgdG8gdXNlIGl0IGluIHRoZSDigJxkYuKAnSBkYXRhYmFz ZS4NCg0KRnJvbTogcGdzcWwtYWRtaW4tb3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3Nx bC1hZG1pbi1vd25lckBwb3N0Z3Jlc3FsLm9yZ10gT24gQmVoYWxmIE9mIFRob21hcyBTSU1PTg0K U2VudDogVGh1cnNkYXksIEZlYnJ1YXJ5IDA0LCAyMDE2IDg6NTkgQU0NClRvOiBwZ3NxbC1hZG1p bkBwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogW0FETUlOXSBQb3N0Z3JlcyA5LjUgcGdfcHJld2Fy bQ0KDQpIaSBhbGwsDQoNCkkgaGF2ZSBqdXN0IG1pZ3JhdGVkIG15IGRiIHRvIFBHIDkuNSwgYW4g SSB3b3VsZCBsaWtlIHRvIHVzZSBwZ19wcmV3YXJtIGNvbnRyaWIgZnVuY3Rpb24sIGJ1dCB3aGVu IEkgd2FudCB0byB1c2UgaXQsIEkgaGF2ZSBhbiBlcnJvciBtZXNzYWdlIEkgZG9uJ3QgdW5kZXJz dGFuZCA6DQoNCg0KSXQgc2hvdWxkIGRvIHRoaXMgOg0KDQoNCjEuICAgICAgIHBvc3RncmVzPSMg c2VsZWN0IHBnX3ByZXdhcm0oJ2ZvbycpOw0KMi4gICAgICAgIHBnX3ByZXdhcm0NCjMuICAgICAg IC0tLS0tLS0tLS0tLQ0KNC4gICAgICAgICAgICAxMTMyNzgNCjUuICAgICAgICgxIHJvdykNCg0K DQoNCmJ1dCBpdCBkbyB0aGF0IDoNCg0KcHNxbCAoOS41LjApDQpwb3N0Z3Jlcz0jIGNyZWF0ZSBl eHRlbnNpb24gcGdfcHJld2FybTsNCkNSRUFURSBFWFRFTlNJT04NCg0KZGI9IyBzZWxlY3QgcGdf cHJld2FybSgnYWNjb3VudHMnKTsNCkVSUk9SOiAgZnVuY3Rpb24gcGdfcHJld2FybSh1bmtub3du KSBkb2VzIG5vdCBleGlzdA0KTElORSAxOiBzZWxlY3QgcGdfcHJld2FybSgnYWNjb3VudHMnKTsN CiAgICAgICAgICAgICAgIF4NCkhJTlQ6ICBObyBmdW5jdGlvbiBtYXRjaGVzIHRoZSBnaXZlbiBu YW1lIGFuZCBhcmd1bWVudCB0eXBlcy4gWW91IG1pZ2h0IG5lZWQgdG8gYWRkIGV4cGxpY2l0IHR5 cGUgY2FzdHMuDQoNCih0YWJsZSBhY2NvdW50cyBleGlzdHMpDQoNCg0KRG9lcyBhbnlvbmUgaGF2 ZSBhbiBpZGVhID8NCg0KVGhhbmtzLA0KdGhvbWFzDQoNCg0KDQotLQ0KDQoNCg0KVGhvbWFzDQoN Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fDQoNCkluZm9ybWF0aW9uIGluIHRoaXMg ZS1tYWlsIG1heSBiZSBjb25maWRlbnRpYWwuIEl0IGlzIGludGVuZGVkIG9ubHkgZm9yIHRoZSBh ZGRyZXNzZWUocykgaWRlbnRpZmllZCBhYm92ZS4gSWYgeW91IGFyZSBub3QgdGhlIGFkZHJlc3Nl ZShzKSwgb3IgYW4gZW1wbG95ZWUgb3IgYWdlbnQgb2YgdGhlIGFkZHJlc3NlZShzKSwgcGxlYXNl IG5vdGUgdGhhdCBhbnkgZGlzc2VtaW5hdGlvbiwgZGlzdHJpYnV0aW9uLCBvciBjb3B5aW5nIG9m IHRoaXMgY29tbXVuaWNhdGlvbiBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgaGF2ZSBy ZWNlaXZlZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwgcGxlYXNlIG5vdGlmeSB0aGUgc2VuZGVyIG9m IHRoZSBlcnJvci4NCg== --_000_a5198320e3e342b0a5063628efda4b04NAIADomniimswebcom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KQGZvbnQtZmFjZQ0KCXtmb250LWZhbWlseTpDb25zb2xhczsNCglwYW5vc2UtMToyIDEx IDYgOSAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3JtYWws IGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0 b206LjAwMDFwdDsNCglmb250LXNpemU6MTIuMHB0Ow0KCWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcg Um9tYW4iLHNlcmlmOw0KCWNvbG9yOmJsYWNrO30NCmE6bGluaywgc3Bhbi5Nc29IeXBlcmxpbmsN Cgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOiMwNTYzQzE7DQoJdGV4dC1kZWNvcmF0 aW9uOnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7 bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOiM5NTRGNzI7DQoJdGV4dC1kZWNvcmF0aW9u OnVuZGVybGluZTt9DQpwcmUNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCW1zby1zdHlsZS1s aW5rOiJIVE1MIFByZWZvcm1hdHRlZCBDaGFyIjsNCgltYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0 b206LjAwMDFwdDsNCglmb250LXNpemU6MTAuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDb3VyaWVyIE5l dyI7DQoJY29sb3I6YmxhY2s7fQ0Kc3Bhbi5zdHJpbmcNCgl7bXNvLXN0eWxlLW5hbWU6c3RyaW5n O30NCnNwYW4uSFRNTFByZWZvcm1hdHRlZENoYXINCgl7bXNvLXN0eWxlLW5hbWU6IkhUTUwgUHJl Zm9ybWF0dGVkIENoYXIiOw0KCW1zby1zdHlsZS1wcmlvcml0eTo5OTsNCgltc28tc3R5bGUtbGlu azoiSFRNTCBQcmVmb3JtYXR0ZWQiOw0KCWZvbnQtZmFtaWx5OkNvbnNvbGFzOw0KCWNvbG9yOmJs YWNrO30NCnNwYW4uRW1haWxTdHlsZTIwDQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5 Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmOw0KCWNvbG9yOiMxRjQ5N0Q7fQ0K Lk1zb0NocERlZmF1bHQNCgl7bXNvLXN0eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1zaXpl OjEwLjBwdDt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFy Z2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpX b3JkU2VjdGlvbjE7fQ0KLyogTGlzdCBEZWZpbml0aW9ucyAqLw0KQGxpc3QgbDANCgl7bXNvLWxp c3QtaWQ6NTQ4OTYxMzE1Ow0KCW1zby1saXN0LXRlbXBsYXRlLWlkczo1Njc4NTc2Mzg7fQ0Kb2wN Cgl7bWFyZ2luLWJvdHRvbTowaW47fQ0KdWwNCgl7bWFyZ2luLWJvdHRvbTowaW47fQ0KLS0+PC9z dHlsZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMgdjpleHQ9ImVk aXQiIHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lmIGd0ZSBtc28g OV0+PHhtbD4NCjxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFwIHY6ZXh0PSJl ZGl0IiBkYXRhPSIxIiAvPg0KPC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlmXS0tPg0KPC9o ZWFkPg0KPGJvZHkgYmdjb2xvcj0id2hpdGUiIGxhbmc9IkVOLVVTIiBsaW5rPSIjMDU2M0MxIiB2 bGluaz0iIzk1NEY3MiI+DQo8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xhc3M9Ik1z b05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7 Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOiMxRjQ5N0QiPllvdSBuZWVkIHRvIGNyZWF0 ZSB0aGUgZXh0ZW5zaW9uIGluIHRoZSBkYXRhYmFzZSB0aGF0IHlvdSB3YW50IHRvIHVzZSBpdCBp bi4gRnJvbSB0aGUgb3V0cHV0IHRoYXQgeW91IHBvc3RlZCwgaXQgbG9va3MgbGlrZSB5b3UgY3Jl YXRlZCB0aGUgZXh0ZW5zaW9uIGluIHRoZSDigJxwb3N0Z3Jlc+KAnQ0KIGRhdGFiYXNlIGJ1dCB5 b3UgdHJpZWQgdG8gdXNlIGl0IGluIHRoZSDigJxkYuKAnSBkYXRhYmFzZS48bzpwPjwvbzpwPjwv c3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEx LjBwdDtmb250LWZhbWlseTomcXVvdDtDYWxpYnJpJnF1b3Q7LHNhbnMtc2VyaWY7Y29sb3I6IzFG NDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPGRpdj4NCjxkaXYgc3R5bGU9ImJv cmRlcjpub25lO2JvcmRlci10b3A6c29saWQgI0UxRTFFMSAxLjBwdDtwYWRkaW5nOjMuMHB0IDBp biAwaW4gMGluIj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxiPjxzcGFuIHN0eWxlPSJmb250LXNp emU6MTEuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZjtjb2xv cjp3aW5kb3d0ZXh0Ij5Gcm9tOjwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4w cHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOndpbmRv d3RleHQiPiBwZ3NxbC1hZG1pbi1vd25lckBwb3N0Z3Jlc3FsLm9yZyBbbWFpbHRvOnBnc3FsLWFk bWluLW93bmVyQHBvc3RncmVzcWwub3JnXQ0KPGI+T24gQmVoYWxmIE9mIDwvYj5UaG9tYXMgU0lN T048YnI+DQo8Yj5TZW50OjwvYj4gVGh1cnNkYXksIEZlYnJ1YXJ5IDA0LCAyMDE2IDg6NTkgQU08 YnI+DQo8Yj5Ubzo8L2I+IHBnc3FsLWFkbWluQHBvc3RncmVzcWwub3JnPGJyPg0KPGI+U3ViamVj dDo8L2I+IFtBRE1JTl0gUG9zdGdyZXMgOS41IHBnX3ByZXdhcm08bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286 cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5IaSBhbGwsPGJyPg0KPGJyPg0KSSBoYXZlIGp1 c3QgbWlncmF0ZWQgbXkgZGIgdG8gUEcgOS41LCBhbiBJIHdvdWxkIGxpa2UgdG8gdXNlIHBnX3By ZXdhcm0gY29udHJpYiBmdW5jdGlvbiwgYnV0IHdoZW4gSSB3YW50IHRvIHVzZSBpdCwgSSBoYXZl IGFuIGVycm9yIG1lc3NhZ2UgSSBkb24ndCB1bmRlcnN0YW5kIDo8YnI+DQo8YnI+DQo8YnI+DQpJ dCBzaG91bGQgZG8gdGhpcyA6PGJyPg0KPGJyPg0KPGJyPg0KPG86cD48L286cD48L3A+DQo8ZGl2 IHN0eWxlPSJtc28tZWxlbWVudDpwYXJhLWJvcmRlci1kaXY7Ym9yZGVyOm5vbmU7Ym9yZGVyLWxl ZnQ6c29saWQgIzZDRTI2QyAyLjI1cHQ7cGFkZGluZzowaW4gMGluIDBpbiAwaW47YmFja2dyb3Vu ZDp3aGl0ZTttYXJnaW4tbGVmdDouNWluO21hcmdpbi1yaWdodDowaW4iPg0KPHAgY2xhc3M9Ik1z b05vcm1hbCIgc3R5bGU9Im1zby1tYXJnaW4tdG9wLWFsdDphdXRvO3RleHQtaW5kZW50OjBpbjts aW5lLWhlaWdodDoxMC41cHQ7bXNvLWxpc3Q6bDAgbGV2ZWwxIGxmbzE7YmFja2dyb3VuZDp3aGl0 ZTtib3JkZXI6bm9uZTtwYWRkaW5nOjBpbiI+DQo8IVtpZiAhc3VwcG9ydExpc3RzXT48c3BhbiBz dHlsZT0iZm9udC1zaXplOjEwLjVwdDtmb250LWZhbWlseTpDb25zb2xhcyI+PHNwYW4gc3R5bGU9 Im1zby1saXN0Oklnbm9yZSI+MS48c3BhbiBzdHlsZT0iZm9udDo3LjBwdCAmcXVvdDtUaW1lcyBO ZXcgUm9tYW4mcXVvdDsiPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOw0KPC9z cGFuPjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuNXB0 O2ZvbnQtZmFtaWx5OkNvbnNvbGFzO2JvcmRlcjpub25lIHdpbmRvd3RleHQgMS4wcHQ7cGFkZGlu ZzowaW4iPnBvc3RncmVzPSMmbmJzcDtzZWxlY3QmbmJzcDtwZ19wcmV3YXJtKDwvc3Bhbj48c3Bh biBjbGFzcz0ic3RyaW5nIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjVwdDtmb250LWZhbWls eTpDb25zb2xhcztjb2xvcjpibHVlO2JvcmRlcjpub25lIHdpbmRvd3RleHQgMS4wcHQ7cGFkZGlu ZzowaW4iPidmb28nPC9zcGFuPjwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjVwdDtm b250LWZhbWlseTpDb25zb2xhcztib3JkZXI6bm9uZSB3aW5kb3d0ZXh0IDEuMHB0O3BhZGRpbmc6 MGluIj4pOyZuYnNwOyZuYnNwOzwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjVwdDtm b250LWZhbWlseTpDb25zb2xhcyI+PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1z b05vcm1hbCIgc3R5bGU9Im1zby1tYXJnaW4tdG9wLWFsdDphdXRvO3RleHQtaW5kZW50OjBpbjts aW5lLWhlaWdodDoxMC41cHQ7bXNvLWxpc3Q6bDAgbGV2ZWwxIGxmbzE7YmFja2dyb3VuZDojRjhG OEY4O2JvcmRlcjpub25lO3BhZGRpbmc6MGluIj4NCjwhW2lmICFzdXBwb3J0TGlzdHNdPjxzcGFu IHN0eWxlPSJmb250LXNpemU6MTAuNXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFzO2NvbG9yOiM1QzVD NUMiPjxzcGFuIHN0eWxlPSJtc28tbGlzdDpJZ25vcmUiPjIuPHNwYW4gc3R5bGU9ImZvbnQ6Ny4w cHQgJnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7Ij4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsNCjwvc3Bhbj48L3NwYW4+PC9zcGFuPjwhW2VuZGlmXT48c3BhbiBzdHlsZT0i Zm9udC1zaXplOjEwLjVwdDtmb250LWZhbWlseTpDb25zb2xhcztib3JkZXI6bm9uZSB3aW5kb3d0 ZXh0IDEuMHB0O3BhZGRpbmc6MGluIj4mbmJzcDtwZ19wcmV3YXJtJm5ic3A7Jm5ic3A7PC9zcGFu PjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuNXB0O2ZvbnQtZmFtaWx5OkNvbnNvbGFzO2NvbG9y OiM1QzVDNUMiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0 eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzt0ZXh0LWluZGVudDowaW47bGluZS1oZWlnaHQ6 MTAuNXB0O21zby1saXN0OmwwIGxldmVsMSBsZm8xO2JhY2tncm91bmQ6d2hpdGU7Ym9yZGVyOm5v bmU7cGFkZGluZzowaW4iPg0KPCFbaWYgIXN1cHBvcnRMaXN0c10+PHNwYW4gc3R5bGU9ImZvbnQt c2l6ZToxMC41cHQ7Zm9udC1mYW1pbHk6Q29uc29sYXMiPjxzcGFuIHN0eWxlPSJtc28tbGlzdDpJ Z25vcmUiPjMuPHNwYW4gc3R5bGU9ImZvbnQ6Ny4wcHQgJnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1 b3Q7Ij4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCjwvc3Bhbj48L3NwYW4+ PC9zcGFuPjwhW2VuZGlmXT48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjVwdDtmb250LWZhbWls eTpDb25zb2xhcztib3JkZXI6bm9uZSB3aW5kb3d0ZXh0IDEuMHB0O3BhZGRpbmc6MGluIj4tLS0t LS0tLS0tLS0mbmJzcDsmbmJzcDs8L3NwYW4+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMC41cHQ7 Zm9udC1mYW1pbHk6Q29uc29sYXMiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJN c29Ob3JtYWwiIHN0eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzt0ZXh0LWluZGVudDowaW47 bGluZS1oZWlnaHQ6MTAuNXB0O21zby1saXN0OmwwIGxldmVsMSBsZm8xO2JhY2tncm91bmQ6I0Y4 RjhGODtib3JkZXI6bm9uZTtwYWRkaW5nOjBpbiI+DQo8IVtpZiAhc3VwcG9ydExpc3RzXT48c3Bh biBzdHlsZT0iZm9udC1zaXplOjEwLjVwdDtmb250LWZhbWlseTpDb25zb2xhcztjb2xvcjojNUM1 QzVDIj48c3BhbiBzdHlsZT0ibXNvLWxpc3Q6SWdub3JlIj40LjxzcGFuIHN0eWxlPSJmb250Ojcu MHB0ICZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OyI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7DQo8L3NwYW4+PC9zcGFuPjwvc3Bhbj48IVtlbmRpZl0+PHNwYW4gc3R5bGU9 ImZvbnQtc2l6ZToxMC41cHQ7Zm9udC1mYW1pbHk6Q29uc29sYXM7Ym9yZGVyOm5vbmUgd2luZG93 dGV4dCAxLjBwdDtwYWRkaW5nOjBpbiI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7MTEz Mjc4Jm5ic3A7Jm5ic3A7PC9zcGFuPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuNXB0O2ZvbnQt ZmFtaWx5OkNvbnNvbGFzO2NvbG9yOiM1QzVDNUMiPjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxw IGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzt0ZXh0LWlu ZGVudDowaW47bGluZS1oZWlnaHQ6MTAuNXB0O21zby1saXN0OmwwIGxldmVsMSBsZm8xO2JhY2tn cm91bmQ6d2hpdGU7Ym9yZGVyOm5vbmU7cGFkZGluZzowaW4iPg0KPCFbaWYgIXN1cHBvcnRMaXN0 c10+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMC41cHQ7Zm9udC1mYW1pbHk6Q29uc29sYXMiPjxz cGFuIHN0eWxlPSJtc28tbGlzdDpJZ25vcmUiPjUuPHNwYW4gc3R5bGU9ImZvbnQ6Ny4wcHQgJnF1 b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7Ij4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsNCjwvc3Bhbj48L3NwYW4+PC9zcGFuPjwhW2VuZGlmXT48c3BhbiBzdHlsZT0iZm9udC1z aXplOjEwLjVwdDtmb250LWZhbWlseTpDb25zb2xhcztib3JkZXI6bm9uZSB3aW5kb3d0ZXh0IDEu MHB0O3BhZGRpbmc6MGluIj4oMSZuYnNwO3JvdykmbmJzcDsNCjxicj4NCjxicj4NCjwvc3Bhbj48 c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjVwdDtmb250LWZhbWlseTpDb25zb2xhcyI+PG86cD48 L286cD48L3NwYW4+PC9wPg0KPC9kaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48YnI+DQo8YnI+ DQpidXQgaXQgZG8gdGhhdCA6PGJyPg0KPGJyPg0KcHNxbCAoOS41LjApPGJyPg0KcG9zdGdyZXM9 IyBjcmVhdGUgZXh0ZW5zaW9uIHBnX3ByZXdhcm07PGJyPg0KQ1JFQVRFIEVYVEVOU0lPTjxicj4N Cjxicj4NCmRiPSMgc2VsZWN0IHBnX3ByZXdhcm0oJ2FjY291bnRzJyk7PGJyPg0KRVJST1I6Jm5i c3A7IGZ1bmN0aW9uIHBnX3ByZXdhcm0odW5rbm93bikgZG9lcyBub3QgZXhpc3Q8YnI+DQpMSU5F IDE6IHNlbGVjdCBwZ19wcmV3YXJtKCdhY2NvdW50cycpOzxicj4NCiZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOyBePGJyPg0KSElOVDombmJzcDsgTm8gZnVuY3Rpb24gbWF0Y2hlcyB0aGUgZ2l2 ZW4gbmFtZSBhbmQgYXJndW1lbnQgdHlwZXMuIFlvdSBtaWdodCBuZWVkIHRvIGFkZCBleHBsaWNp dCB0eXBlIGNhc3RzLjxicj4NCjxicj4NCih0YWJsZSBhY2NvdW50cyBleGlzdHMpPGJyPg0KPGJy Pg0KPGJyPg0KRG9lcyBhbnlvbmUgaGF2ZSBhbiBpZGVhID88YnI+DQo8YnI+DQpUaGFua3MsPGJy Pg0KdGhvbWFzPGJyPg0KPGJyPg0KPGJyPg0KPG86cD48L286cD48L3A+DQo8cHJlPi0tIDxvOnA+ PC9vOnA+PC9wcmU+DQo8cHJlPjxvOnA+Jm5ic3A7PC9vOnA+PC9wcmU+DQo8cHJlPlRob21hczxv OnA+PC9vOnA+PC9wcmU+DQo8L2Rpdj4NCjxicj4NCjxocj4NCjxmb250IGZhY2U9IkFyaWFsIiBj b2xvcj0iR3JheSIgc2l6ZT0iMSI+PGJyPg0KSW5mb3JtYXRpb24gaW4gdGhpcyBlLW1haWwgbWF5 IGJlIGNvbmZpZGVudGlhbC4gSXQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIGFkZHJlc3NlZShz KSBpZGVudGlmaWVkIGFib3ZlLiBJZiB5b3UgYXJlIG5vdCB0aGUgYWRkcmVzc2VlKHMpLCBvciBh biBlbXBsb3llZSBvciBhZ2VudCBvZiB0aGUgYWRkcmVzc2VlKHMpLCBwbGVhc2Ugbm90ZSB0aGF0 IGFueSBkaXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24sIG9yIGNvcHlpbmcgb2YgdGhpcyBjb21t dW5pY2F0aW9uDQogaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gSWYgeW91IGhhdmUgcmVjZWl2ZWQg dGhpcyBlLW1haWwgaW4gZXJyb3IsIHBsZWFzZSBub3RpZnkgdGhlIHNlbmRlciBvZiB0aGUgZXJy b3IuPGJyPg0KPC9mb250Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_a5198320e3e342b0a5063628efda4b04NAIADomniimswebcom_-- From tsimon@neteven.com Thu Feb 4 15:40:08 2016 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aRM0u-0006rc-7p for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 15:40:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aRM0t-0007CY-Qc for pgsql-admin@arkaria.postgresql.org; Thu, 04 Feb 2016 15:40:07 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aRLzC-0003iT-Kw for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 15:38:22 +0000 Received: from mail4.neteven.com ([5.135.111.119]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1aRLz9-0005OH-8R for pgsql-admin@postgresql.org; Thu, 04 Feb 2016 15:38:21 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail4.neteven.com (Postfix) with ESMTP id 2F2A7A14FE; Thu, 4 Feb 2016 16:38:17 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at mail4.neteven.com Received: from mail4.neteven.com ([127.0.0.1]) by localhost (mail4.neteven.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uZZbGWn_xVh2; Thu, 4 Feb 2016 16:38:17 +0100 (CET) Subject: Re: Postgres 9.5 pg_prewarm To: "Simpson, John (IMS)" , "pgsql-admin@postgresql.org" References: <56B35934.7060209@neteven.com> From: Thomas SIMON Message-ID: <56B3706D.5020309@neteven.com> Date: Thu, 4 Feb 2016 16:38:21 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------080307050909090503060804" X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------080307050909090503060804 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Of course, what a stupid mistake. Must take a coffee :) thanks john Le 04/02/2016 15:27, Simpson, John (IMS) a écrit : > > You need to create the extension in the database that you want to use > it in. From the output that you posted, it looks like you created the > extension in the “postgres” database but you tried to use it in the > “db” database. > > *From:*pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] *On Behalf Of *Thomas SIMON > *Sent:* Thursday, February 04, 2016 8:59 AM > *To:* pgsql-admin@postgresql.org > *Subject:* [ADMIN] Postgres 9.5 pg_prewarm > > Hi all, > > I have just migrated my db to PG 9.5, an I would like to use > pg_prewarm contrib function, but when I want to use it, I have an > error message I don't understand : > > > It should do this : > > > 1.postgres=# select pg_prewarm('foo'); > > 2. pg_prewarm > > 3.------------ > > 4. 113278 > > 5.(1 row) > > > > but it do that : > > psql (9.5.0) > postgres=# create extension pg_prewarm; > CREATE EXTENSION > > db=# select pg_prewarm('accounts'); > ERROR: function pg_prewarm(unknown) does not exist > LINE 1: select pg_prewarm('accounts'); > ^ > HINT: No function matches the given name and argument types. You > might need to add explicit type casts. > > (table accounts exists) > > > Does anyone have an idea ? > > Thanks, > thomas > > > -- > Thomas > > ------------------------------------------------------------------------ > > Information in this e-mail may be confidential. It is intended only > for the addressee(s) identified above. If you are not the > addressee(s), or an employee or agent of the addressee(s), please note > that any dissemination, distribution, or copying of this communication > is strictly prohibited. If you have received this e-mail in error, > please notify the sender of the error. --------------080307050909090503060804 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit Of course, what a stupid mistake. Must take a coffee :)

thanks john

Le 04/02/2016 15:27, Simpson, John (IMS) a écrit :

You need to create the extension in the database that you want to use it in. From the output that you posted, it looks like you created the extension in the “postgres” database but you tried to use it in the “db” database.

 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas SIMON
Sent: Thursday, February 04, 2016 8:59 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Postgres 9.5 pg_prewarm

 

Hi all,

I have just migrated my db to PG 9.5, an I would like to use pg_prewarm contrib function, but when I want to use it, I have an error message I don't understand :


It should do this :


1.       postgres=# select pg_prewarm('foo');  

2.        pg_prewarm  

3.       ------------  

4.            113278  

5.       (1 row) 



but it do that :

psql (9.5.0)
postgres=# create extension pg_prewarm;
CREATE EXTENSION

db=# select pg_prewarm('accounts');
ERROR:  function pg_prewarm(unknown) does not exist
LINE 1: select pg_prewarm('accounts');
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

(table accounts exists)


Does anyone have an idea ?

Thanks,
thomas


-- 
 
Thomas


Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.

--------------080307050909090503060804--