Re: iso-8859-1 database folders in base directory - Mailing list pgsql-general

From Christoph Berg
Subject Re: iso-8859-1 database folders in base directory
Date
Msg-id 20180607085812.GA16531@msg.df7cb.de
Whole thread Raw
In response to iso-8859-1 database folders in base directory  (Adarsh Sharma <eddy.adarsh@gmail.com>)
List pgsql-general
Re: Adarsh Sharma 2018-06-07 <CAGx-QqKyW-UuMTw9Vw9uCX_Af+8GhS1HdkNLt6uV9DnxQGV0eg@mail.gmail.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


pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: iso-8859-1 database folders in base directory
Next
From: pinker
Date:
Subject: Plans cache eviction from process local Memory