From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Safe to delete files? |
Date: | 2019-04-13 00:09:15 |
Message-ID: | 31232131-bd95-eac3-aecb-c4fee717666f@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4/12/19 3:11 PM, Paul van der Linden wrote:
> Hi,
>
> For my process, I needed to drop all the tables in a tablespace except one
> which I truncated.
> After that I would have expected to have a couple of KB max in that
> folder, but there was about 200GB in it.
Did you vacuum afterwards?
>
> There were 2 sets of files (<id1>, <id1>.1 .. <id1>.99, and the same for id2).
> Tried the various options from
> https://blog.2ndquadrant.com/postgresql-filename-to-table/ and oid2name
> (with -i), to trace it back to a table but all came up empty.
>
> Now this folder has a bit of a history spanning several postgres versions
> and upgrades, and sometime in the past one of the upgrades went horribly
> wrong, so my first thought was that this was possibly some leftovers from
> that mishap, but the filetimes were a bit later than that.
> Also hard to tell because those tables are used as write-once, read-alot
> so could not base the last usage on filedate.
>
> Normally I probably would dare to risk deleting those files, but after the
> dropping and truncating, the 2 files without extension had the time of
> drop/truncate and were 0 bytes in length (unfortunately I didn't check the
> filesize before drop/truncating).
>
> Are there other options to see if these files are leftovers from previous
> stuff and not used by postgres (so i can safely delete them)?
>
> Postgres 11, just one used database on it (the other one being a postgis
> template), running on windows server 2012.
>
> In replies please use reply to all...
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Nithin Johnson | 2019-04-13 09:22:03 | SELECT query fails after pg_upgrade as the conditional operator fails |
Previous Message | Adrian Klaver | 2019-04-13 00:06:02 | Re: Safe to delete files? |