[GENERAL] orphaned PGDATA/base/ subdirectories

2007-03-13 Thread Reece Hart
setup: postgresql 8.1.8, x86_64, gnu/linux I recently used createdb -T to copy a large database and the process failed due to disk full, but the space wasn't freed after that failure. That led me to wonder how much of my disk usage was from failed or interrupted operations. In the 8.1.8 manual,

Re: [GENERAL] orphaned PGDATA/base/ subdirectories

2007-03-13 Thread Tom Lane
Reece Hart [EMAIL PROTECTED] writes: The manual clearly says that a each row in pg_database will have a corresponding subdirectory in base/. Is the converse also true, ie, should every subdir in base/ also have a row in pg_database? If so, am I safe to rm the unreferenced subdirectories?

Re: [GENERAL] orphaned PGDATA/base/ subdirectories

2007-03-13 Thread Reece Hart
On Tue, 2007-03-13 at 17:44 -0400, Tom Lane wrote: are you in the habit of banging on ^C repeatedly? I couldn't reproduce such a problem in a small amount of testing though. You mean C-c doesn't work like elevator buttons? It wouldn't surprise me that I hit repeatedly. I certainly

Re: [GENERAL] orphaned PGDATA/base/ subdirectories

2007-03-13 Thread Alvaro Herrera
Reece Hart wrote: On Tue, 2007-03-13 at 17:44 -0400, Tom Lane wrote: are you in the habit of banging on ^C repeatedly? I couldn't reproduce such a problem in a small amount of testing though. You mean C-c doesn't work like elevator buttons? No, it's much better because you can

Re: [GENERAL] orphaned PGDATA/base/ subdirectories

2007-03-13 Thread Reece Hart
On Tue, 2007-03-13 at 18:16 -0400, Alvaro Herrera wrote: On the other hand it would be scary to have the elevator change its mind on the middle of carrying you to 20th and suddenly opening the floor for dumping you to the basement instead. Which one would think is pretty much what must have

Re: [GENERAL] orphaned PGDATA/base/ subdirectories

2007-03-13 Thread Joshua D. Drake
Reece Hart wrote: On Tue, 2007-03-13 at 18:16 -0400, Alvaro Herrera wrote: On the other hand it would be scary to have the elevator change its mind on the middle of carrying you to 20th and suddenly opening the floor for dumping you to the basement instead. Which one would think is pretty