| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Marcin Giedz <marcin(dot)giedz(at)eulerhermes(dot)pl> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_temp_xxx schemas |
| Date: | 2005-04-18 17:08:33 |
| Message-ID: | 200504181708.j3IH8XF27875@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Marcin Giedz wrote:
> Hello...
>
> Last time I found that about 200 schemas have appeared in my database. These
> schemas are pg_temp_xxxx. What's this? Can I remove it safely or these
> schemas will be removed automatically?
They are reused by new connections but can be removed if not being used
and they will be recreated.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gustavo Franklin Nóbrega - Planae | 2005-04-18 17:24:40 | RES: pg_enconding |
| Previous Message | Bruce Momjian | 2005-04-18 17:06:05 | Re: question about wal and point in time recovery |