Re: POWA tool

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_eater(at)gmx(dot)net
>> <mailto:spam_eater(at)gmx(dot)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