command to check the database size ?

am 25.03.2010 13:55:09 von Khangelani Gama

--_000_D78A8169F9436B4DB978300336168F3B33597EF250SWBREXCH00u cs_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi

Please help, I am new to postgres administration. I just need a command to =
check the size of the database.

I tried searching but no luck. The server is running on Postgres 7.3.4 and =
O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data directory. Th=
ere is no directory like /usr/src/postgresql-7.3.4/contrib/dbsize

But the backup server which is also running postgres 7.3.4 but on Redhat 9 =
does have /usr/src/postgresql-7.3.4/contrib/dbsize directory which has the =
following files but I don't what to from from:

[root@c9903 dbsize]# pwd
/usr/src/postgresql-7.3.4/contrib/dbsize
[root@c9903 dbsize]# ls -ltrh
total 16K
-rw-r--r-- 1 70 wheel 201 Feb 23 2002 Makefile
-rw-r--r-- 1 70 wheel 253 Apr 2 2002 dbsize.sql.in
-rw-r--r-- 1 70 wheel 554 Jun 23 2002 README.dbsize
-rw-r--r-- 1 70 wheel 2.6K Sep 4 2002 dbsize.c
[root@c9903 dbsize]#

I also could not find functions like pg_database_size(), pg_size_pretty()

,etc in this old version of postgres7.3.4.

In summary I can't find the command to find the database size from the main=
server and from the backup server.

Please help

Thanks

Khangelani

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_D78A8169F9436B4DB978300336168F3B33597EF250SWBREXCH00u cs_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

>

Please help, I am new to postgres administration. I =
just need a command to check the size of the database.

I tried searching but no luck. The server is running=
on Postgres 7.3.4 and O/S Linux Centos 5. The data sits on /data/po=
stgres7.3.4/data directory. There is no directory like /usr/src/postgresql-=
7.3.4/contrib/dbsize

But the backup server which is also running postg=
res 7.3.4 but on Redhat 9 does have /usr/src/postgresql-7.3.4/contrib/d=
bsize directory which has the following files but I don’t what to fro=
m from:

[root@c9903 dbsize]# pwd

/usr/src/postgresql-7.3.4/=
contrib/dbsize

[root@c9903 dbsize]# ls -ltrh

total 16K

-rw-r--r-- 1 70 &=
nbsp; wheel 201=
Feb 23 2002 Makefile

-rw-r--r-- 1 70 &=
nbsp; wheel 253=
Apr 2 2002 dbsize.sql.in

-rw-r--r-- 1 70 &=
nbsp; wheel 554=
Jun 23 2002 README.dbsize

-rw-r--r-- 1 70 &=
nbsp; wheel 2.6K Sep&=
nbsp; 4 2002 dbsize.c

[root@c9903 dbsize]#

I also could not find functions like pg_database_size(),
lass=3D"EmailStyle17"> 
ng>pg_size_pretty()
an>

,etc in this old version of postgres7.3.4.

In summary I can’t find the command to find th=
e database size from the main server and from the backup server.=

Please help

Thanks

Khangelani

family:"Courier New";
color:blue">

family:"Courier New";
color:blue"> ;Courier New";
color:black">

family:"Courier New"">

Confidentiality Notice: =3D"http://ucs.co.za/conf.html">http://ucs.co.za=
/conf.html

The contents of and attachme=
nts to this e-mail are intended for the addressee only, and may contain the=
confidential information of UCS Group and/or its subsidiaries. Any review,=
use or dissemination thereof by anyone
other than the intended addressee is prohibited. If you are not the intend=
ed addressee please notify the writer immediately and destroy the e-mail. U=
CS Group Limited and its subsidiaries distance themselves from and accept n=
o liability for unauthorised use
of their e-mail facilities or e-mails sent other than strictly for busines=
s purposes.

--_000_D78A8169F9436B4DB978300336168F3B33597EF250SWBREXCH00u cs_--

Re: command to check the database size ?

am 25.03.2010 14:19:24 von JRPlugge

--_000_BD69807DAE0CE44CA00A8338D0FDD08302CF163ADFoma00cexmbx 03_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Execute this against the database that you want to check the size of:

SELECT schemaname, tablename,
pg_size_pretty(size) AS size_pretty,
pg_size_pretty(total_size) AS total_size_pretty
FROM (SELECT *,
pg_relation_size(schemaname||'.'||tablename) AS size,
pg_total_relation_size(schemaname||'.'||tablename) AS total_size
FROM pg_tables) AS TABLES
WHERE schemaname=3D'public'
ORDER BY total_size DESC;

This will get it by table ....

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Khangelani Gama
Sent: Thursday, March 25, 2010 7:55 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] command to check the database size ?

Hi

Please help, I am new to postgres administration. I just need a command to =
check the size of the database.

I tried searching but no luck. The server is running on Postgres 7.3.4 and =
O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data directory. Th=
ere is no directory like /usr/src/postgresql-7.3.4/contrib/dbsize

But the backup server which is also running postgres 7.3.4 but on Redhat 9 =
does have /usr/src/postgresql-7.3.4/contrib/dbsize directory which has the =
following files but I don't what to from from:

[root@c9903 dbsize]# pwd
/usr/src/postgresql-7.3.4/contrib/dbsize
[root@c9903 dbsize]# ls -ltrh
total 16K
-rw-r--r-- 1 70 wheel 201 Feb 23 2002 Makefile
-rw-r--r-- 1 70 wheel 253 Apr 2 2002 dbsize.sql.in
-rw-r--r-- 1 70 wheel 554 Jun 23 2002 README.dbsize
-rw-r--r-- 1 70 wheel 2.6K Sep 4 2002 dbsize.c
[root@c9903 dbsize]#

I also could not find functions like pg_database_size(), pg_size_pretty()

,etc in this old version of postgres7.3.4.

In summary I can't find the command to find the database size from the main=
server and from the backup server.

Please help

Thanks

Khangelani

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_BD69807DAE0CE44CA00A8338D0FDD08302CF163ADFoma00cexmbx 03_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

>

sans-serif";
color:black'>Execute this against the database that you want to check the s=
ize
of:

sans-serif";
color:black'>

sans-serif";
color:black'>SELECT schemaname, tablename,

sans-serif";
color:black'>pg_size_pretty(size) AS size_pretty,

sans-serif";
color:black'>pg_size_pretty(total_size) AS total_size_pretty an>

sans-serif";
color:black'>FROM (SELECT *,

sans-serif";
color:black'>pg_relation_size(schemaname||'.'||tablename) AS size, p>

sans-serif";
color:black'>pg_total_relation_size(schemaname||'.'||tablena me) AS total_si=
ze

sans-serif";
color:black'>FROM pg_tables) AS TABLES

sans-serif";
color:black'>WHERE schemaname=3D'public'

sans-serif";
color:black'>ORDER BY total_size DESC;

sans-serif";
color:black'>

sans-serif";
color:black'>This will get it by table ….

sans-serif";
color:black'>

0in 0in'>

","sans-serif"'>From: style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' >
pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] =
On
Behalf Of Khangelani Gama

Sent: Thursday, March 25, 2010 7:55 AM

To: pgsql-admin@postgresql.org

Subject: [ADMIN] command to check the database size ? pan>

Please help, I am new to postgres administration. I ju=
st
need a command to check the size of the database.

I tried searching but no luck. The server is running o=
n Postgres
7.3.4 and O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data
directory. There is no directory like /usr/src/postgresql-7.3.4/contrib/dbs=
ize

But the backup server which is also running postgre=
s
7.3.4 but on Redhat 9 does have /usr/src/postgresql-7.3.4/contrib/dbsiz=
e
directory which has the following files but I don’t what to from from=
:

[root@c9903 dbsize]# pwd

/usr/src/postgresql-7.3.4/co=
ntrib/dbsize

[root@c9903 dbsize]# ls -ltrh

total 16K

-rw-r--r--    1
70
wheel         201 Feb 23 2002
Makefile

-rw-r--r-- 1 70 &nb=
sp;
wheel 253 Apr
2 2002 dbsize.sql.in

-rw-r--r--    1
70
wheel         554 Jun 23 2002
README.dbsize

-rw-r--r--    1
70
wheel        2.6K Sep 4 2002
dbsize.c

[root@c9903 dbsize]#

I also could not find functions like pg_database_size(),
class=3DEmailStyle19> 
g>
style=3D'font-family:"Courier New"'>pg_size_pretty()
o:p>

,etc in this old version of postgres7.3.4.

In summary I can’t find the command to find the =
database
size from the main server and from the backup server.

Please help

Thanks

Khangelani

ly:"Courier New";
color:blue'>

ly:"Courier New";
color:blue'> r New";
color:black'>

ly:"Courier New"'>

Confidentiality Notice: href=3D"http://ucs.co.za/conf.html">http://ucs.co.za/conf.ht ml p>

Roman","serif"'>

style=3D'font-size:12.0pt;font-family:"Times New Roman","serif"'>

ns-serif";
color:gray'>The contents of and attachments to this e-mail are intended for=
the
addressee only, and may contain the confidential information of UCS Group a=
nd/or
its subsidiaries. Any review, use or dissemination thereof by anyone other =
than
the intended addressee is prohibited. If you are not the intended addressee
please notify the writer immediately and destroy the e-mail. UCS Group Limi=
ted
and its subsidiaries distance themselves from and accept no liability for
unauthorised use of their e-mail facilities or e-mails sent other than stri=
ctly
for business purposes. imes New Roman","serif"'>

--_000_BD69807DAE0CE44CA00A8338D0FDD08302CF163ADFoma00cexmbx 03_--

Re: command to check the database size ?

am 25.03.2010 14:31:15 von Khangelani Gama

--_000_D78A8169F9436B4DB978300336168F3B33597EF2A3SWBREXCH00u cs_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Thanks Plugge, it works fine whereby it gives me the sizes for each table. =
But is there another command that will sum up and then give me one size for=
the whole database?

Please advise if it's possible.

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Plugge, Joe R.
Sent: Thursday, March 25, 2010 3:19 PM
To: Khangelani Gama; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] command to check the database size ?

Execute this against the database that you want to check the size of:

SELECT schemaname, tablename,
pg_size_pretty(size) AS size_pretty,
pg_size_pretty(total_size) AS total_size_pretty
FROM (SELECT *,
pg_relation_size(schemaname||'.'||tablename) AS size,
pg_total_relation_size(schemaname||'.'||tablename) AS total_size
FROM pg_tables) AS TABLES
WHERE schemaname=3D'public'
ORDER BY total_size DESC;

This will get it by table ....

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Khangelani Gama
Sent: Thursday, March 25, 2010 7:55 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] command to check the database size ?

Hi

Please help, I am new to postgres administration. I just need a command to =
check the size of the database.

I tried searching but no luck. The server is running on Postgres 7.3.4 and =
O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data directory. Th=
ere is no directory like /usr/src/postgresql-7.3.4/contrib/dbsize

But the backup server which is also running postgres 7.3.4 but on Redhat 9 =
does have /usr/src/postgresql-7.3.4/contrib/dbsize directory which has the =
following files but I don't what to from from:

[root@c9903 dbsize]# pwd
/usr/src/postgresql-7.3.4/contrib/dbsize
[root@c9903 dbsize]# ls -ltrh
total 16K
-rw-r--r-- 1 70 wheel 201 Feb 23 2002 Makefile
-rw-r--r-- 1 70 wheel 253 Apr 2 2002 dbsize.sql.in
-rw-r--r-- 1 70 wheel 554 Jun 23 2002 README.dbsize
-rw-r--r-- 1 70 wheel 2.6K Sep 4 2002 dbsize.c
[root@c9903 dbsize]#

I also could not find functions like pg_database_size(), pg_size_pretty()

,etc in this old version of postgres7.3.4.

In summary I can't find the command to find the database size from the main=
server and from the backup server.

Please help

Thanks

Khangelani

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_D78A8169F9436B4DB978300336168F3B33597EF2A3SWBREXCH00u cs_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

>

Thanks Plugge, it work=
s fine whereby it gives me the sizes for each table. But is there another c=
ommand that will sum up and then give me one size for the whole database?

Please advise if it=
217;s possible.

0in 0in">

;Tahoma","sans-serif"">From: ize:10.0pt;font-family:"Tahoma","sans-serif""> pgsql-ad=
min-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]
On Behalf Of Plugge, Joe R.

Sent: Thursday, March 25, 2010 3:19 PM

To: Khangelani Gama; pgsql-admin@postgresql.org

Subject: Re: [ADMIN] command to check the database size ? >

homa","sans-serif";
color:black">Execute this against the database that you want to check the s=
ize of:

homa","sans-serif";
color:black">

homa","sans-serif";
color:black">SELECT schemaname, tablename,

homa","sans-serif";
color:black">pg_size_pretty(size) AS size_pretty,

homa","sans-serif";
color:black">pg_size_pretty(total_size) AS total_size_pretty an>

homa","sans-serif";
color:black">FROM (SELECT *,

homa","sans-serif";
color:black">pg_relation_size(schemaname||'.'||tablename) AS size, p>

homa","sans-serif";
color:black">pg_total_relation_size(schemaname||'.'||tablena me) AS total_si=
ze

homa","sans-serif";
color:black">FROM pg_tables) AS TABLES

homa","sans-serif";
color:black">WHERE schemaname=3D'public'

homa","sans-serif";
color:black">ORDER BY total_size DESC;

homa","sans-serif";
color:black">

homa","sans-serif";
color:black">This will get it by table ….

homa","sans-serif";
color:black">

0in 0in">

;Tahoma","sans-serif"">From: ize:10.0pt;font-family:"Tahoma","sans-serif""> pgsql-ad=
min-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]
On Behalf Of Khangelani Gama

Sent: Thursday, March 25, 2010 7:55 AM

To: pgsql-admin@postgresql.org

Subject: [ADMIN] command to check the database size ? pan>

Please help, I am new to postgres administration. I =
just need a command to check the size of the database.

[root@c9903 dbsize]# pwd

/usr/src/postgresql-7.3.4/=
contrib/dbsize

[root@c9903 dbsize]# ls -ltrh

total 16K

-rw-r--r-- 1 70 &=
nbsp; wheel 201=
Feb 23 2002 Makefile

-rw-r--r-- 1 70 &=
nbsp; wheel 253=
Apr 2 2002 dbsize.sql.in

-rw-r--r-- 1 70 &=
nbsp; wheel 554=
Jun 23 2002 README.dbsize

-rw-r--r-- 1 70 &=
nbsp; wheel 2.6K Sep&=
nbsp; 4 2002 dbsize.c

[root@c9903 dbsize]#

I also could not find functions like pg_database_size(),
lass=3D"EmailStyle19"> 
ng>pg_size_pretty()
an>

,etc in this old version of postgres7.3.4.

In summary I can’t find the command to find th=
e database size from the main server and from the backup server.=

Please help

Thanks

Khangelani

family:"Courier New";
color:blue">

family:"Courier New";
color:blue"> ;Courier New";
color:black">

family:"Courier New"">

Confidentiality Notice: =3D"http://ucs.co.za/conf.html">http://ucs.co.za/conf.html span>

mes New Roman","serif"">

style=3D"font-size:12.0pt;font-family:"Times New Roman","se=
rif"">

al","sans-serif";
color:gray">The contents of and attachments to this e-mail are intended for=
the addressee only, and may contain the confidential information of UCS Gr=
oup and/or its subsidiaries.
Any review, use or dissemination thereof by anyone other than the intended=
addressee is prohibited. If you are not the intended addressee please noti=
fy the writer immediately and destroy the e-mail. UCS Group Limited and its=
subsidiaries distance themselves
from and accept no liability for unauthorised use of their e-mail faciliti=
es or e-mails sent other than strictly for business purposes. tyle=3D"font-size:12.0pt;
font-family:"Times New Roman","serif""> n>

Re: command to check the database size ?

am 25.03.2010 14:33:29 von JRPlugge

--_000_BD69807DAE0CE44CA00A8338D0FDD08302CF163AEEoma00cexmbx 03_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

This should work ...

SELECT pg_size_pretty(pg_database_size('mydatabasename')) As fulldbsize;

From: Khangelani Gama [mailto:Khangelani.Gama@ucs-software.co.za]
Sent: Thursday, March 25, 2010 8:31 AM
To: Plugge, Joe R.; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] command to check the database size ?

Thanks Plugge, it works fine whereby it gives me the sizes for each table. =
But is there another command that will sum up and then give me one size for=
the whole database?

Please advise if it's possible.

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Plugge, Joe R.
Sent: Thursday, March 25, 2010 3:19 PM
To: Khangelani Gama; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] command to check the database size ?

Execute this against the database that you want to check the size of:

SELECT schemaname, tablename,
pg_size_pretty(size) AS size_pretty,
pg_size_pretty(total_size) AS total_size_pretty
FROM (SELECT *,
pg_relation_size(schemaname||'.'||tablename) AS size,
pg_total_relation_size(schemaname||'.'||tablename) AS total_size
FROM pg_tables) AS TABLES
WHERE schemaname=3D'public'
ORDER BY total_size DESC;

This will get it by table ....

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql=
..org] On Behalf Of Khangelani Gama
Sent: Thursday, March 25, 2010 7:55 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] command to check the database size ?

Hi

Please help, I am new to postgres administration. I just need a command to =
check the size of the database.

I tried searching but no luck. The server is running on Postgres 7.3.4 and =
O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data directory. Th=
ere is no directory like /usr/src/postgresql-7.3.4/contrib/dbsize

But the backup server which is also running postgres 7.3.4 but on Redhat 9 =
does have /usr/src/postgresql-7.3.4/contrib/dbsize directory which has the =
following files but I don't what to from from:

[root@c9903 dbsize]# pwd
/usr/src/postgresql-7.3.4/contrib/dbsize
[root@c9903 dbsize]# ls -ltrh
total 16K
-rw-r--r-- 1 70 wheel 201 Feb 23 2002 Makefile
-rw-r--r-- 1 70 wheel 253 Apr 2 2002 dbsize.sql.in
-rw-r--r-- 1 70 wheel 554 Jun 23 2002 README.dbsize
-rw-r--r-- 1 70 wheel 2.6K Sep 4 2002 dbsize.c
[root@c9903 dbsize]#

I also could not find functions like pg_database_size(), pg_size_pretty()

,etc in this old version of postgres7.3.4.

In summary I can't find the command to find the database size from the main=
server and from the backup server.

Please help

Thanks

Khangelani

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_BD69807DAE0CE44CA00A8338D0FDD08302CF163AEEoma00cexmbx 03_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

>

sans-serif";
color:black'>This should work …

sans-serif";
color:black'>

sans-serif";
color:black'>SELECT pg_size_pretty(pg_database_size('mydatabasename')) As
fulldbsize;

sans-serif";
color:black'>

0in 0in'>

","sans-serif"'>From: style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' > Khangelani Ga=
ma
[mailto:Khangelani.Gama@ucs-software.co.za]

Sent: Thursday, March 25, 2010 8:31 AM

To: Plugge, Joe R.; pgsql-admin@postgresql.org

Subject: RE: [ADMIN] command to check the database size ? >

Thanks Plugge, it works =
fine
whereby it gives me the sizes for each table. But is there another command =
that
will sum up and then give me one size for the whole database? span>

Please advise if it̵=
7;s possible.

0in 0in'>

","sans-serif"'>From: style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"' > pgsql-admin-o=
wner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Plugge, Joe R=
..

Sent: Thursday, March 25, 2010 3:19 PM

To: Khangelani Gama; pgsql-admin@postgresql.org

Subject: Re: [ADMIN] command to check the database size ? >

sans-serif";
color:black'>Execute this against the database that you want to check the s=
ize
of:

sans-serif";
color:black'>

sans-serif";
color:black'>SELECT schemaname, tablename,

sans-serif";
color:black'>pg_size_pretty(size) AS size_pretty,

sans-serif";
color:black'>pg_size_pretty(total_size) AS total_size_pretty an>

sans-serif";
color:black'>FROM (SELECT *,

sans-serif";
color:black'>pg_relation_size(schemaname||'.'||tablename) AS size, p>

sans-serif";
color:black'>pg_total_relation_size(schemaname||'.'||tablena me) AS total_si=
ze

sans-serif";
color:black'>FROM pg_tables) AS TABLES

sans-serif";
color:black'>WHERE schemaname=3D'public'

sans-serif";
color:black'>ORDER BY total_size DESC;

sans-serif";
color:black'>

sans-serif";
color:black'>This will get it by table ….

sans-serif";
color:black'>

0in 0in'>

Please help, I am new to postgres administration. I ju=
st
need a command to check the size of the database.

[root@c9903 dbsize]# pwd

/usr/src/postgresql-7.3.4/co=
ntrib/dbsize

[root@c9903 dbsize]# ls -ltrh

total 16K

-rw-r--r--    1
70
wheel         201 Feb 23 2002
Makefile

-rw-r--r--    1
70
wheel         253 Apr
2 2002 dbsize.sql.in

-rw-r--r--    1
70
wheel         554 Jun 23 2002
README.dbsize

-rw-r--r--    1
70
wheel        2.6K Sep 4 2002
dbsize.c

[root@c9903 dbsize]#

I also could not find functions like pg_database_size(),
class=3DEmailStyle19> 
g>
style=3D'font-family:"Courier New"'>pg_size_pretty()
o:p>

,etc in this old version of postgres7.3.4.

In summary I can’t find the command to find the =
database
size from the main server and from the backup server.

Please help

Thanks

Khangelani

ly:"Courier New";
color:blue'>

ly:"Courier New";
color:blue'> r New";
color:black'>

ly:"Courier New"'>

Confidentiality Notice: href=3D"http://ucs.co.za/conf.html">http://ucs.co.za/conf.ht ml p>

Roman","serif"'>

style=3D'font-size:12.0pt;font-family:"Times New Roman","serif"'>

ns-serif";
color:gray'>The contents of and attachments to this e-mail are intended for=
the
addressee only, and may contain the confidential information of UCS Group
and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited. If you are not the intende=
d
addressee please notify the writer immediately and destroy the e-mail. UCS
Group Limited and its subsidiaries distance themselves from and accept no
liability for unauthorised use of their e-mail facilities or e-mails sent o=
ther
than strictly for business purposes. font-family:"Times New Roman","serif"'>

Roman","serif"'>

style=3D'font-size:12.0pt;font-family:"Times New Roman","serif"'>

--_000_BD69807DAE0CE44CA00A8338D0FDD08302CF163AEEoma00cexmbx 03_--

Re: command to check the database size ?

am 25.03.2010 14:35:10 von Brad Nicholson

On Thu, 2010-03-25 at 15:31 +0200, Khangelani Gama wrote:
> Thanks Plugge, it works fine whereby it gives me the sizes for each
> table. But is there another command that will sum up and then give me
> one size for the whole database?=20
>=20
>
>=20
> Please advise if itâ=99s possible.=20

A trivial modification to the SQL statement provided will sum up the
totals for each table and present the overall size.

And, it's worth mentioning, Postgres 7.3 is many, many years old, full
of nasty bugs. You really, really should upgrade. If you can't, make
sure your head is not on the line when it corrupts your data.

>
>=20
>
>=20
>
>=20
>
>=20
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Plugge, Joe R.
> Sent: Thursday, March 25, 2010 3:19 PM
> To: Khangelani Gama; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] command to check the database size ?=20
>=20
>=20
>
>=20
> Execute this against the database that you want to check the size of:
>=20
>
>=20
> SELECT schemaname, tablename,
>=20
> pg_size_pretty(size) AS size_pretty,
>=20
> pg_size_pretty(total_size) AS total_size_pretty
>=20
> FROM (SELECT *,
>=20
> pg_relation_size(schemaname||'.'||tablename) AS size,
>=20
> pg_total_relation_size(schemaname||'.'||tablename) AS total_size
>=20
> FROM pg_tables) AS TABLES
>=20
> WHERE schemaname=3D'public'
>=20
> ORDER BY total_size DESC;
>=20
>
>=20
>
>=20
> This will get it by table â=A6.
>=20
>
>=20
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Khangelani Gama
> Sent: Thursday, March 25, 2010 7:55 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] command to check the database size ?=20
>=20
>=20
>
>=20
> Hi=20
>=20
>
>=20
>
>=20
> Please help, I am new to postgres administration. I just need a
> command to check the size of the database.
>=20
>
>=20
> I tried searching but no luck. The server is running on Postgres 7.3.4
> and O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data
> directory. There is no directory
> like /usr/src/postgresql-7.3.4/contrib/dbsize
>=20
>
>=20
>
>=20
> But the backup server which is also running postgres 7.3.4 but on
> Redhat 9 does have /usr/src/postgresql-7.3.4/contrib/dbsize directory
> which has the following files but I donâ=99t what to from from:
>=20
>
>=20
> [root@c9903 dbsize]# pwd
>=20
> /usr/src/postgresql-7.3.4/contrib/dbsize
>=20
> [root@c9903 dbsize]# ls -ltrh
>=20
> total 16K
>=20
> -rw-r--r-- 1 70 wheel 201 Feb 23 2002 Makefile
>=20
> -rw-r--r-- 1 70 wheel 253 Apr 2 2002 dbsize.sql.in
>=20
> -rw-r--r-- 1 70 wheel 554 Jun 23 2002 README.dbsize
>=20
> -rw-r--r-- 1 70 wheel 2.6K Sep 4 2002 dbsize.c
>=20
> [root@c9903 dbsize]#
>=20
>
>=20
>
>=20
>
>=20
> I also could not find functions like pg_database_size(), pg_size_pretty()
> ,etc in this old version of postgres7.3.4.
>=20
>
>=20
>
>=20
> In summary I canâ=99t find the command to find the database size fro=
m the
> main server and from the backup server.
>=20
>
>=20
>
>=20
> Please help
>=20
>
>=20
>
>=20
> Thanks
>=20
>
>=20
> Khangelani
>=20
>
>=20
>
>=20
>
>=20
>
>=20
>
>=20
>
>=20
> Confidentiality Notice:http://ucs.co.za/conf.html
>=20
>
>=20
>
>=20
>
>=20
> =20=2 0 =

> ____________________________________________________________ __________
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of UCS
> Group and/or its subsidiaries. Any review, use or dissemination
> thereof by anyone other than the intended addressee is prohibited. If
> you are not the intended addressee please notify the writer
> immediately and destroy the e-mail. UCS Group Limited and its
> subsidiaries distance themselves from and accept no liability for
> unauthorised use of their e-mail facilities or e-mails sent other than
> strictly for business purposes.
>=20
>=20
>=20
>=20
> ____________________________________________________________ __________
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of UCS
> Group and/or its subsidiaries. Any review, use or dissemination
> thereof by anyone other than the intended addressee is prohibited. If
> you are not the intended addressee please notify the writer
> immediately and destroy the e-mail. UCS Group Limited and its
> subsidiaries distance themselves from and accept no liability for
> unauthorised use of their e-mail facilities or e-mails sent other than
> strictly for business purposes.
--=20
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

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

Re: command to check the database size ?

am 25.03.2010 14:36:06 von Brad Nicholson

On Thu, 2010-03-25 at 08:33 -0500, Plugge, Joe R. wrote:
> This should work â=A6
>=20
>
>=20
> SELECT pg_size_pretty(pg_database_size('mydatabasename')) As
> fulldbsize;

I'm pretty sure that the pg_database_size() function did not exist in
PG 7.3.

>=20
> From: Khangelani Gama [mailto:Khangelani.Gama@ucs-software.co.za]=20
> Sent: Thursday, March 25, 2010 8:31 AM
> To: Plugge, Joe R.; pgsql-admin@postgresql.org
> Subject: RE: [ADMIN] command to check the database size ?=20
>=20
>=20
>
>=20
> Thanks Plugge, it works fine whereby it gives me the sizes for each
> table. But is there another command that will sum up and then give me
> one size for the whole database?=20
>=20
>
>=20
> Please advise if itâ=99s possible.=20
>=20
>
>=20
>
>=20
>
>=20
>
>=20
>
>=20
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Plugge, Joe R.
> Sent: Thursday, March 25, 2010 3:19 PM
> To: Khangelani Gama; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] command to check the database size ?=20
>=20
>=20
>
>=20
> Execute this against the database that you want to check the size of:
>=20
>
>=20
> SELECT schemaname, tablename,
>=20
> pg_size_pretty(size) AS size_pretty,
>=20
> pg_size_pretty(total_size) AS total_size_pretty
>=20
> FROM (SELECT *,
>=20
> pg_relation_size(schemaname||'.'||tablename) AS size,
>=20
> pg_total_relation_size(schemaname||'.'||tablename) AS total_size
>=20
> FROM pg_tables) AS TABLES
>=20
> WHERE schemaname=3D'public'
>=20
> ORDER BY total_size DESC;
>=20
>
>=20
>
>=20
> This will get it by table â=A6.
>=20
>
>=20
> From:pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Khangelani Gama
> Sent: Thursday, March 25, 2010 7:55 AM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] command to check the database size ?=20
>=20
>=20
>
>=20
> Hi=20
>=20
>
>=20
>
>=20
> Please help, I am new to postgres administration. I just need a
> command to check the size of the database.
>=20
>
>=20
> I tried searching but no luck. The server is running on Postgres 7.3.4
> and O/S Linux Centos 5. The data sits on /data/postgres7.3.4/data
> directory. There is no directory
> like /usr/src/postgresql-7.3.4/contrib/dbsize
>=20
>
>=20
>
>=20
> But the backup server which is also running postgres 7.3.4 but on
> Redhat 9 does have /usr/src/postgresql-7.3.4/contrib/dbsize directory
> which has the following files but I donâ=99t what to from from:
>=20
>
>=20
> [root@c9903 dbsize]# pwd
>=20
> /usr/src/postgresql-7.3.4/contrib/dbsize
>=20
> [root@c9903 dbsize]# ls -ltrh
>=20
> total 16K
>=20
> -rw-r--r-- 1 70 wheel 201 Feb 23 2002 Makefile
>=20
> -rw-r--r-- 1 70 wheel 253 Apr 2 2002 dbsize.sql.in
>=20
> -rw-r--r-- 1 70 wheel 554 Jun 23 2002 README.dbsize
>=20
> -rw-r--r-- 1 70 wheel 2.6K Sep 4 2002 dbsize.c
>=20
> [root@c9903 dbsize]#
>=20
>
>=20
>
>=20
>
>=20
> I also could not find functions like pg_database_size(), pg_size_pretty()
> ,etc in this old version of postgres7.3.4.
>=20
>
>=20
>
>=20
> In summary I canâ=99t find the command to find the database size fro=
m the
> main server and from the backup server.
>=20
>
>=20
>
>=20
> Please help
>=20
>
>=20
>
>=20
> Thanks
>=20
>
>=20
> Khangelani
>=20
>
>=20
>
>=20
>
>=20
>
>=20
>
>=20
>
>=20
> Confidentiality Notice:http://ucs.co.za/conf.html
>=20
>
>=20
>
>=20
>
>=20
> =20=2 0 =

> ____________________________________________________________ __________
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of UCS
> Group and/or its subsidiaries. Any review, use or dissemination
> thereof by anyone other than the intended addressee is prohibited. If
> you are not the intended addressee please notify the writer
> immediately and destroy the e-mail. UCS Group Limited and its
> subsidiaries distance themselves from and accept no liability for
> unauthorised use of their e-mail facilities or e-mails sent other than
> strictly for business purposes.
>=20
>
>=20
> =20=2 0 =

> ____________________________________________________________ __________
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of UCS
> Group and/or its subsidiaries. Any review, use or dissemination
> thereof by anyone other than the intended addressee is prohibited. If
> you are not the intended addressee please notify the writer
> immediately and destroy the e-mail. UCS Group Limited and its
> subsidiaries distance themselves from and accept no liability for
> unauthorised use of their e-mail facilities or e-mails sent other than
> strictly for business purposes.
>=20
>=20
--=20
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

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

Re: command to check the database size ?

am 25.03.2010 14:49:02 von Khangelani Gama

SGkNCg0KSSBnZXQgdGhlIGZvbGxvd2luZyA6DQoNCmRiOTg3OT0jIFNFTEVD
VCBwZ19zaXplX3ByZXR0eShwZ19kYXRhYmFzZV9zaXplKCdkYjk4NzknKSkg
QXMgZnVsbGRic2l6ZTsNCg0KRVJST1I6ICBGdW5jdGlvbiBwZ19kYXRhYmFz
ZV9zaXplKCJ1bmtub3duIikgZG9lcyBub3QgZXhpc3QNCiAgICAgICAgVW5h
YmxlIHRvIGlkZW50aWZ5IGEgZnVuY3Rpb24gdGhhdCBzYXRpc2ZpZXMgdGhl
IGdpdmVuIGFyZ3VtZW50IHR5cGVzDQogICAgICAgIFlvdSBtYXkgbmVlZCB0
byBhZGQgZXhwbGljaXQgdHlwZWNhc3RzDQoNCg0KDQoNCg0KU29ycnkgdGhl
IHByZXZpb3VzIGNvbW1hbmQgZ2l2ZXMgbWUgdGhlIGZvbGxvd2luZywgIEkg
YWN0dWFsbHkgcmFuIGl0IGluIG15IHRlc3Qgc2VydmVyKHBnIDguMykgd2hl
biBJIHJhbiBpdCB0aGUgZmlyc3QgdGltZToNCg0KZGI5ODc5PSMgU0VMRUNU
IHNjaGVtYW5hbWUsIHRhYmxlbmFtZSwNCmRiOTg3OS0jIHBnX3NpemVfcHJl
dHR5KHNpemUpIEFTIHNpemVfcHJldHR5LA0KZGI5ODc5LSMgcGdfc2l6ZV9w
cmV0dHkodG90YWxfc2l6ZSkgQVMgdG90YWxfc2l6ZV9wcmV0dHkNCmRiOTg3
OS0jIEZST00gKFNFTEVDVCAqLA0KZGI5ODc5KCMgcGdfcmVsYXRpb25fc2l6
ZShzY2hlbWFuYW1lfHwnLid8fHRhYmxlbmFtZSkgQVMgc2l6ZSwNCmRiOTg3
OSgjIHBnX3RvdGFsX3JlbGF0aW9uX3NpemUoc2NoZW1hbmFtZXx8Jy4nfHx0
YWJsZW5hbWUpIEFTIHRvdGFsX3NpemUNCmRiOTg3OSgjIEZST00gcGdfdGFi
bGVzKSBBUyBUQUJMRVMNCmRiOTg3OS0jIFdIRVJFIHNjaGVtYW5hbWU9J3B1
YmxpYycNCmRiOTg3OS0jIE9SREVSIEJZIHRvdGFsX3NpemUgREVTQzsNCkVS
Uk9SOiAgRnVuY3Rpb24gcGdfcmVsYXRpb25fc2l6ZSh0ZXh0KSBkb2VzIG5v
dCBleGlzdA0KICAgICAgICBVbmFibGUgdG8gaWRlbnRpZnkgYSBmdW5jdGlv
biB0aGF0IHNhdGlzZmllcyB0aGUgZ2l2ZW4gYXJndW1lbnQgdHlwZXMNCiAg
ICAgICAgWW91IG1heSBuZWVkIHRvIGFkZCBleHBsaWNpdCB0eXBlY2FzdHMN
Cg0KDQoNCg0KDQoNCg0KVGhhbmtzDQoNCktoYW5nZWxhbmkNCg0KDQoNCg0K
DQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IEJyYWQg
TmljaG9sc29uIFttYWlsdG86Ym5pY2hvbHNAY2EuYWZpbGlhcy5pbmZvXQ0K
U2VudDogVGh1cnNkYXksIE1hcmNoIDI1LCAyMDEwIDM6MzYgUE0NClRvOiBQ
bHVnZ2UsIEpvZSBSLg0KQ2M6IEtoYW5nZWxhbmkgR2FtYTsgcGdzcWwtYWRt
aW5AcG9zdGdyZXNxbC5vcmcNClN1YmplY3Q6IFJlOiBbQURNSU5dIGNvbW1h
bmQgdG8gY2hlY2sgdGhlIGRhdGFiYXNlIHNpemUgPw0KDQpPbiBUaHUsIDIw
MTAtMDMtMjUgYXQgMDg6MzMgLTA1MDAsIFBsdWdnZSwgSm9lIFIuIHdyb3Rl
Og0KPiBUaGlzIHNob3VsZCB3b3JrIOKApg0KPg0KPg0KPg0KPiBTRUxFQ1Qg
cGdfc2l6ZV9wcmV0dHkocGdfZGF0YWJhc2Vfc2l6ZSgnbXlkYXRhYmFzZW5h
bWUnKSkgQXMNCj4gZnVsbGRic2l6ZTsNCg0KIEknbSBwcmV0dHkgc3VyZSB0
aGF0IHRoZSBwZ19kYXRhYmFzZV9zaXplKCkgZnVuY3Rpb24gZGlkIG5vdCBl
eGlzdCBpbg0KUEcgNy4zLg0KDQo+DQo+IEZyb206IEtoYW5nZWxhbmkgR2Ft
YSBbbWFpbHRvOktoYW5nZWxhbmkuR2FtYUB1Y3Mtc29mdHdhcmUuY28uemFd
DQo+IFNlbnQ6IFRodXJzZGF5LCBNYXJjaCAyNSwgMjAxMCA4OjMxIEFNDQo+
IFRvOiBQbHVnZ2UsIEpvZSBSLjsgcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5v
cmcNCj4gU3ViamVjdDogUkU6IFtBRE1JTl0gY29tbWFuZCB0byBjaGVjayB0
aGUgZGF0YWJhc2Ugc2l6ZSA/DQo+DQo+DQo+DQo+DQo+IFRoYW5rcyBQbHVn
Z2UsIGl0IHdvcmtzIGZpbmUgd2hlcmVieSBpdCBnaXZlcyBtZSB0aGUgc2l6
ZXMgZm9yIGVhY2gNCj4gdGFibGUuIEJ1dCBpcyB0aGVyZSBhbm90aGVyIGNv
bW1hbmQgdGhhdCB3aWxsIHN1bSB1cCBhbmQgdGhlbiBnaXZlIG1lDQo+IG9u
ZSBzaXplIGZvciB0aGUgd2hvbGUgZGF0YWJhc2U/DQo+DQo+DQo+DQo+IFBs
ZWFzZSBhZHZpc2UgaWYgaXTigJlzIHBvc3NpYmxlLg0KPg0KPg0KPg0KPg0K
Pg0KPg0KPg0KPg0KPg0KPg0KPg0KPiBGcm9tOiBwZ3NxbC1hZG1pbi1vd25l
ckBwb3N0Z3Jlc3FsLm9yZw0KPiBbbWFpbHRvOnBnc3FsLWFkbWluLW93bmVy
QHBvc3RncmVzcWwub3JnXSBPbiBCZWhhbGYgT2YgUGx1Z2dlLCBKb2UgUi4N
Cj4gU2VudDogVGh1cnNkYXksIE1hcmNoIDI1LCAyMDEwIDM6MTkgUE0NCj4g
VG86IEtoYW5nZWxhbmkgR2FtYTsgcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5v
cmcNCj4gU3ViamVjdDogUmU6IFtBRE1JTl0gY29tbWFuZCB0byBjaGVjayB0
aGUgZGF0YWJhc2Ugc2l6ZSA/DQo+DQo+DQo+DQo+DQo+IEV4ZWN1dGUgdGhp
cyBhZ2FpbnN0IHRoZSBkYXRhYmFzZSB0aGF0IHlvdSB3YW50IHRvIGNoZWNr
IHRoZSBzaXplIG9mOg0KPg0KPg0KPg0KPiBTRUxFQ1Qgc2NoZW1hbmFtZSwg
dGFibGVuYW1lLA0KPg0KPiBwZ19zaXplX3ByZXR0eShzaXplKSBBUyBzaXpl
X3ByZXR0eSwNCj4NCj4gcGdfc2l6ZV9wcmV0dHkodG90YWxfc2l6ZSkgQVMg
dG90YWxfc2l6ZV9wcmV0dHkNCj4NCj4gRlJPTSAoU0VMRUNUICosDQo+DQo+
IHBnX3JlbGF0aW9uX3NpemUoc2NoZW1hbmFtZXx8Jy4nfHx0YWJsZW5hbWUp
IEFTIHNpemUsDQo+DQo+IHBnX3RvdGFsX3JlbGF0aW9uX3NpemUoc2NoZW1h
bmFtZXx8Jy4nfHx0YWJsZW5hbWUpIEFTIHRvdGFsX3NpemUNCj4NCj4gRlJP
TSBwZ190YWJsZXMpIEFTIFRBQkxFUw0KPg0KPiBXSEVSRSBzY2hlbWFuYW1l
PSdwdWJsaWMnDQo+DQo+IE9SREVSIEJZIHRvdGFsX3NpemUgREVTQzsNCj4N
Cj4NCj4NCj4NCj4NCj4gVGhpcyB3aWxsIGdldCBpdCBieSB0YWJsZSDigKYu
DQo+DQo+DQo+DQo+IEZyb206cGdzcWwtYWRtaW4tb3duZXJAcG9zdGdyZXNx
bC5vcmcNCj4gW21haWx0bzpwZ3NxbC1hZG1pbi1vd25lckBwb3N0Z3Jlc3Fs
Lm9yZ10gT24gQmVoYWxmIE9mIEtoYW5nZWxhbmkgR2FtYQ0KPiBTZW50OiBU
aHVyc2RheSwgTWFyY2ggMjUsIDIwMTAgNzo1NSBBTQ0KPiBUbzogcGdzcWwt
YWRtaW5AcG9zdGdyZXNxbC5vcmcNCj4gU3ViamVjdDogW0FETUlOXSBjb21t
YW5kIHRvIGNoZWNrIHRoZSBkYXRhYmFzZSBzaXplID8NCj4NCj4NCj4NCj4N
Cj4gSGkNCj4NCj4NCj4NCj4NCj4NCj4gUGxlYXNlIGhlbHAsIEkgYW0gbmV3
IHRvIHBvc3RncmVzIGFkbWluaXN0cmF0aW9uLiBJIGp1c3QgbmVlZCBhDQo+
IGNvbW1hbmQgdG8gY2hlY2sgdGhlIHNpemUgb2YgdGhlIGRhdGFiYXNlLg0K
Pg0KPg0KPg0KPiBJIHRyaWVkIHNlYXJjaGluZyBidXQgbm8gbHVjay4gVGhl
IHNlcnZlciBpcyBydW5uaW5nIG9uIFBvc3RncmVzIDcuMy40DQo+IGFuZCBP
L1MgTGludXggQ2VudG9zIDUuIFRoZSBkYXRhIHNpdHMgb24gL2RhdGEvcG9z
dGdyZXM3LjMuNC9kYXRhDQo+IGRpcmVjdG9yeS4gVGhlcmUgaXMgbm8gZGly
ZWN0b3J5DQo+IGxpa2UgL3Vzci9zcmMvcG9zdGdyZXNxbC03LjMuNC9jb250
cmliL2Ric2l6ZQ0KPg0KPg0KPg0KPg0KPg0KPiBCdXQgdGhlIGJhY2t1cCBz
ZXJ2ZXIgd2hpY2ggaXMgYWxzbyBydW5uaW5nIHBvc3RncmVzIDcuMy40IGJ1
dCBvbg0KPiBSZWRoYXQgOSBkb2VzIGhhdmUgL3Vzci9zcmMvcG9zdGdyZXNx
bC03LjMuNC9jb250cmliL2Ric2l6ZSBkaXJlY3RvcnkNCj4gd2hpY2ggaGFz
IHRoZSBmb2xsb3dpbmcgZmlsZXMgYnV0IEkgZG9u4oCZdCB3aGF0IHRvIGZy
b20gZnJvbToNCj4NCj4NCj4NCj4gW3Jvb3RAYzk5MDMgZGJzaXplXSMgcHdk
DQo+DQo+IC91c3Ivc3JjL3Bvc3RncmVzcWwtNy4zLjQvY29udHJpYi9kYnNp
emUNCj4NCj4gW3Jvb3RAYzk5MDMgZGJzaXplXSMgbHMgLWx0cmgNCj4NCj4g
dG90YWwgMTZLDQo+DQo+IC1ydy1yLS1yLS0gICAgMSA3MCAgICAgICB3aGVl
bCAgICAgICAgIDIwMSBGZWIgMjMgIDIwMDIgTWFrZWZpbGUNCj4NCj4gLXJ3
LXItLXItLSAgICAxIDcwICAgICAgIHdoZWVsICAgICAgICAgMjUzIEFwciAg
MiAgMjAwMiBkYnNpemUuc3FsLmluDQo+DQo+IC1ydy1yLS1yLS0gICAgMSA3
MCAgICAgICB3aGVlbCAgICAgICAgIDU1NCBKdW4gMjMgIDIwMDIgUkVBRE1F
LmRic2l6ZQ0KPg0KPiAtcnctci0tci0tICAgIDEgNzAgICAgICAgd2hlZWwg
ICAgICAgIDIuNksgU2VwICA0ICAyMDAyIGRic2l6ZS5jDQo+DQo+IFtyb290
QGM5OTAzIGRic2l6ZV0jDQo+DQo+DQo+DQo+DQo+DQo+DQo+DQo+IEkgYWxz
byBjb3VsZCBub3QgZmluZCBmdW5jdGlvbnMgbGlrZSBwZ19kYXRhYmFzZV9z
aXplKCksIHBnX3NpemVfcHJldHR5KCkNCj4gLGV0YyBpbiB0aGlzIG9sZCB2
ZXJzaW9uIG9mIHBvc3RncmVzNy4zLjQuDQo+DQo+DQo+DQo+DQo+DQo+IElu
IHN1bW1hcnkgSSBjYW7igJl0IGZpbmQgdGhlIGNvbW1hbmQgdG8gZmluZCB0
aGUgZGF0YWJhc2Ugc2l6ZSBmcm9tIHRoZQ0KPiBtYWluIHNlcnZlciBhbmQg
ZnJvbSB0aGUgYmFja3VwIHNlcnZlci4NCj4NCj4NCj4NCj4NCj4NCj4gUGxl
YXNlIGhlbHANCj4NCj4NCj4NCj4NCj4NCj4gVGhhbmtzDQo+DQo+DQo+DQo+
IEtoYW5nZWxhbmkNCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4N
Cj4NCj4NCj4gQ29uZmlkZW50aWFsaXR5IE5vdGljZTpodHRwOi8vdWNzLmNv
LnphL2NvbmYuaHRtbA0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPiBfX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fDQo+IFRoZSBjb250ZW50cyBvZiBhbmQg
YXR0YWNobWVudHMgdG8gdGhpcyBlLW1haWwgYXJlIGludGVuZGVkIGZvciB0
aGUNCj4gYWRkcmVzc2VlIG9ubHksIGFuZCBtYXkgY29udGFpbiB0aGUgY29u
ZmlkZW50aWFsIGluZm9ybWF0aW9uIG9mIFVDUw0KPiBHcm91cCBhbmQvb3Ig
aXRzIHN1YnNpZGlhcmllcy4gQW55IHJldmlldywgdXNlIG9yIGRpc3NlbWlu
YXRpb24NCj4gdGhlcmVvZiBieSBhbnlvbmUgb3RoZXIgdGhhbiB0aGUgaW50
ZW5kZWQgYWRkcmVzc2VlIGlzIHByb2hpYml0ZWQuIElmDQo+IHlvdSBhcmUg
bm90IHRoZSBpbnRlbmRlZCBhZGRyZXNzZWUgcGxlYXNlIG5vdGlmeSB0aGUg
d3JpdGVyDQo+IGltbWVkaWF0ZWx5IGFuZCBkZXN0cm95IHRoZSBlLW1haWwu
IFVDUyBHcm91cCBMaW1pdGVkIGFuZCBpdHMNCj4gc3Vic2lkaWFyaWVzIGRp
c3RhbmNlIHRoZW1zZWx2ZXMgZnJvbSBhbmQgYWNjZXB0IG5vIGxpYWJpbGl0
eSBmb3INCj4gdW5hdXRob3Jpc2VkIHVzZSBvZiB0aGVpciBlLW1haWwgZmFj
aWxpdGllcyBvciBlLW1haWxzIHNlbnQgb3RoZXIgdGhhbg0KPiBzdHJpY3Rs
eSBmb3IgYnVzaW5lc3MgcHVycG9zZXMuDQo+DQo+DQo+DQo+DQo+IF9fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX18NCj4gVGhlIGNvbnRlbnRzIG9mIGFuZCBh
dHRhY2htZW50cyB0byB0aGlzIGUtbWFpbCBhcmUgaW50ZW5kZWQgZm9yIHRo
ZQ0KPiBhZGRyZXNzZWUgb25seSwgYW5kIG1heSBjb250YWluIHRoZSBjb25m
aWRlbnRpYWwgaW5mb3JtYXRpb24gb2YgVUNTDQo+IEdyb3VwIGFuZC9vciBp
dHMgc3Vic2lkaWFyaWVzLiBBbnkgcmV2aWV3LCB1c2Ugb3IgZGlzc2VtaW5h
dGlvbg0KPiB0aGVyZW9mIGJ5IGFueW9uZSBvdGhlciB0aGFuIHRoZSBpbnRl
bmRlZCBhZGRyZXNzZWUgaXMgcHJvaGliaXRlZC4gSWYNCj4geW91IGFyZSBu
b3QgdGhlIGludGVuZGVkIGFkZHJlc3NlZSBwbGVhc2Ugbm90aWZ5IHRoZSB3
cml0ZXINCj4gaW1tZWRpYXRlbHkgYW5kIGRlc3Ryb3kgdGhlIGUtbWFpbC4g
VUNTIEdyb3VwIExpbWl0ZWQgYW5kIGl0cw0KPiBzdWJzaWRpYXJpZXMgZGlz
dGFuY2UgdGhlbXNlbHZlcyBmcm9tIGFuZCBhY2NlcHQgbm8gbGlhYmlsaXR5
IGZvcg0KPiB1bmF1dGhvcmlzZWQgdXNlIG9mIHRoZWlyIGUtbWFpbCBmYWNp
bGl0aWVzIG9yIGUtbWFpbHMgc2VudCBvdGhlciB0aGFuDQo+IHN0cmljdGx5
IGZvciBidXNpbmVzcyBwdXJwb3Nlcy4NCj4NCj4NCi0tDQpCcmFkIE5pY2hv
bHNvbiAgNDE2LTY3My00MTA2DQpEYXRhYmFzZSBBZG1pbmlzdHJhdG9yLCBB
ZmlsaWFzIENhbmFkYSBDb3JwLg0KDQoNCg0KVGhlIGNvbnRlbnRzIG9mIGFu
ZCBhdHRhY2htZW50cyB0byB0aGlzIGUtbWFpbCBhcmUgaW50ZW5kZWQgZm9y
IHRoZSBhZGRyZXNzZWUgb25seSwgYW5kIG1heSBjb250YWluIHRoZSBjb25m
aWRlbnRpYWwgaW5mb3JtYXRpb24gb2YgVUNTIEdyb3VwIGFuZC9vciBpdHMg
c3Vic2lkaWFyaWVzLiAgQW55IHJldmlldywgdXNlIG9yIGRpc3NlbWluYXRp
b24gdGhlcmVvZiBieSBhbnlvbmUgb3RoZXIgdGhhbiB0aGUgaW50ZW5kZWQg
YWRkcmVzc2VlIGlzIHByb2hpYml0ZWQuICBJZiB5b3UgYXJlIG5vdCB0aGUg
aW50ZW5kZWQgYWRkcmVzc2VlIHBsZWFzZSBub3RpZnkgdGhlIHdyaXRlciBp
bW1lZGlhdGVseSBhbmQgZGVzdHJveSB0aGUgZS1tYWlsLiAgVUNTIEdyb3Vw
IExpbWl0ZWQgYW5kIGl0cyBzdWJzaWRpYXJpZXMgZGlzdGFuY2UgdGhlbXNl
bHZlcyBmcm9tIGFuZCBhY2NlcHQgbm8gbGlhYmlsaXR5IGZvciB1bmF1dGhv
cmlzZWQgdXNlIG9mIHRoZWlyIGUtbWFpbCBmYWNpbGl0aWVzIG9yIGUtbWFp
bHMgc2VudCBvdGhlciB0aGFuIHN0cmljdGx5IGZvciBidXNpbmVzcyBwdXJw
b3Nlcy4NCgotLSAKU2VudCB2aWEgcGdzcWwtYWRtaW4gbWFpbGluZyBsaXN0
IChwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2Vz
IHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwu
b3JnL21haWxwcmVmL3Bnc3FsLWFkbWluCg==

Re: command to check the database size ?

am 25.03.2010 14:51:53 von JRPlugge

U29ycnksIEkgb3Zlcmxvb2tlZCB0aGF0IHlvdSB3ZXJlIG9uIGFuIGFuY2ll
bnQgdmVyc2lvbiBvZiBQb3N0Z3JlcyAuLi4geW91IHJlYWxseSBuZWVkIHRv
IG1pZ3JhdGUgdG8gYSBuZXdlciB2ZXJzaW9uLg0KDQotLS0tLU9yaWdpbmFs
IE1lc3NhZ2UtLS0tLQ0KRnJvbTogS2hhbmdlbGFuaSBHYW1hIFttYWlsdG86
S2hhbmdlbGFuaS5HYW1hQHVjcy1zb2Z0d2FyZS5jby56YV0gDQpTZW50OiBU
aHVyc2RheSwgTWFyY2ggMjUsIDIwMTAgODo0OSBBTQ0KVG86IEJyYWQgTmlj
aG9sc29uOyBQbHVnZ2UsIEpvZSBSLg0KQ2M6IHBnc3FsLWFkbWluQHBvc3Rn
cmVzcWwub3JnDQpTdWJqZWN0OiBSRTogW0FETUlOXSBjb21tYW5kIHRvIGNo
ZWNrIHRoZSBkYXRhYmFzZSBzaXplID8NCg0KSGkNCg0KSSBnZXQgdGhlIGZv
bGxvd2luZyA6DQoNCmRiOTg3OT0jIFNFTEVDVCBwZ19zaXplX3ByZXR0eShw
Z19kYXRhYmFzZV9zaXplKCdkYjk4NzknKSkgQXMgZnVsbGRic2l6ZTsNCg0K
RVJST1I6ICBGdW5jdGlvbiBwZ19kYXRhYmFzZV9zaXplKCJ1bmtub3duIikg
ZG9lcyBub3QgZXhpc3QNCiAgICAgICAgVW5hYmxlIHRvIGlkZW50aWZ5IGEg
ZnVuY3Rpb24gdGhhdCBzYXRpc2ZpZXMgdGhlIGdpdmVuIGFyZ3VtZW50IHR5
cGVzDQogICAgICAgIFlvdSBtYXkgbmVlZCB0byBhZGQgZXhwbGljaXQgdHlw
ZWNhc3RzDQoNCg0KDQoNCg0KU29ycnkgdGhlIHByZXZpb3VzIGNvbW1hbmQg
Z2l2ZXMgbWUgdGhlIGZvbGxvd2luZywgIEkgYWN0dWFsbHkgcmFuIGl0IGlu
IG15IHRlc3Qgc2VydmVyKHBnIDguMykgd2hlbiBJIHJhbiBpdCB0aGUgZmly
c3QgdGltZToNCg0KZGI5ODc5PSMgU0VMRUNUIHNjaGVtYW5hbWUsIHRhYmxl
bmFtZSwNCmRiOTg3OS0jIHBnX3NpemVfcHJldHR5KHNpemUpIEFTIHNpemVf
cHJldHR5LA0KZGI5ODc5LSMgcGdfc2l6ZV9wcmV0dHkodG90YWxfc2l6ZSkg
QVMgdG90YWxfc2l6ZV9wcmV0dHkNCmRiOTg3OS0jIEZST00gKFNFTEVDVCAq
LA0KZGI5ODc5KCMgcGdfcmVsYXRpb25fc2l6ZShzY2hlbWFuYW1lfHwnLid8
fHRhYmxlbmFtZSkgQVMgc2l6ZSwNCmRiOTg3OSgjIHBnX3RvdGFsX3JlbGF0
aW9uX3NpemUoc2NoZW1hbmFtZXx8Jy4nfHx0YWJsZW5hbWUpIEFTIHRvdGFs
X3NpemUNCmRiOTg3OSgjIEZST00gcGdfdGFibGVzKSBBUyBUQUJMRVMNCmRi
OTg3OS0jIFdIRVJFIHNjaGVtYW5hbWU9J3B1YmxpYycNCmRiOTg3OS0jIE9S
REVSIEJZIHRvdGFsX3NpemUgREVTQzsNCkVSUk9SOiAgRnVuY3Rpb24gcGdf
cmVsYXRpb25fc2l6ZSh0ZXh0KSBkb2VzIG5vdCBleGlzdA0KICAgICAgICBV
bmFibGUgdG8gaWRlbnRpZnkgYSBmdW5jdGlvbiB0aGF0IHNhdGlzZmllcyB0
aGUgZ2l2ZW4gYXJndW1lbnQgdHlwZXMNCiAgICAgICAgWW91IG1heSBuZWVk
IHRvIGFkZCBleHBsaWNpdCB0eXBlY2FzdHMNCg0KDQoNCg0KDQoNCg0KVGhh
bmtzDQoNCktoYW5nZWxhbmkNCg0KDQoNCg0KDQoNCg0KLS0tLS1PcmlnaW5h
bCBNZXNzYWdlLS0tLS0NCkZyb206IEJyYWQgTmljaG9sc29uIFttYWlsdG86
Ym5pY2hvbHNAY2EuYWZpbGlhcy5pbmZvXQ0KU2VudDogVGh1cnNkYXksIE1h
cmNoIDI1LCAyMDEwIDM6MzYgUE0NClRvOiBQbHVnZ2UsIEpvZSBSLg0KQ2M6
IEtoYW5nZWxhbmkgR2FtYTsgcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcN
ClN1YmplY3Q6IFJlOiBbQURNSU5dIGNvbW1hbmQgdG8gY2hlY2sgdGhlIGRh
dGFiYXNlIHNpemUgPw0KDQpPbiBUaHUsIDIwMTAtMDMtMjUgYXQgMDg6MzMg
LTA1MDAsIFBsdWdnZSwgSm9lIFIuIHdyb3RlOg0KPiBUaGlzIHNob3VsZCB3
b3JrIOKApg0KPg0KPg0KPg0KPiBTRUxFQ1QgcGdfc2l6ZV9wcmV0dHkocGdf
ZGF0YWJhc2Vfc2l6ZSgnbXlkYXRhYmFzZW5hbWUnKSkgQXMNCj4gZnVsbGRi
c2l6ZTsNCg0KIEknbSBwcmV0dHkgc3VyZSB0aGF0IHRoZSBwZ19kYXRhYmFz
ZV9zaXplKCkgZnVuY3Rpb24gZGlkIG5vdCBleGlzdCBpbg0KUEcgNy4zLg0K
DQo+DQo+IEZyb206IEtoYW5nZWxhbmkgR2FtYSBbbWFpbHRvOktoYW5nZWxh
bmkuR2FtYUB1Y3Mtc29mdHdhcmUuY28uemFdDQo+IFNlbnQ6IFRodXJzZGF5
LCBNYXJjaCAyNSwgMjAxMCA4OjMxIEFNDQo+IFRvOiBQbHVnZ2UsIEpvZSBS
LjsgcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcNCj4gU3ViamVjdDogUkU6
IFtBRE1JTl0gY29tbWFuZCB0byBjaGVjayB0aGUgZGF0YWJhc2Ugc2l6ZSA/
DQo+DQo+DQo+DQo+DQo+IFRoYW5rcyBQbHVnZ2UsIGl0IHdvcmtzIGZpbmUg
d2hlcmVieSBpdCBnaXZlcyBtZSB0aGUgc2l6ZXMgZm9yIGVhY2gNCj4gdGFi
bGUuIEJ1dCBpcyB0aGVyZSBhbm90aGVyIGNvbW1hbmQgdGhhdCB3aWxsIHN1
bSB1cCBhbmQgdGhlbiBnaXZlIG1lDQo+IG9uZSBzaXplIGZvciB0aGUgd2hv
bGUgZGF0YWJhc2U/DQo+DQo+DQo+DQo+IFBsZWFzZSBhZHZpc2UgaWYgaXTi
gJlzIHBvc3NpYmxlLg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0K
Pg0KPiBGcm9tOiBwZ3NxbC1hZG1pbi1vd25lckBwb3N0Z3Jlc3FsLm9yZw0K
PiBbbWFpbHRvOnBnc3FsLWFkbWluLW93bmVyQHBvc3RncmVzcWwub3JnXSBP
biBCZWhhbGYgT2YgUGx1Z2dlLCBKb2UgUi4NCj4gU2VudDogVGh1cnNkYXks
IE1hcmNoIDI1LCAyMDEwIDM6MTkgUE0NCj4gVG86IEtoYW5nZWxhbmkgR2Ft
YTsgcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcNCj4gU3ViamVjdDogUmU6
IFtBRE1JTl0gY29tbWFuZCB0byBjaGVjayB0aGUgZGF0YWJhc2Ugc2l6ZSA/
DQo+DQo+DQo+DQo+DQo+IEV4ZWN1dGUgdGhpcyBhZ2FpbnN0IHRoZSBkYXRh
YmFzZSB0aGF0IHlvdSB3YW50IHRvIGNoZWNrIHRoZSBzaXplIG9mOg0KPg0K
Pg0KPg0KPiBTRUxFQ1Qgc2NoZW1hbmFtZSwgdGFibGVuYW1lLA0KPg0KPiBw
Z19zaXplX3ByZXR0eShzaXplKSBBUyBzaXplX3ByZXR0eSwNCj4NCj4gcGdf
c2l6ZV9wcmV0dHkodG90YWxfc2l6ZSkgQVMgdG90YWxfc2l6ZV9wcmV0dHkN
Cj4NCj4gRlJPTSAoU0VMRUNUICosDQo+DQo+IHBnX3JlbGF0aW9uX3NpemUo
c2NoZW1hbmFtZXx8Jy4nfHx0YWJsZW5hbWUpIEFTIHNpemUsDQo+DQo+IHBn
X3RvdGFsX3JlbGF0aW9uX3NpemUoc2NoZW1hbmFtZXx8Jy4nfHx0YWJsZW5h
bWUpIEFTIHRvdGFsX3NpemUNCj4NCj4gRlJPTSBwZ190YWJsZXMpIEFTIFRB
QkxFUw0KPg0KPiBXSEVSRSBzY2hlbWFuYW1lPSdwdWJsaWMnDQo+DQo+IE9S
REVSIEJZIHRvdGFsX3NpemUgREVTQzsNCj4NCj4NCj4NCj4NCj4NCj4gVGhp
cyB3aWxsIGdldCBpdCBieSB0YWJsZSDigKYuDQo+DQo+DQo+DQo+IEZyb206
cGdzcWwtYWRtaW4tb3duZXJAcG9zdGdyZXNxbC5vcmcNCj4gW21haWx0bzpw
Z3NxbC1hZG1pbi1vd25lckBwb3N0Z3Jlc3FsLm9yZ10gT24gQmVoYWxmIE9m
IEtoYW5nZWxhbmkgR2FtYQ0KPiBTZW50OiBUaHVyc2RheSwgTWFyY2ggMjUs
IDIwMTAgNzo1NSBBTQ0KPiBUbzogcGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5v
cmcNCj4gU3ViamVjdDogW0FETUlOXSBjb21tYW5kIHRvIGNoZWNrIHRoZSBk
YXRhYmFzZSBzaXplID8NCj4NCj4NCj4NCj4NCj4gSGkNCj4NCj4NCj4NCj4N
Cj4NCj4gUGxlYXNlIGhlbHAsIEkgYW0gbmV3IHRvIHBvc3RncmVzIGFkbWlu
aXN0cmF0aW9uLiBJIGp1c3QgbmVlZCBhDQo+IGNvbW1hbmQgdG8gY2hlY2sg
dGhlIHNpemUgb2YgdGhlIGRhdGFiYXNlLg0KPg0KPg0KPg0KPiBJIHRyaWVk
IHNlYXJjaGluZyBidXQgbm8gbHVjay4gVGhlIHNlcnZlciBpcyBydW5uaW5n
IG9uIFBvc3RncmVzIDcuMy40DQo+IGFuZCBPL1MgTGludXggQ2VudG9zIDUu
IFRoZSBkYXRhIHNpdHMgb24gL2RhdGEvcG9zdGdyZXM3LjMuNC9kYXRhDQo+
IGRpcmVjdG9yeS4gVGhlcmUgaXMgbm8gZGlyZWN0b3J5DQo+IGxpa2UgL3Vz
ci9zcmMvcG9zdGdyZXNxbC03LjMuNC9jb250cmliL2Ric2l6ZQ0KPg0KPg0K
Pg0KPg0KPg0KPiBCdXQgdGhlIGJhY2t1cCBzZXJ2ZXIgd2hpY2ggaXMgYWxz
byBydW5uaW5nIHBvc3RncmVzIDcuMy40IGJ1dCBvbg0KPiBSZWRoYXQgOSBk
b2VzIGhhdmUgL3Vzci9zcmMvcG9zdGdyZXNxbC03LjMuNC9jb250cmliL2Ri
c2l6ZSBkaXJlY3RvcnkNCj4gd2hpY2ggaGFzIHRoZSBmb2xsb3dpbmcgZmls
ZXMgYnV0IEkgZG9u4oCZdCB3aGF0IHRvIGZyb20gZnJvbToNCj4NCj4NCj4N
Cj4gW3Jvb3RAYzk5MDMgZGJzaXplXSMgcHdkDQo+DQo+IC91c3Ivc3JjL3Bv
c3RncmVzcWwtNy4zLjQvY29udHJpYi9kYnNpemUNCj4NCj4gW3Jvb3RAYzk5
MDMgZGJzaXplXSMgbHMgLWx0cmgNCj4NCj4gdG90YWwgMTZLDQo+DQo+IC1y
dy1yLS1yLS0gICAgMSA3MCAgICAgICB3aGVlbCAgICAgICAgIDIwMSBGZWIg
MjMgIDIwMDIgTWFrZWZpbGUNCj4NCj4gLXJ3LXItLXItLSAgICAxIDcwICAg
ICAgIHdoZWVsICAgICAgICAgMjUzIEFwciAgMiAgMjAwMiBkYnNpemUuc3Fs
LmluDQo+DQo+IC1ydy1yLS1yLS0gICAgMSA3MCAgICAgICB3aGVlbCAgICAg
ICAgIDU1NCBKdW4gMjMgIDIwMDIgUkVBRE1FLmRic2l6ZQ0KPg0KPiAtcnct
ci0tci0tICAgIDEgNzAgICAgICAgd2hlZWwgICAgICAgIDIuNksgU2VwICA0
ICAyMDAyIGRic2l6ZS5jDQo+DQo+IFtyb290QGM5OTAzIGRic2l6ZV0jDQo+
DQo+DQo+DQo+DQo+DQo+DQo+DQo+IEkgYWxzbyBjb3VsZCBub3QgZmluZCBm
dW5jdGlvbnMgbGlrZSBwZ19kYXRhYmFzZV9zaXplKCksIHBnX3NpemVfcHJl
dHR5KCkNCj4gLGV0YyBpbiB0aGlzIG9sZCB2ZXJzaW9uIG9mIHBvc3RncmVz
Ny4zLjQuDQo+DQo+DQo+DQo+DQo+DQo+IEluIHN1bW1hcnkgSSBjYW7igJl0
IGZpbmQgdGhlIGNvbW1hbmQgdG8gZmluZCB0aGUgZGF0YWJhc2Ugc2l6ZSBm
cm9tIHRoZQ0KPiBtYWluIHNlcnZlciBhbmQgZnJvbSB0aGUgYmFja3VwIHNl
cnZlci4NCj4NCj4NCj4NCj4NCj4NCj4gUGxlYXNlIGhlbHANCj4NCj4NCj4N
Cj4NCj4NCj4gVGhhbmtzDQo+DQo+DQo+DQo+IEtoYW5nZWxhbmkNCj4NCj4N
Cj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4NCj4gQ29uZmlkZW50
aWFsaXR5IE5vdGljZTpodHRwOi8vdWNzLmNvLnphL2NvbmYuaHRtbA0KPg0K
Pg0KPg0KPg0KPg0KPg0KPg0KPg0KPiBfX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fDQo+IFRoZSBjb250ZW50cyBvZiBhbmQgYXR0YWNobWVudHMgdG8gdGhp
cyBlLW1haWwgYXJlIGludGVuZGVkIGZvciB0aGUNCj4gYWRkcmVzc2VlIG9u
bHksIGFuZCBtYXkgY29udGFpbiB0aGUgY29uZmlkZW50aWFsIGluZm9ybWF0
aW9uIG9mIFVDUw0KPiBHcm91cCBhbmQvb3IgaXRzIHN1YnNpZGlhcmllcy4g
QW55IHJldmlldywgdXNlIG9yIGRpc3NlbWluYXRpb24NCj4gdGhlcmVvZiBi
eSBhbnlvbmUgb3RoZXIgdGhhbiB0aGUgaW50ZW5kZWQgYWRkcmVzc2VlIGlz
IHByb2hpYml0ZWQuIElmDQo+IHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCBh
ZGRyZXNzZWUgcGxlYXNlIG5vdGlmeSB0aGUgd3JpdGVyDQo+IGltbWVkaWF0
ZWx5IGFuZCBkZXN0cm95IHRoZSBlLW1haWwuIFVDUyBHcm91cCBMaW1pdGVk
IGFuZCBpdHMNCj4gc3Vic2lkaWFyaWVzIGRpc3RhbmNlIHRoZW1zZWx2ZXMg
ZnJvbSBhbmQgYWNjZXB0IG5vIGxpYWJpbGl0eSBmb3INCj4gdW5hdXRob3Jp
c2VkIHVzZSBvZiB0aGVpciBlLW1haWwgZmFjaWxpdGllcyBvciBlLW1haWxz
IHNlbnQgb3RoZXIgdGhhbg0KPiBzdHJpY3RseSBmb3IgYnVzaW5lc3MgcHVy
cG9zZXMuDQo+DQo+DQo+DQo+DQo+IF9fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X18NCj4gVGhlIGNvbnRlbnRzIG9mIGFuZCBhdHRhY2htZW50cyB0byB0aGlz
IGUtbWFpbCBhcmUgaW50ZW5kZWQgZm9yIHRoZQ0KPiBhZGRyZXNzZWUgb25s
eSwgYW5kIG1heSBjb250YWluIHRoZSBjb25maWRlbnRpYWwgaW5mb3JtYXRp
b24gb2YgVUNTDQo+IEdyb3VwIGFuZC9vciBpdHMgc3Vic2lkaWFyaWVzLiBB
bnkgcmV2aWV3LCB1c2Ugb3IgZGlzc2VtaW5hdGlvbg0KPiB0aGVyZW9mIGJ5
IGFueW9uZSBvdGhlciB0aGFuIHRoZSBpbnRlbmRlZCBhZGRyZXNzZWUgaXMg
cHJvaGliaXRlZC4gSWYNCj4geW91IGFyZSBub3QgdGhlIGludGVuZGVkIGFk
ZHJlc3NlZSBwbGVhc2Ugbm90aWZ5IHRoZSB3cml0ZXINCj4gaW1tZWRpYXRl
bHkgYW5kIGRlc3Ryb3kgdGhlIGUtbWFpbC4gVUNTIEdyb3VwIExpbWl0ZWQg
YW5kIGl0cw0KPiBzdWJzaWRpYXJpZXMgZGlzdGFuY2UgdGhlbXNlbHZlcyBm
cm9tIGFuZCBhY2NlcHQgbm8gbGlhYmlsaXR5IGZvcg0KPiB1bmF1dGhvcmlz
ZWQgdXNlIG9mIHRoZWlyIGUtbWFpbCBmYWNpbGl0aWVzIG9yIGUtbWFpbHMg
c2VudCBvdGhlciB0aGFuDQo+IHN0cmljdGx5IGZvciBidXNpbmVzcyBwdXJw
b3Nlcy4NCj4NCj4NCi0tDQpCcmFkIE5pY2hvbHNvbiAgNDE2LTY3My00MTA2
DQpEYXRhYmFzZSBBZG1pbmlzdHJhdG9yLCBBZmlsaWFzIENhbmFkYSBDb3Jw
Lg0KDQoNCg0KVGhlIGNvbnRlbnRzIG9mIGFuZCBhdHRhY2htZW50cyB0byB0
aGlzIGUtbWFpbCBhcmUgaW50ZW5kZWQgZm9yIHRoZSBhZGRyZXNzZWUgb25s
eSwgYW5kIG1heSBjb250YWluIHRoZSBjb25maWRlbnRpYWwgaW5mb3JtYXRp
b24gb2YgVUNTIEdyb3VwIGFuZC9vciBpdHMgc3Vic2lkaWFyaWVzLiAgQW55
IHJldmlldywgdXNlIG9yIGRpc3NlbWluYXRpb24gdGhlcmVvZiBieSBhbnlv
bmUgb3RoZXIgdGhhbiB0aGUgaW50ZW5kZWQgYWRkcmVzc2VlIGlzIHByb2hp
Yml0ZWQuICBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgYWRkcmVzc2Vl
IHBsZWFzZSBub3RpZnkgdGhlIHdyaXRlciBpbW1lZGlhdGVseSBhbmQgZGVz
dHJveSB0aGUgZS1tYWlsLiAgVUNTIEdyb3VwIExpbWl0ZWQgYW5kIGl0cyBz
dWJzaWRpYXJpZXMgZGlzdGFuY2UgdGhlbXNlbHZlcyBmcm9tIGFuZCBhY2Nl
cHQgbm8gbGlhYmlsaXR5IGZvciB1bmF1dGhvcmlzZWQgdXNlIG9mIHRoZWly
IGUtbWFpbCBmYWNpbGl0aWVzIG9yIGUtbWFpbHMgc2VudCBvdGhlciB0aGFu
IHN0cmljdGx5IGZvciBidXNpbmVzcyBwdXJwb3Nlcy4NCgotLSAKU2VudCB2
aWEgcGdzcWwtYWRtaW4gbWFpbGluZyBsaXN0IChwZ3NxbC1hZG1pbkBwb3N0
Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0
aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3Fs
LWFkbWluCg==