PostgreSQL 6.3.2 said:

NOTICE:  BlowawayRelationBuffers(places, 322): block 336 is referenced
(private 0, last 0, global 1)
FATAL 1:  VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2

And now I need to go find the vacuum lock file and blow it away, but I
don't really understand the above message, so wanna ask if I need to worry
about it...

-- "TANSTAAFL" Rich lynch@cognitivearts.com   webmaster@  and www. all of:
R&B/jazz/blues/rock - jademaze.com      music industry org - chatmusic.com
acoustic/funk/world-beat - astrakelly.com   sculptures - olivierledoux.com
my own nascent company - l-i-e.com   cool coffeehouse - uncommonground.com



Sat, 24 Apr 1999 21:17:58 -0500
lynch@cognitivearts.com (Richard Lynch)
Vacuum Crash
Richard Lynch wrote:
> 
> PostgreSQL 6.3.2 said:
> 
> NOTICE:  BlowawayRelationBuffers(places, 322): block 336 is referenced
> (private 0, last 0, global 1)
> FATAL 1:  VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
> 
> And now I need to go find the vacuum lock file and blow it away, but I
> don't really understand the above message, so wanna ask if I need to worry
> about it...

Restart postmaster, remove pg_vlock file and run vacuum again.

Vadim

Sun, 25 Apr 1999 23:58:47 +0800
Vadim Mikheev <vadim@krs.ru>
Re: [GENERAL] Vacuum Crash
Using pg_dump with 6.5b1 on solaris sparc, crashes with a core dump.

This means I can't keep backups and I can't upgrade my data model without
being able to export the old data.

If one of the developers wants debug info let me know what you need (e.g.,
what commands to run in gdb--though I'll have to install this or get run
permissions from the sysadmin).

-- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/>
PGP public key available at <http://www.magiccookie.com/pgpkey.txt>



Mon, 24 May 1999 13:45:24 -0500
Ari Halberstadt <ari@shore.net>
pg_dump core dumps
Beta1 is kind of old.  Also, this is clearly a hackers list question.  I
recommend you try the most recent snapshot from ftp.postgresql.org.


> Using pg_dump with 6.5b1 on solaris sparc, crashes with a core dump.
> 
> This means I can't keep backups and I can't upgrade my data model without
> being able to export the old data.
> 
> If one of the developers wants debug info let me know what you need (e.g.,
> what commands to run in gdb--though I'll have to install this or get run
> permissions from the sysadmin).
> 
> -- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/>
> PGP public key available at <http://www.magiccookie.com/pgpkey.txt>
> 
> 
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 24 May 1999 17:24:06 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [GENERAL] pg_dump core dumps