Difference between revisions of "SQWareRepository:postgres"

From Wiki_dbSQWare
Jump to: navigation, search
(Replaced content with '{{SQWareRepositoryPresSgbd|PostgreSQL|database|instances|pg}} == Specific database content for PostgreSQL ==')
 
Line 1: Line 1:
 
{{SQWareRepositoryPresSgbd|PostgreSQL|database|instances|pg}}
 
{{SQWareRepositoryPresSgbd|PostgreSQL|database|instances|pg}}
 
== Specific database content for PostgreSQL ==
 
== Specific database content for PostgreSQL ==
 +
 +
{{SQWareRepositoryTables|tsqwpg_Parameters|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date date
 +
name varchar(255)
 +
value varchar(255)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwpg_VolArchlogs|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
nb_arch decimal(12,2)
 +
size_arch decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwpg_VolArchlogsDetail|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
filename varchar(255)
 +
destination varchar(512)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwpg_VolArchlogsHourly|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
nb_arch decimal(12,2)
 +
size_arch decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwpg_VolDb|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
database_name varchar(255)
 +
gather_date date
 +
size_db decimal(12,2)
 +
owner varchar(255)
 +
encoding varchar(255)
 +
datcollate varchar(255)
 +
datctype varchar(255)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwpg_VolTables|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date date
 +
database_name varchar(255)
 +
table_schema varchar(64)
 +
table_name varchar(64)
 +
table_rows decimal(10,0)
 +
total_length decimal(12,2)
 +
heap_length decimal(12,2)
 +
toast_length decimal(12,2)
 +
index_length decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwpg_VolTbs|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
tablespace_name varchar(80)
 +
gather_date date
 +
size_tbs decimal(12,2)
 +
owner varchar(255)
 +
spclocation varchar(800)
 +
</pre>
 +
}}

Latest revision as of 18:16, 8 August 2015

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwpg_% or isqwpg_% are specific for PostgreSQL.
Installation guide for SQWareRepository for PostgreSQL

Naming convention

All specific objects for PostgreSQL are named with prefixes:

  • tsqwpg_% : for tables
  • isqwpg_% : for index
  • isqwpg_%_u : for uniques
  • isqwpg_%_pk : for primary key


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for PostgreSQL

tsqwpg_Parameters

This table contains : ...
Desc of tsqwpg_Parameters :

Field Type
dbalias varchar(80)
gather_date date
name varchar(255)
value varchar(255)


tsqwpg_VolArchlogs

This table contains : ...
Desc of tsqwpg_VolArchlogs :

Field Type
dbalias varchar(80)
gather_date datetime
nb_arch decimal(12,2)
size_arch decimal(12,2)


tsqwpg_VolArchlogsDetail

This table contains : ...
Desc of tsqwpg_VolArchlogsDetail :

Field Type
dbalias varchar(80)
gather_date datetime
filename varchar(255)
destination varchar(512)


tsqwpg_VolArchlogsHourly

This table contains : ...
Desc of tsqwpg_VolArchlogsHourly :

Field Type
dbalias varchar(80)
gather_date datetime
nb_arch decimal(12,2)
size_arch decimal(12,2)


tsqwpg_VolDb

This table contains : ...
Desc of tsqwpg_VolDb :

Field Type
dbalias varchar(80)
database_name varchar(255)
gather_date date
size_db decimal(12,2)
owner varchar(255)
encoding varchar(255)
datcollate varchar(255)
datctype varchar(255)


tsqwpg_VolTables

This table contains : ...
Desc of tsqwpg_VolTables :

Field Type
dbalias varchar(80)
gather_date date
database_name varchar(255)
table_schema varchar(64)
table_name varchar(64)
table_rows decimal(10,0)
total_length decimal(12,2)
heap_length decimal(12,2)
toast_length decimal(12,2)
index_length decimal(12,2)


tsqwpg_VolTbs

This table contains : ...
Desc of tsqwpg_VolTbs :

Field Type
dbalias varchar(80)
tablespace_name varchar(80)
gather_date date
size_tbs decimal(12,2)
owner varchar(255)
spclocation varchar(800)