pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_temp_xxx schemas
2+ messages / 2 participants
[nested] [flat]

* pg_temp_xxx schemas
@ 2005-04-12 14:41  Marcin Giedz <marcin.giedz@eulerhermes.pl>
  0 siblings, 1 reply; 2+ messages in thread

From: Marcin Giedz @ 2005-04-12 14:41 UTC (permalink / raw)
  To: pgsql-admin

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? 

Thx,
Marcin



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pg_temp_xxx schemas
@ 2005-04-18 17:08  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Marcin Giedz <marcin.giedz@eulerhermes.pl>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2005-04-18 17:08 UTC (permalink / raw)
  To: Marcin Giedz <marcin.giedz@eulerhermes.pl>; +Cc: 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-04-18 17:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-12 14:41 pg_temp_xxx schemas Marcin Giedz <marcin.giedz@eulerhermes.pl>
2005-04-18 17:08 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox