| From: | Christoph Berg <myon(at)debian(dot)org> |
|---|---|
| To: | Adarsh Sharma <eddy(dot)adarsh(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Unknown database folders in base directory |
| Date: | 2018-06-07 08:58:12 |
| Message-ID: | 20180607085812.GA16531@msg.df7cb.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Re: Adarsh Sharma 2018-06-07 <CAGx-QqKyW-UuMTw9Vw9uCX_Af+8GhS1HdkNLt6uV9DnxQGV0eg(at)mail(dot)gmail(dot)com>
> *drwx------ 2 postgres postgres 163840 Mar 19 18:18 2567078690*
> *drwx------ 2 postgres postgres 237568 Mar 19 19:10 2567168798*
> *drwx------ 2 postgres postgres 151552 Mar 19 19:19 2567176994*
> *drwx------ 2 postgres postgres 172032 Mar 19 19:34 2567193375*
These have all similar timestamps. Were you repeatedly trying to
create new databases at that time, but ran out of disk space and
PostgreSQL was panicing? That would explain the issue.
You can safely remove old database directories that are not referenced
in pg_database - you don't even need to shut down first, as PostgreSQL
doesn't know about the files anymore.
Christoph
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pinker | 2018-06-07 09:32:53 | Plans cache eviction from process local Memory |
| Previous Message | Adarsh Sharma | 2018-06-07 08:52:02 | Unknown database folders in base directory |