Postgres Pro
Downloads
Home   >   mailing lists

upgraded to 7.3.2 and now see pg_temp_x databases? - Mailing list pgsql-general

From Patrick Hatcher
Subject upgraded to 7.3.2 and now see pg_temp_x databases?
Date
Msg-id OF073CA84A.2DC5F6A2-ON88256CF0.0065EED3-88256CF0.0066D451@fds.com
Whole thread Raw
Responses Re: upgraded to 7.3.2 and now see pg_temp_x databases?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I upgraded from 7.2 to 7.3.2 and everything works great.  However, when I
open pgAdminII, I  see three empty databases named pg_temp_2,pg_temp_4 and
pg_temp_8.  What are these, and are they safe to remove?  I assumed they
were created as temp space while the database was doing one of its nightly
batch jobs. I also assumed it would disappear if I did a vacuum full on the
database, but they are still there.

TIA

Patrick Hatcher

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: ERROR: out of free buffers: time to abort!
Next
From: Fernando Schapachnik
Date:
Subject: Re: Posts get losts