On 22/08/2014 13:08, Birta Levente wrote:
On 20/08/2014 23:27, Julien Rouhaud wrote:
On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <spam_ea...@gmx.net
<mailto:spam_ea...@gmx.net>> wrote:
Ramesh T schrieb am 20.08.2014 um 17:41:
> Hello,
>
> when i ran following query,
> postgres=# SELECT * FROM pg_stat_statements;
>
>
> ERROR: relation "pg_stat_statements" does not exist
> LINE 1: SELECT * FROM pg_stat_statements;
>
>
> i need to install POWA..i got powa.zip
No, you need to install the extension pg_stat_statements:
http://www.postgresql.org/docs/current/static/pgstatstatements.html
http://www.postgresql.org/docs/current/static/sql-createextension.html
You also need the extensions plpgsql (which should already be
installed) and btree_gist.
When installing the powa extension (CREATE EXTENSION powa;), postgres
will warn you of missing dependancy if any.
You can also refer to the installation documentation
(https://github.com/dalibo/powa/blob/master/README.md).
I just installed POWA and don't understand what mean in readme the
configure guc ?
Added extension and I get working the GUI, I can login, but have no
databases. How to add?
Never mind. ... forget to restart the server with powa in
shared_preload_libraries
Levi