Re: [GENERAL] POWA tool
On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T rameshparnandit...@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
Re: [GENERAL] POWA tool
On Tue, Aug 26, 2014 at 5:43 AM, Raghu Ram raghuchenn...@gmail.com wrote: On Tue, Aug 26, 2014 at 3:11 PM, Ramesh T rameshparnandit...@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
Re: [GENERAL] 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 raghuchenn...@gmail.com wrote: On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T rameshparnandit...@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 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
Re: [GENERAL] POWA tool
On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T rameshparnandit...@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 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 % Xferd Average Speed TimeTime Time Current
Re: [GENERAL] POWA tool
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? Thanks Levi
Re: [GENERAL] 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_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
Re: [GENERAL] POWA tool
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 rameshparnandit...@gmail.com 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 raghuchenn...@gmail.com wrote: On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell r...@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
Re: [GENERAL] 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 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
Re: [GENERAL] POWA tool
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
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
On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell r...@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
Re: [GENERAL] POWA tool
On Wed, Aug 20, 2014 at 6:46 PM, Thomas Kellerer 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). Regards. -- Julien Rouhaud http://www.dalibo.com
Re: [GENERAL] POWA tool
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 raghuchenn...@gmail.com wrote: On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell r...@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