Re: [BUGS] pg_restore problem

2006-05-31 Thread Harco de Hilster
I had similar problems with the tar format. 3 smaller databases worked, the biggest did not. Switching to -Fc fixed it for me. Sorry for not reporting this. Harco Tom Lane wrote: Michael Andreasen [EMAIL PROTECTED] writes: pg_dump -Ft $db | bzip2 $db.dump.tbz ... pg_restore: [tar

[BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

2006-03-23 Thread Harco de Hilster
Hi all, vacuumdb (and autovacuum) fails for two of nine databases with the error message: vacuumdb -v -e -z pgcmisnlt1 VACUUM VERBOSE ANALYZE; INFO: vacuuming information_schema.sql_features vacuumdb: vacuuming of database pgcmisnlt1 failed: ERROR: invalid memory alloc request size

Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

2006-03-23 Thread Harco de Hilster
That did the trick. Thanks. Kind regards, Harco Tom Lane wrote: Harco de Hilster [EMAIL PROTECTED] writes: (gdb) bt #0 MemoryContextAlloc (context=0x8b3a10, size=4294967292) at mcxt.c:505 #1 0x004e06f9 in lazy_vacuum_rel (onerel=0x2a955ecbd8, vacstmt=0x8bf390