Re: Too frequent warnings for wraparound failure

-----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-----