projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
show DB size
[freeside.git]
/
httemplate
/
view
/
Status.html
diff --git
a/httemplate/view/Status.html
b/httemplate/view/Status.html
index
f106087
..
7fd019e
100644
(file)
--- a/
httemplate/view/Status.html
+++ b/
httemplate/view/Status.html
@@
-25,14
+25,23
@@
if ( ! $@ && $os =~ /^\s*Description:\s*(.+)$/ ) {
( my $perl_ver = $^V ) =~ s/^v//;
my $db = driver_name;
( my $perl_ver = $^V ) =~ s/^v//;
my $db = driver_name;
-$db = 'PostgreSQL' if $db =~ /^Pg/;
-$db = 'MySQL
'
if $db =~ /^mysql/;
+$db = 'PostgreSQL'
if $db =~ /^Pg/;
+$db = 'MySQL
/MariaDB'
if $db =~ /^mysql/;
my $db_ver = FS::Record->scalar_sql('SELECT VERSION()');
if ( $db eq 'PostgreSQL' && $db_ver =~ /^\s*PostgreSQL\s+([\w\.]+)\s+on\s+/ ) {
$db_ver = $1;
}
my $db_ver = FS::Record->scalar_sql('SELECT VERSION()');
if ( $db eq 'PostgreSQL' && $db_ver =~ /^\s*PostgreSQL\s+([\w\.]+)\s+on\s+/ ) {
$db_ver = $1;
}
+my $db_size = 'Unknown';
+if ( $db eq 'PostgreSQL' ) {
+ $db_size = FS::Record->scalar_sql(qq(
+ SELECT pg_size_pretty(pg_database_size(datname))
+ FROM pg_catalog.pg_database
+ WHERE datname = 'freeside'
+ ));
+}
+
tie my %status, 'Tie::IxHash',
'Basics' => [
{ 'title' => 'Freeside version',
tie my %status, 'Tie::IxHash',
'Basics' => [
{ 'title' => 'Freeside version',
@@
-50,6
+59,9
@@
tie my %status, 'Tie::IxHash',
{ 'title' => 'Database version',
'value' => $db_ver,
},
{ 'title' => 'Database version',
'value' => $db_ver,
},
+ { 'title' => 'Database size',
+ 'value' => $db_size,
+ },
],
'Required Daemons' => [
{ 'title' => 'Queue daemon',
],
'Required Daemons' => [
{ 'title' => 'Queue daemon',
@@
-93,7
+105,7
@@
if ( $db eq 'PostgreSQL' ) {
&& FS::Record->scalar_sql('SHOW archive_mode') eq 'on';
my $slave =
&& FS::Record->scalar_sql('SHOW archive_mode') eq 'on';
my $slave =
- FS::Record->scalar_sql('SHOW archive_command') =~ / postgres\@([\w\.\-]): /
+ FS::Record->scalar_sql('SHOW archive_command') =~ / postgres\@([\w\.\-]
+
): /
? $1 : '';
$status{'Replication'} = [
? $1 : '';
$status{'Replication'} = [