Search Postgresql Archives

Re: Unknown database folders in base directory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Re: Adarsh Sharma 2018-06-07 <CAGx-QqKyW-UuMTw9Vw9uCX_Af+8GhS1HdkNLt6uV9DnxQGV0eg@xxxxxxxxxxxxxx>
> *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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux