Re: Postgres 9.5 pg_prewarm - Mailing list pgsql-admin

From Thomas SIMON
Subject Re: Postgres 9.5 pg_prewarm
Date
Msg-id 56B3706D.5020309@neteven.com
Whole thread Raw
In response to Re: Postgres 9.5 pg_prewarm  ("Simpson, John (IMS)" <SimpsonJ@imsweb.com>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Simpson, John (IMS)"
Date:
Subject: Re: Postgres 9.5 pg_prewarm
Next
From: Maks Materkov
Date:
Subject: Backups + streaming replication + WAL-E