Gary Fu <gfu@xxxxxxxxxxxxx> writes: > My question now is why those temporary schemas won't be cleaned > after I restart the db ? Just leave them alone and you'll be fine. These tools actually have had most of the bugs worked out of them ;-) ... if you think pg_dump is omitting something, you are probably mistaken. regards, tom lane