RE: ERROR:::::: could not rename temporary statistics file ...

From: <soumik(dot)bhattacharjee(at)kpn(dot)com>
To: <ronljohnsonjr(at)gmail(dot)com>, <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: RE: ERROR:::::: could not rename temporary statistics file ...
Date: 2019-06-03 11:26:59
Message-ID: 2A91BEF8171A5349931391E0C721CC5344508B6A@CPEMS-KPN501.KPNCNL.LOCAL
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

My pg_restore is stuck here for last 2 days.

pg_restore: creating CONSTRAINT "schema_name.num_servicenummer_historie snh_prx"

-----Original Message-----
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Monday, June 03, 2019 1:24 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: ERROR:::::: could not rename temporary statistics file ...

On 6/3/19 4:46 AM, soumik(dot)bhattacharjee(at)kpn(dot)com wrote:
> Hello,
>
> While doing a restore from pgadmin, getting the below error- it's like 12GB restore file.
>
> Any pointers to solve this issue.
>
>
>
> 2019-06-03 09:01:39.978 UTC [17] LOG: could not rename temporary statistics file "pg_stat_tmp/db_13015.tmp" to "pg_stat_tmp/db_13015.stat": No such file or directory
> 2019-06-03 09:01:40.090 UTC [17] LOG: could not rename temporary statistics file "pg_stat_tmp/global.tmp" to "pg_stat_tmp/global.stat": No such file or directory

That's a LOG level message, not an ERROR level message.  Does Postgres not work?

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2019-06-03 11:32:12 Re: ERROR:::::: could not rename temporary statistics file ...
Previous Message Ron 2019-06-03 11:24:11 Re: ERROR:::::: could not rename temporary statistics file ...