Re: [GENERAL] PITR and moving objects between table spaces

2006-12-12 Thread Glen Parker
You can probably make this work if you don't issue any CREATE TABLESPACE commands while PITR logging is active, but you'll want to test your procedures pretty carefully. That's what I thought, and after your message, I went ahead with it and had no problems. Thx, Tom. -Glen

Re: [GENERAL] PITR and moving objects between table spaces

2006-12-11 Thread Tom Lane
Glen Parker <[EMAIL PROTECTED]> writes: > I guess the best question I can see is, under what circumstances is the > directory name in pg_tablespace actually used? It isn't used (except by pg_dumpall) ... what counts is where the symlink in $PGDATA/pg_tblspc points. > I have a scenario where I wa

[GENERAL] PITR and moving objects between table spaces

2006-12-11 Thread Glen Parker
Gurus, I hope I can make this clear somehow... Anyway... This all involves PG 8.1.4 on a 64-bit FC5 box. Select version() says "PostgreSQL 8.1.4 on x86_64-redhat-linux-gnu, compiled by GCC x86_64-redhat-linux-gcc (GCC) 4.1.0 20060304 (Red Hat 4.1.0-3)". I guess the best question I can se