public inbox for [email protected]
help / color / mirror / Atom feedFwd: borg.postgresql.org daily run output
7+ messages / 5 participants
[nested] [flat]
* Fwd: borg.postgresql.org daily run output
@ 2006-06-13 17:09 Gavin M. Roy <[email protected]>
2006-06-13 18:41 ` Re: Fwd: borg.postgresql.org daily run output Jim C. Nasby <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Gavin M. Roy @ 2006-06-13 17:09 UTC (permalink / raw)
To: pgsql-www
If I'm reading the df output correctly for the vm drive on borg, it's
out of disk space and probably needs a little bit of pruning,
specifically:
> /dev/aacd0s1h 26345632 24137956 100026 100% /vm
Gavin
Begin forwarded message:
> From: Charlie Root <[email protected]>
> Date: June 13, 2006 3:01:41 AM PDT
> To: [email protected]
> Subject: borg.postgresql.org daily run output
>
>
> Removing stale files from /var/preserve:
>
> Cleaning out old system announcements:
>
> Removing stale files from /var/rwho:
>
> Backup passwd and group files:
>
> Verifying group file syntax:
>
> Backing up mail aliases:
>
> Disk status:
> Filesystem 1K-blocks Used Avail Capacity Mounted on
> /dev/aacd0s1a 257998 47850 189510 20% /
> /dev/aacd0s1e 128990 8 118664 0% /tmp
> /dev/aacd0s1f 5161198 3084162 1664142 65% /usr
> /dev/aacd0s1g 1032142 7028 942544 1% /var
> /dev/aacd0s1h 26345632 24137956 100026 100% /vm
> procfs 4 4 0 100% /proc
> procfs 4 4 0 100% /vm/186/
> svr2.postgresql.org/proc
> <below>:/vm/.t2/usr 52691264 50483588 100026 100% /vm/186/
> svr2.postgresql.org/usr
> procfs 4 4 0 100% /vm/186/
> wwwmaster.postgresql.org/proc
>
> Last dump(s) done (Dump '>' file systems):
>
> UUCP status:
>
> Network interface status:
> Name Mtu Network Address Ipkts Ierrs Opkts
> Oerrs Coll
> fxp0 1500 <Link#1> 00:b0:d0:e1:a0:02 19783853 0
> 17207245 0 0
> fxp0 1500 65.19.161/25 borg 15994471 -
> 31571905 - -
> fxp0 1500 fe80:1::2b0 fe80:1::2b0:d0ff: 0 -
> 2 - -
> fxp0 1500 65.19.161.25/ wwwmaster 68815226 -
> 58028755 - -
> fxp0 1500 65.19.161.90/ svr2 6501226 -
> 2825775 - -
> bge0* 1500 <Link#2> 00:b0:d0:e1:a0:03 0 0
> 0 0 0
> ppp0* 1500 <Link#3> 0 0
> 0 0 0
> sl0* 552 <Link#4> 0 0
> 0 0 0
> faith 1500 <Link#5> 0 0
> 0 0 0
> lo0 16384 <Link#6> 80071612 0
> 80071612 0 0
> lo0 16384 localhost ::1 4846706 -
> 4846706 - -
> lo0 16384 fe80:6::1 fe80:6::1 0 -
> 0 - -
> lo0 16384 your-net localhost 3450 -
> 3450 - -
>
> Local network system status:
> borg up 37+11:19, 0 users, load 0.00, 0.01, 0.01
>
> Mail in local queue:
> /var/spool/mqueue is empty
> Total requests: 0
>
> Mail in submit queue:
> /var/spool/clientmqueue is empty
> Total requests: 0
>
> Security check:
> (output mailed separately)
>
> Checking for rejected mail hosts:
>
> Checking for denied zone transfers (AXFR and IXFR):
>
> -- End of daily output --
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fwd: borg.postgresql.org daily run output
2006-06-13 17:09 Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
@ 2006-06-13 18:41 ` Jim C. Nasby <[email protected]>
2006-06-13 18:44 ` Re: Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Jim C. Nasby @ 2006-06-13 18:41 UTC (permalink / raw)
To: Gavin M. Roy <[email protected]>; +Cc: pgsql-www
On Tue, Jun 13, 2006 at 10:09:06AM -0700, Gavin M. Roy wrote:
> If I'm reading the df output correctly for the vm drive on borg, it's
> out of disk space and probably needs a little bit of pruning,
> specifically:
>
> >/dev/aacd0s1h 26345632 24137956 100026 100% /vm
If there's nothing else monitoring this it'd be worth at least setting
up http://jim.nasby.net/code/dfmon/ and having it email someplace.
The irc monitor stuff is a bot we have setup to send alerts to some IRC
channels; if there's interest in setting that up for PostgreSQL, I can
provide that code.
--
Jim C. Nasby, Database Architect [email protected]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fwd: borg.postgresql.org daily run output
2006-06-13 17:09 Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
2006-06-13 18:41 ` Re: Fwd: borg.postgresql.org daily run output Jim C. Nasby <[email protected]>
@ 2006-06-13 18:44 ` Gavin M. Roy <[email protected]>
2006-06-13 18:49 ` Re: Fwd: borg.postgresql.org daily run output Jim C. Nasby <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Gavin M. Roy @ 2006-06-13 18:44 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: pgsql-www
There's a nightly email that is sent. I'm looking into having it
sent to a list so more people can get their eyes on it.
Gavin
On Jun 13, 2006, at 11:41 AM, Jim C. Nasby wrote:
> On Tue, Jun 13, 2006 at 10:09:06AM -0700, Gavin M. Roy wrote:
>> If I'm reading the df output correctly for the vm drive on borg, it's
>> out of disk space and probably needs a little bit of pruning,
>> specifically:
>>
>>> /dev/aacd0s1h 26345632 24137956 100026 100% /vm
>
> If there's nothing else monitoring this it'd be worth at least setting
> up http://jim.nasby.net/code/dfmon/ and having it email someplace.
>
> The irc monitor stuff is a bot we have setup to send alerts to some
> IRC
> channels; if there's interest in setting that up for PostgreSQL, I can
> provide that code.
> --
> Jim C. Nasby, Database Architect [email protected]
> Give your computer some brain candy! www.distributed.net Team #1828
>
> Windows: "Where do you want to go today?"
> Linux: "Where do you want to go tomorrow?"
> FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fwd: borg.postgresql.org daily run output
2006-06-13 17:09 Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
2006-06-13 18:41 ` Re: Fwd: borg.postgresql.org daily run output Jim C. Nasby <[email protected]>
2006-06-13 18:44 ` Re: Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
@ 2006-06-13 18:49 ` Jim C. Nasby <[email protected]>
2006-06-13 19:20 ` Re: Fwd: borg.postgresql.org daily run output Joshua D. Drake <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Jim C. Nasby @ 2006-06-13 18:49 UTC (permalink / raw)
To: Gavin M. Roy <[email protected]>; +Cc: pgsql-www
On Tue, Jun 13, 2006 at 11:44:48AM -0700, Gavin M. Roy wrote:
> There's a nightly email that is sent. I'm looking into having it
> sent to a list so more people can get their eyes on it.
Yeah, I'm familiar with the nightly FBSD emails, but there's two issues:
1) They only come out once a day
2) You have to actively dig to see if there's an issue
ISTM it'd be better to find out about a pending out-of-space issue
beforehand and not rely on someone noticining it in an email. And if you
do hit 100%, it'd be really good to find out sooner than that night.
Though I will say that it's a good thing to have multiple people looking
at the nightly run output...
--
Jim C. Nasby, Database Architect [email protected]
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fwd: borg.postgresql.org daily run output
2006-06-13 17:09 Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
2006-06-13 18:41 ` Re: Fwd: borg.postgresql.org daily run output Jim C. Nasby <[email protected]>
2006-06-13 18:44 ` Re: Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
2006-06-13 18:49 ` Re: Fwd: borg.postgresql.org daily run output Jim C. Nasby <[email protected]>
@ 2006-06-13 19:20 ` Joshua D. Drake <[email protected]>
0 siblings, 0 replies; 7+ messages in thread
From: Joshua D. Drake @ 2006-06-13 19:20 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Gavin M. Roy <[email protected]>; pgsql-www
Jim C. Nasby wrote:
> On Tue, Jun 13, 2006 at 11:44:48AM -0700, Gavin M. Roy wrote:
>> There's a nightly email that is sent. I'm looking into having it
>> sent to a list so more people can get their eyes on it.
>
> Yeah, I'm familiar with the nightly FBSD emails, but there's two issues:
>
> 1) They only come out once a day
> 2) You have to actively dig to see if there's an issue
>
> ISTM it'd be better to find out about a pending out-of-space issue
> beforehand and not rely on someone noticining it in an email. And if you
> do hit 100%, it'd be really good to find out sooner than that night.
>
> Though I will say that it's a good thing to have multiple people looking
> at the nightly run output...
Happy to run a disk free via nagios if given the perms.
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fwd: borg.postgresql.org daily run output
@ 2006-06-13 17:33 Magnus Hagander <[email protected]>
2006-06-13 18:20 ` Re: Fwd: borg.postgresql.org daily run output Robert Treat <[email protected]>
0 siblings, 1 reply; 7+ messages in thread
From: Magnus Hagander @ 2006-06-13 17:33 UTC (permalink / raw)
To: Gavin M. Roy <[email protected]>; pgsql-www
I've cleaned some, so it's now:
/dev/aacd0s1h 25G 22G 1.4G 94% /vm
Hard to do much more - the huge part is the ftp site. What we really
need is to get rid of svr2, which means get the rest of techdocs over to
the new site. (techdocs uses well over a gig of space on it's own, and
is the only reason svr2 is still around there).
Robert, where are we on the move of content?
//Magnus
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Gavin M. Roy
> Sent: Tuesday, June 13, 2006 7:09 PM
> To: PostgreSQL www
> Subject: [pgsql-www] Fwd: borg.postgresql.org daily run output
>
> If I'm reading the df output correctly for the vm drive on
> borg, it's out of disk space and probably needs a little bit
> of pruning, specifically:
>
>
> /dev/aacd0s1h 26345632 24137956 100026 100% /vm
>
>
> Gavin
>
>
>
> Begin forwarded message:
>
>
> From: Charlie Root <[email protected]>
> Date: June 13, 2006 3:01:41 AM PDT
> To: [email protected]
> Subject: borg.postgresql.org daily run output
>
>
> Removing stale files from /var/preserve:
>
> Cleaning out old system announcements:
>
> Removing stale files from /var/rwho:
>
> Backup passwd and group files:
>
> Verifying group file syntax:
>
> Backing up mail aliases:
>
> Disk status:
> Filesystem 1K-blocks Used Avail Capacity
> Mounted on
> /dev/aacd0s1a 257998 47850 189510 20% /
> /dev/aacd0s1e 128990 8 118664 0% /tmp
> /dev/aacd0s1f 5161198 3084162 1664142 65% /usr
> /dev/aacd0s1g 1032142 7028 942544 1% /var
> /dev/aacd0s1h 26345632 24137956 100026 100% /vm
> procfs 4 4 0 100% /proc
> procfs 4 4 0 100%
> /vm/186/svr2.postgresql.org/proc
> <below>:/vm/.t2/usr 52691264 50483588 100026 100%
> /vm/186/svr2.postgresql.org/usr
> procfs 4 4 0 100%
> /vm/186/wwwmaster.postgresql.org/proc
>
> Last dump(s) done (Dump '>' file systems):
>
> UUCP status:
>
> Network interface status:
> Name Mtu Network Address Ipkts
> Ierrs Opkts Oerrs Coll
> fxp0 1500 <Link#1> 00:b0:d0:e1:a0:02 19783853
> 0 17207245 0 0
> fxp0 1500 65.19.161/25 borg 15994471
> - 31571905 - -
> fxp0 1500 fe80:1::2b0 fe80:1::2b0:d0ff: 0
> - 2 - -
> fxp0 1500 65.19.161.25/ wwwmaster 68815226
> - 58028755 - -
> fxp0 1500 65.19.161.90/ svr2 6501226
> - 2825775 - -
> bge0* 1500 <Link#2> 00:b0:d0:e1:a0:03 0
> 0 0 0 0
> ppp0* 1500 <Link#3> 0
> 0 0 0 0
> sl0* 552 <Link#4> 0
> 0 0 0 0
> faith 1500 <Link#5> 0
> 0 0 0 0
> lo0 16384 <Link#6> 80071612
> 0 80071612 0 0
> lo0 16384 localhost ::1 4846706
> - 4846706 - -
> lo0 16384 fe80:6::1 fe80:6::1 0
> - 0 - -
> lo0 16384 your-net localhost 3450
> - 3450 - -
>
> Local network system status:
> borg up 37+11:19, 0 users, load 0.00, 0.01, 0.01
>
> Mail in local queue:
> /var/spool/mqueue is empty
> Total requests: 0
>
> Mail in submit queue:
> /var/spool/clientmqueue is empty
> Total requests: 0
>
> Security check:
> (output mailed separately)
>
> Checking for rejected mail hosts:
>
> Checking for denied zone transfers (AXFR and IXFR):
>
> -- End of daily output --
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Fwd: borg.postgresql.org daily run output
2006-06-13 17:33 Re: Fwd: borg.postgresql.org daily run output Magnus Hagander <[email protected]>
@ 2006-06-13 18:20 ` Robert Treat <[email protected]>
0 siblings, 0 replies; 7+ messages in thread
From: Robert Treat @ 2006-06-13 18:20 UTC (permalink / raw)
To: pgsql-www; +Cc: Magnus Hagander <[email protected]>; Gavin M. Roy <[email protected]>
I've cleaned up my personal directory on there a little bit, which should give
us a little more space (at least a couple hundred MB's anyway).
As for the techdoc migration, I do have a plan for getting it finished, just
haven't had time to focus on it. I've currently got some website updates, a
slew of phppgadmin patches to look at, and my oscon presentation sitting in
front of me , assuming nothing else comes up... I'll see if I can work in
some changes though...
Robert Treat
On Tuesday 13 June 2006 13:33, Magnus Hagander wrote:
> I've cleaned some, so it's now:
> /dev/aacd0s1h 25G 22G 1.4G 94% /vm
>
> Hard to do much more - the huge part is the ftp site. What we really
> need is to get rid of svr2, which means get the rest of techdocs over to
> the new site. (techdocs uses well over a gig of space on it's own, and
> is the only reason svr2 is still around there).
>
> Robert, where are we on the move of content?
>
> //Magnus
>
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]] On Behalf Of Gavin M. Roy
> > Sent: Tuesday, June 13, 2006 7:09 PM
> > To: PostgreSQL www
> > Subject: [pgsql-www] Fwd: borg.postgresql.org daily run output
> >
> > If I'm reading the df output correctly for the vm drive on
> > borg, it's out of disk space and probably needs a little bit
> > of pruning, specifically:
> >
> >
> > /dev/aacd0s1h 26345632 24137956 100026 100% /vm
> >
> >
> > Gavin
> >
> >
> >
> > Begin forwarded message:
> >
> >
> > From: Charlie Root <[email protected]>
> > Date: June 13, 2006 3:01:41 AM PDT
> > To: [email protected]
> > Subject: borg.postgresql.org daily run output
> >
> >
> > Removing stale files from /var/preserve:
> >
> > Cleaning out old system announcements:
> >
> > Removing stale files from /var/rwho:
> >
> > Backup passwd and group files:
> >
> > Verifying group file syntax:
> >
> > Backing up mail aliases:
> >
> > Disk status:
> > Filesystem 1K-blocks Used Avail Capacity
> > Mounted on
> > /dev/aacd0s1a 257998 47850 189510 20% /
> > /dev/aacd0s1e 128990 8 118664 0% /tmp
> > /dev/aacd0s1f 5161198 3084162 1664142 65% /usr
> > /dev/aacd0s1g 1032142 7028 942544 1% /var
> > /dev/aacd0s1h 26345632 24137956 100026 100% /vm
> > procfs 4 4 0 100% /proc
> > procfs 4 4 0 100%
> > /vm/186/svr2.postgresql.org/proc
> > <below>:/vm/.t2/usr 52691264 50483588 100026 100%
> > /vm/186/svr2.postgresql.org/usr
> > procfs 4 4 0 100%
> > /vm/186/wwwmaster.postgresql.org/proc
> >
> > Last dump(s) done (Dump '>' file systems):
> >
> > UUCP status:
> >
> > Network interface status:
> > Name Mtu Network Address Ipkts
> > Ierrs Opkts Oerrs Coll
> > fxp0 1500 <Link#1> 00:b0:d0:e1:a0:02 19783853
> > 0 17207245 0 0
> > fxp0 1500 65.19.161/25 borg 15994471
> > - 31571905 - -
> > fxp0 1500 fe80:1::2b0 fe80:1::2b0:d0ff: 0
> > - 2 - -
> > fxp0 1500 65.19.161.25/ wwwmaster 68815226
> > - 58028755 - -
> > fxp0 1500 65.19.161.90/ svr2 6501226
> > - 2825775 - -
> > bge0* 1500 <Link#2> 00:b0:d0:e1:a0:03 0
> > 0 0 0 0
> > ppp0* 1500 <Link#3> 0
> > 0 0 0 0
> > sl0* 552 <Link#4> 0
> > 0 0 0 0
> > faith 1500 <Link#5> 0
> > 0 0 0 0
> > lo0 16384 <Link#6> 80071612
> > 0 80071612 0 0
> > lo0 16384 localhost ::1 4846706
> > - 4846706 - -
> > lo0 16384 fe80:6::1 fe80:6::1 0
> > - 0 - -
> > lo0 16384 your-net localhost 3450
> > - 3450 - -
> >
> > Local network system status:
> > borg up 37+11:19, 0 users, load 0.00, 0.01, 0.01
> >
> > Mail in local queue:
> > /var/spool/mqueue is empty
> > Total requests: 0
> >
> > Mail in submit queue:
> > /var/spool/clientmqueue is empty
> > Total requests: 0
> >
> > Security check:
> > (output mailed separately)
> >
> > Checking for rejected mail hosts:
> >
> > Checking for denied zone transfers (AXFR and IXFR):
> >
> > -- End of daily output --
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2006-06-13 19:20 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-13 17:09 Fwd: borg.postgresql.org daily run output Gavin M. Roy <[email protected]>
2006-06-13 18:41 ` Jim C. Nasby <[email protected]>
2006-06-13 18:44 ` Gavin M. Roy <[email protected]>
2006-06-13 18:49 ` Jim C. Nasby <[email protected]>
2006-06-13 19:20 ` Joshua D. Drake <[email protected]>
2006-06-13 17:33 Re: Fwd: borg.postgresql.org daily run output Magnus Hagander <[email protected]>
2006-06-13 18:20 ` Robert Treat <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox