Re: POWA tool

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 <raghuchennuru(at)gmail(dot)com> wrote:

>
> On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
> 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(at)localhost tmp]# cd /tmp/
>> [root(at)localhost powa-REL_1_1]# unzip powa-REL_1_1.zip
>
> *Step 3:* Install POWA Software
>
>> [root(at)localhost powa-REL_1_1]# export PATH=/opt/PostgreSQL/9.3/bin:$PATH
>> [root(at)localhost powa-REL_1_1]# export
>> LD_LIBRARY_PATH=/opt/PostgreSQL/9.3/lib:$LD_LIBRARY_PATH
>> [root(at)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(at)localhost ui]# pwd
>> /tmp/powa-REL_1_1/ui
>> [root(at)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 root 4 Aug 19 2014 VERSION
>
>
> [root(at)localhost ui]# cp powa.conf-dist powa.conf
>>
>
> [root(at)localhost ~]# /usr/bin/curl get.mojolicio.us | sh
>> % Total % Received % Xferd Average Speed Time Time Time
>> Current
>> Dload Upload Total Spent Left
>> Speed
>> 0 54 0 54 0 0 179 0 --:--:-- --:--:-- --:--:--
>> 184
>> % Total % Received % Xferd Average Speed Time Time Time
>> Current
>> Dload Upload Total Spent Left
>> Speed
>> 100 262k 100 262k 0 0 70788 0 0:00:03 0:00:03 --:--:--
>> 120k
>> --> Working on Mojolicious
>> Fetching http://www.cpan.org/authors/id/S/SR/SRI/Mojolicious-5.33.tar.gz
>> ... OK
>> Configuring Mojolicious-5.33 ... OK
>> Building Mojolicious-5.33 ... OK
>> Successfully installed Mojolicious-5.33
>> 1 distribution installed
>
>
> [root(at)localhost ui]# morbo script/powa
>> [Tue Aug 26 00:46:29 2014] [debug] Reading configuration file
>> "/tmp/powa-REL_1_1/ui/powa.conf".
>> [Tue Aug 26 00:46:29 2014] [info] Listening at "http://*:3000".
>> Server available at http://127.0.0.1:3000.
>
>
> *Step 7: *Run http://127.0.0.1:3000 in web browser.
>
> Thanks & Regards
>
> Raghu Ram
>
>
>
>