12:11 a.m.
I have a problem on my oVirt manager, the problem is that the directory
/var/lib/pgsql/data fills.
Initially thinking that my file system /var/log 2Gb was too small now have
increased to 4Gb and is refilled, i have increased again to 5 Gb and is
refilled again.
Why ?
I have implemented the backup of the manager with the script backup.sh, this
could be the cause of the problem ?
Regards
Massimo
12:25 a.m.
This is a multi-part message in MIME format.
--------------040302080100080607040003
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Hi Massimo,
Please check what is going on with your postgresql DB.
1) Log into the ovirt-engine VM
2) su - postgres
3) query table sizes with:
psql engine -c "SELECT nspname || '.' || relname AS relation,
pg_size_pretty(pg_relation_size(C.oid)) AS size
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE nspname NOT IN ('pg_catalog', 'information_schema')
ORDER BY pg_relation_size(C.oid) DESC
LIMIT 20;"
Probably it's the "audit_log" table.
On 24-02-2015 18:11, Massimo Mad wrote:
I have a problem on my oVirt manager, the problem is that the
directory /var/lib/pgsql/data fills.
Initially thinking that my file system /var/log 2Gb was too small now
have increased to 4Gb and is refilled, i have increased again to 5 Gb
and is refilled again.
Why ?
I have implemented the backup of the manager with the script
backup.sh, this could be the cause of the problem?
Regards
Massimo
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
--------------040302080100080607040003
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: 8bit
<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Massimo,<br>
<br>
Please check what is going on with your postgresql DB.<br>
<br>
1) Log into the ovirt-engine VM<br>
2) su - postgres<br>
3) query table sizes with:<br>
<br>
psql engine -c "SELECT nspname || '.' || relname AS
relation,<br>
pg_size_pretty(pg_relation_size(C.oid)) AS size<br>
FROM pg_class C<br>
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)<br>
WHERE nspname NOT IN ('pg_catalog',
'information_schema')<br>
ORDER BY pg_relation_size(C.oid) DESC<br>
LIMIT 20;"<br>
<br>
Probably it's the "audit_log" table.<br>
<br>
<div class="moz-signature">
<style>
.signature, .small-signature {
font-family:"Calibri","sans-serif";mso-fareast-font-family:"Times
New Roman";
color:#7F7F7F;
}
.signature {
font-size:10pt;
}
.small-signature {
font-size:8pt;
}</style>On 24-02-2015 18:11, Massimo Mad wrote:<br>
</div>
</div>
<blockquote
cite="mid:CADXHJqJzgQ04xnQafvi3GwqdRTk4iwLo1Hb8ScdovRQ8djV6CA@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>I have a problem on my oVirt manager, the problem is that
the directory /var/lib/pgsql/data fills.<br>
Initially thinking that my file system /var/log 2Gb was too
small now have increased to 4Gb and is refilled, i have
increased again to 5 Gb and is refilled again.<br>
Why ?<br>
<span id="result_box" class=""
lang="en"><span class="">I
have implemented the backup of the manager with the
script backup.sh, t</span></span><span
id="result_box"
class="" lang="en"><span class="">his
could be</span> <span
class="">the cause</span> <span
class="">of the problem</span><span
class=""> ?<br>
</span></span></div>
<span id="result_box" class=""
lang="en"><span class="">Regards<br>
</span></span></div>
<span id="result_box" class=""
lang="en"><span class="">Massimo<br>
</span></span>
<div>
<div><span id="result_box" class=""
lang="en"><span
class=""></span></span></div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated"
href="mailto:Users@ovirt.org">Users@ovirt.org</a>
<a class="moz-txt-link-freetext"
href="http://lists.ovirt.org/mailman/listinfo/users">http://...
</pre>
</blockquote>
<br>
</body>
</html>
--------------040302080100080607040003--
3559
days inactive
3559
days old
1 comments
2 participants
participants (2)
-
Christopher Pereira -
Massimo Mad