Re: [GENERAL] POWA tool

[Ramesh T]

i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty
tool remote server..


-bash-4.1$ unzip powa-REL_1_1.zip
-bash: unzip: command not found



On Tue, Aug 26, 2014 at 12:55 AM, Raghu Ram  wrote:

>
> On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T 
> wrote:
>
>> How to include pg_stat_statements in postgres.conf.powa is need it.
>>
>> any help..
>>
>>
>>  Below are the steps to Install POWA Tool:
>
> *Step 1:* Download POWA tool from below Website
>
>> https://github.com/dalibo/powa/archive/REL_1_1.zip
>
> *Step 2:* Unpack the Downloaded file
>
>> [root@localhost tmp]# cd /tmp/
>> [root@localhost powa-REL_1_1]# unzip powa-REL_1_1.zip
>
> *Step 3:* Install POWA Software
>
>> [root@localhost powa-REL_1_1]# export PATH=/opt/PostgreSQL/9.3/bin:$PATH
>> [root@localhost powa-REL_1_1]# export
>> LD_LIBRARY_PATH=/opt/PostgreSQL/9.3/lib:$LD_LIBRARY_PATH
>> [root@localhost powa-REL_1_1]# make install
>> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
>> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
>> -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I.
>> -I/opt/PostgreSQL/9.3/include/postgresql/server
>> -I/opt/PostgreSQL/9.3/include/postgresql/internal -D_GNU_SOURCE
>> -I/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/include/libxml2
>> -I/usr/local/include/libxml2 -I/usr/local/include  -c -o powa.o powa.c
>> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
>> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
>> -Wformat-security -fno-strict-aliasing -fwrapv -fpic
>> -L/opt/PostgreSQL/9.3/lib
>> -L/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/lib
>> -L/usr/local/lib -Wl,--as-needed
>> -Wl,-rpath,'/opt/PostgreSQL/9.3/lib',--enable-new-dtags  -shared -o powa.so
>> powa.o
>> /bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
>> /bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
>> /bin/mkdir -p '/opt/PostgreSQL/9.3/lib/postgresql'
>> /bin/mkdir -p '/opt/PostgreSQL/9.3/doc/postgresql/extension'
>> /usr/bin/install -c -m 644 ./powa.control
>> '/opt/PostgreSQL/9.3/share/postgresql/extension/'
>> /usr/bin/install -c -m 644 ./powa--1.0.sql ./powa--1.1.sql
>> '/opt/PostgreSQL/9.3/share/postgresql/extension/'
>> /usr/bin/install -c -m 755  powa.so '/opt/PostgreSQL/9.3/lib/postgresql/'
>> /usr/bin/install -c -m 644 ./README.md
>> '/opt/PostgreSQL/9.3/doc/postgresql/extension/'
>>
> *Step 4:* Create a POWA database & Create requires extensions
>
>> -bash-4.1$ /opt/PostgreSQL/9.3/bin/psql -p 5435
>> Password:
>> psql.bin (9.3.5)
>> Type "help" for help.
>> postgres=# create database powa;
>> CREATE DATABASE
>> postgres=# \c powa
>> You are now connected to database "powa" as user "postgres".
>> powa=# create extension pg_stat_statements ;
>> CREATE EXTENSION
>> powa=# create extension btree_gist ;
>> CREATE EXTENSION
>> powa=# create extension powa;
>> CREATE EXTENSION
>> powa=# \dt
>>   List of relations
>>  Schema |  Name   | Type  |  Owner
>> +-+---+--
>>  public | powa_functions  | table | postgres
>>  public | powa_last_aggregation   | table | postgres
>>  public | powa_last_purge | table | postgres
>>  public | powa_statements | table | postgres
>>  public | powa_statements_history | table | postgres
>>  public | powa_statements_history_current | table | postgres
>> (6 rows)
>
> *Step 5:*  add "power" & "pg_stat_statements" in the
> shared_preload_libraries in postgresql.conf file
>
>> -bash-4.1$ more /opt/PostgreSQL/9.3/data/postgresql.conf |grep
>> shared_preload
>> # Note:  Increasing max_prepared_transactions costs ~600 bytes of shared
>> memory
>> shared_preload_libraries = 'powa,pg_stat_statements' # (change requires
>> restart)
>
>
> -bash-4.1$ /opt/PostgreSQL/9.3/bin/pg_ctl -D /opt/PostgreSQL/9.3/data/
>> start
>> server starting
>> -bash-4.1$ 2014-07-25 03:48:20 IST LOG:  registering background worker
>> "powa"
>> 2014-07-25 03:48:20 IST LOG:  loaded library "powa"
>> 2014-07-25 03:48:20 IST LOG:  loaded library "pg_stat_statements"
>> 2014-07-25 03:48:20 IST LOG:  redirecting log output to logging collector
>> process
>> 2014-07-25 03:48:20 IST HINT:  Future log output will appear in directory
>> "pg_log".
>
> *Step 6:* Install Mojolicious Software
>
>> [root@localhost ui]# pwd
>> /tmp/powa-REL_1_1/ui
>> [root@localhost ui]# ls -l
>> total 36
>> drwxr-xr-x 4 root root 4096 Aug 19  2014 lib
>> -rw-r--r-- 1 root root  393 Jul 25 04:05 powa.conf
>> -rw-r--r-- 1 root root  393 Aug 19  2014 powa.conf-dist
>> drwxr-xr-x 6 root root 4096 Aug 19  2014 public
>> -rw-r--r-- 1 root root 2121 Aug 19  2014 README.md
>> drwxr-xr-x 2 root root 4096 Aug 19  2014 script
>> drwxr-xr-x 2 root root 4096 Aug 19  2014 t
>> drwxr-xr-x 6 root root 4096 Aug 19  2014 templates
>> -rw-r--r-- 1 root root4 Aug 19  2014 VERSION
>
>
> [root@localhost ui]# cp pow

Re: [GENERAL] POWA tool

[John McKown]

On Tue, Aug 26, 2014 at 5:43 AM, Raghu Ram  wrote:

> On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T 
> wrote:
>
>> i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty
>> tool remote server..
>>
>>
>> -bash-4.1$ unzip powa-REL_1_1.zip
>> -bash: unzip: command not found
>>
>>
> You need to Install "unzip" utility. Once you installed "unzip"
> utility,you can extract in "/tmp" directory.
>

As an alternative to the "unzip" command, the "jar" command from the Java
SDK can be used. Java "jar" files are simply zip files. And the jar command
can list, create, and extract from jar files.

jar xf powa-REL_1_1.zip # unzip

===

jar cf new.file.zip set.txt of.txt subdir/files.bin # create new

jar lf new.file.zip # list contents




-- 
There is nothing more pleasant than traveling and meeting new people!
Genghis Khan

Maranatha! <><
John McKown

Re: [GENERAL] POWA tool

[Raghu Ram]

On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T 
wrote:

> i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty
> tool remote server..
>
>
> -bash-4.1$ unzip powa-REL_1_1.zip
> -bash: unzip: command not found
>
>
You need to Install "unzip" utility. Once you installed "unzip" utility,you
can extract in "/tmp" directory.

for Debian and Ubuntu:
   1
 apt-get install unzip

for Red Hat Linux/Fedora/CentOS users:
   1
 yum install unzip

Re: [GENERAL] POWA tool

[Raghu Ram]

On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T 
wrote:

> How to include pg_stat_statements in postgres.conf.powa is need it.
>
> any help..
>
>
>  Below are the steps to Install POWA Tool:

*Step 1:* Download POWA tool from below Website

> https://github.com/dalibo/powa/archive/REL_1_1.zip

*Step 2:* Unpack the Downloaded file

> [root@localhost tmp]# cd /tmp/
> [root@localhost powa-REL_1_1]# unzip powa-REL_1_1.zip

*Step 3:* Install POWA Software

> [root@localhost powa-REL_1_1]# export PATH=/opt/PostgreSQL/9.3/bin:$PATH
> [root@localhost powa-REL_1_1]# export
> LD_LIBRARY_PATH=/opt/PostgreSQL/9.3/lib:$LD_LIBRARY_PATH
> [root@localhost powa-REL_1_1]# make install
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I.
> -I/opt/PostgreSQL/9.3/include/postgresql/server
> -I/opt/PostgreSQL/9.3/include/postgresql/internal -D_GNU_SOURCE
> -I/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/include/libxml2
> -I/usr/local/include/libxml2 -I/usr/local/include  -c -o powa.o powa.c
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fpic
> -L/opt/PostgreSQL/9.3/lib
> -L/opt/local/20140108/fc7f8f12-7861-11e3-aaff-000c29d23b02/lib
> -L/usr/local/lib -Wl,--as-needed
> -Wl,-rpath,'/opt/PostgreSQL/9.3/lib',--enable-new-dtags  -shared -o powa.so
> powa.o
> /bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
> /bin/mkdir -p '/opt/PostgreSQL/9.3/share/postgresql/extension'
> /bin/mkdir -p '/opt/PostgreSQL/9.3/lib/postgresql'
> /bin/mkdir -p '/opt/PostgreSQL/9.3/doc/postgresql/extension'
> /usr/bin/install -c -m 644 ./powa.control
> '/opt/PostgreSQL/9.3/share/postgresql/extension/'
> /usr/bin/install -c -m 644 ./powa--1.0.sql ./powa--1.1.sql
> '/opt/PostgreSQL/9.3/share/postgresql/extension/'
> /usr/bin/install -c -m 755  powa.so '/opt/PostgreSQL/9.3/lib/postgresql/'
> /usr/bin/install -c -m 644 ./README.md
> '/opt/PostgreSQL/9.3/doc/postgresql/extension/'
>
*Step 4:* Create a POWA database & Create requires extensions

> -bash-4.1$ /opt/PostgreSQL/9.3/bin/psql -p 5435
> Password:
> psql.bin (9.3.5)
> Type "help" for help.
> postgres=# create database powa;
> CREATE DATABASE
> postgres=# \c powa
> You are now connected to database "powa" as user "postgres".
> powa=# create extension pg_stat_statements ;
> CREATE EXTENSION
> powa=# create extension btree_gist ;
> CREATE EXTENSION
> powa=# create extension powa;
> CREATE EXTENSION
> powa=# \dt
>   List of relations
>  Schema |  Name   | Type  |  Owner
> +-+---+--
>  public | powa_functions  | table | postgres
>  public | powa_last_aggregation   | table | postgres
>  public | powa_last_purge | table | postgres
>  public | powa_statements | table | postgres
>  public | powa_statements_history | table | postgres
>  public | powa_statements_history_current | table | postgres
> (6 rows)

*Step 5:*  add "power" & "pg_stat_statements" in the
shared_preload_libraries in postgresql.conf file

> -bash-4.1$ more /opt/PostgreSQL/9.3/data/postgresql.conf |grep
> shared_preload
> # Note:  Increasing max_prepared_transactions costs ~600 bytes of shared
> memory
> shared_preload_libraries = 'powa,pg_stat_statements' # (change requires
> restart)


-bash-4.1$ /opt/PostgreSQL/9.3/bin/pg_ctl -D /opt/PostgreSQL/9.3/data/ start
> server starting
> -bash-4.1$ 2014-07-25 03:48:20 IST LOG:  registering background worker
> "powa"
> 2014-07-25 03:48:20 IST LOG:  loaded library "powa"
> 2014-07-25 03:48:20 IST LOG:  loaded library "pg_stat_statements"
> 2014-07-25 03:48:20 IST LOG:  redirecting log output to logging collector
> process
> 2014-07-25 03:48:20 IST HINT:  Future log output will appear in directory
> "pg_log".

*Step 6:* Install Mojolicious Software

> [root@localhost ui]# pwd
> /tmp/powa-REL_1_1/ui
> [root@localhost ui]# ls -l
> total 36
> drwxr-xr-x 4 root root 4096 Aug 19  2014 lib
> -rw-r--r-- 1 root root  393 Jul 25 04:05 powa.conf
> -rw-r--r-- 1 root root  393 Aug 19  2014 powa.conf-dist
> drwxr-xr-x 6 root root 4096 Aug 19  2014 public
> -rw-r--r-- 1 root root 2121 Aug 19  2014 README.md
> drwxr-xr-x 2 root root 4096 Aug 19  2014 script
> drwxr-xr-x 2 root root 4096 Aug 19  2014 t
> drwxr-xr-x 6 root root 4096 Aug 19  2014 templates
> -rw-r--r-- 1 root root4 Aug 19  2014 VERSION


[root@localhost ui]# cp powa.conf-dist powa.conf
>

[root@localhost ~]# /usr/bin/curl get.mojolicio.us | sh
>   % Total% Received % Xferd  Average Speed   TimeTime Time
> Current
>  Dload  Upload   Total   SpentLeft
> Speed
>   0540540 0179  0 --:--:-- --:--:-- --:--:--
> 184
>   % Total% Received %

Re: [GENERAL] POWA tool

[Ramesh T]

How to include pg_stat_statements in postgres.conf.powa is need it.

any help..

thanks,


On Wed, Aug 20, 2014 at 11:51 PM, Ramesh T 
wrote:

> yes,
>
> in my postgres.conf pg_stat_statements is not their  needs powa is
> released 19 aug.
>
>
> On Wed, Aug 20, 2014 at 10:17 PM, Raghu Ram 
> wrote:
>
>> On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell  wrote:
>>
>>>  On 20/08/2014 16:41, Ramesh T wrote:
>>> > 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
>>> >  please let me know how to install POWA.ZIP for my postgres using putty
>>> > tool ..
>>>
>>
>> are you referring below Tool ?
>>
>> PoWA is PostgreSQL Workload Analyzer that gathers performance stats and
>> provides real-time charts and graph to help monitor and tune your
>> PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.
>>
>> http://www.postgresql.org/about/news/1537/
>>
>> Thanks & Regards
>> Raghu Ram
>>
>
>

Re: [GENERAL] POWA tool

[Birta Levente]

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 > 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

Re: [GENERAL] POWA tool

[Birta Levente]

On 20/08/2014 23:27, Julien Rouhaud wrote:


On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer > 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?


Thanks

Levi

Re: [GENERAL] POWA tool

[Ramesh T]

yes,

in my postgres.conf pg_stat_statements is not their  needs powa is released
19 aug.


On Wed, Aug 20, 2014 at 10:17 PM, Raghu Ram  wrote:

> On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell  wrote:
>
>> On 20/08/2014 16:41, Ramesh T wrote:
>> > 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
>> >  please let me know how to install POWA.ZIP for my postgres using putty
>> > tool ..
>>
>
> are you referring below Tool ?
>
> PoWA is PostgreSQL Workload Analyzer that gathers performance stats and
> provides real-time charts and graph to help monitor and tune your
> PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.
>
> http://www.postgresql.org/about/news/1537/
>
> Thanks & Regards
> Raghu Ram
>

Re: [GENERAL] POWA tool

[Julien Rouhaud]

On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer  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).

Regards.
--
Julien Rouhaud
http://www.dalibo.com

Re: [GENERAL] POWA tool

[Raghu Ram]

On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell  wrote:

> On 20/08/2014 16:41, Ramesh T wrote:
> > 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
> >  please let me know how to install POWA.ZIP for my postgres using putty
> > tool ..
>

are you referring below Tool ?

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and
provides real-time charts and graph to help monitor and tune your
PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

http://www.postgresql.org/about/news/1537/

Thanks & Regards
Raghu Ram

Re: [GENERAL] POWA tool

[Adrian Klaver]

On 08/20/2014 08:41 AM, Ramesh T wrote:

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
  please let me know how to install POWA.ZIP for my postgres using putty
tool ..


Have no idea what POWA is.

As to your error:

http://www.postgresql.org/docs/9.3/static/pgstatstatements.html



thanks,




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] POWA tool

[Thomas Kellerer]

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




-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] POWA tool

[Raymond O'Donnell]

On 20/08/2014 16:41, Ramesh T wrote:
> 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
>  please let me know how to install POWA.ZIP for my postgres using putty
> tool ..

What is POWA?

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general