pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Milen A. Radev <milen@securax.org>
To: Michael Fuhr <mike@fuhr.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Too frequent warnings for wraparound failure
Date: Thu, 10 Mar 2005 18:45:39 +0200
Message-ID: <423079B3.8050601@securax.org> (raw)
In-Reply-To: <20050310155734.GA86004@winnie.fuhr.org>
References: <42301107.6010901@securax.org>
	<20050310155734.GA86004@winnie.fuhr.org>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Michael Fuhr wrote:
> On Thu, Mar 10, 2005 at 11:19:03AM +0200, Milen A. Radev wrote:
> 
> 
>>exec /usr/local/pgsql/bin/vacuumdb -U postgres -h localhost \
>>- --all --analyze >>$PG_VACUUM_LOG 2>&1
> 
> 
> My first thought was that the lone hyphen at the beginning of the
> script's last line might be causing an end of option processing,

Well, that hyphen is inserted by Enigmail, so it's not part of the
actual script. Here it is again (hopefully not garbled):

BEGIN-------------------------------------------
#!/bin/sh
# cron script to vacuum pgsql databases
#

PG_VACUUM_LOG=/var/log/pg_vacuum

echo Starting at `date "+%Y-%m-%d %H:%M:%S"` >> $PG_VACUUM_LOG
exec /usr/local/pgsql/bin/vacuumdb -U postgres \
 -h localhost --all --analyze >>$PG_VACUUM_LOG 2>&1

END-------------------------------------------

> but your output does show many databases being vacuumed (do all
> databases appear in the real output?).  However, I tried running

Yes, they all appear in the log.

> that script with several versions of PostgreSQL and vacuumdb failed
> with a usage error in every case.  Are you sure the script you
> posted is the one that's running?  What version of PostgreSQL are
> you using?  As Tom mentioned, what's the output of the following

7.4.7 on Debian GNU/Linux 3.0 (Woody)[Linux xxxx 2.6.10 #1 SMP Thu Feb
10 18:52:12 EET 2005 i686 unknown]

> query?
> 
> SELECT datname, age(datfrozenxid) FROM pg_database;
> 


Two queries - 2 seconds apart:

template1=# SELECT datname, age(datfrozenxid) FROM pg_database;
  datname  |     age
- -----------+-------------
 xxx1      |  1519763573
 xxx2      |  1519754033
 xxx3      |  1519592503
 template1 |  1517875932
 template0 | -1808458730
 xxx4      |  1517860620
 xxx5      |  1517786431
 xxx6      |  1517780441
 xxx7      |  1517762875
 xxx8      |  1517755876
 xxx9      |  1517749309
 xxx10     |  1516823602
(12 rows)

template1=# SELECT datname, age(datfrozenxid) FROM pg_database;
  datname  |     age
- -----------+-------------
 xxx1      |  1519769620
 xxx2      |  1519760080
 xxx3      |  1519598550
 template1 |  1517881979
 template0 | -1808452683
 xxx4      |  1517866667
 xxx5      |  1517792478
 xxx6      |  1517786488
 xxx7      |  1517768922
 xxx8      |  1517761923
 xxx9      |  1517755356
 xxx10     |  1516829649
(12 rows)


- --
Milen A. Radev
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCMHmzqGlhYx0/sboRAsEFAJ0RWe8XVtLWWiOOrt46Nwg9xBD4hgCePhP9
YyYfj2LsKUCIFeheS71iI44=
=TDVO
-----END PGP SIGNATURE-----



view thread (14+ messages)  latest in thread

Message-ID: <423079B3.8050601@securax.org>
Permalink:  ../423079B3.8050601@securax.org/
Also on:    postgresql.org/message-id/423079B3.8050601@securax.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: milen@securax.org, mike@fuhr.org
  Subject: Re: Too frequent warnings for wraparound failure
  In-Reply-To: <423079B3.8050601@securax.org>
  References: <42301107.6010901@securax.org> <20050310155734.GA86004@winnie.fuhr.org> <423079B3.8050601@securax.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox