POWA tool

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

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

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.klaver@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

On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell <rod@iol.ie> 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

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 <raghuchennuru@gmail.com> wrote:

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

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

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

On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer <spam_eater@gmx.net
<mailto:spam_eater@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?

Thanks

Levi

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@gmx.net
<mailto:spam_eater@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

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 <rameshparnanditech@gmail.com>
wrote:

On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T <rameshparnanditech@gmail.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@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 root 4 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 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@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&quot;.
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

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@gmail.com> wrote:

On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T <rameshparnanditech@gmail.com>
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

On Tue, Aug 26, 2014 at 5:43 AM, Raghu Ram <raghuchennuru@gmail.com> wrote:

On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T <rameshparnanditech@gmail.com>
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