From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: ERROR:::::: could not rename temporary statistics file ...
Date: Mon, 3 Jun 2019 06:32:12 -0500
Message-ID: <6c314d1a-e662-af06-03a3-fc504a9702bb@gmail.com> (raw)
In-Reply-To: <2A91BEF8171A5349931391E0C721CC5344508B6A@CPEMS-KPN501.KPNCNL.LOCAL>
References: <2A91BEF8171A5349931391E0C721CC533D53302F@CPEMS-KPN301.KPNCNL.LOCAL>
<7afa9150-e79e-b016-4618-d7df23211d62@gmail.com>
<2A91BEF8171A5349931391E0C721CC5344508B6A@CPEMS-KPN501.KPNCNL.LOCAL>
Please don't top-post.
On 6/3/19 6:26 AM, soumik.bhattacharjee@kpn.com wrote:
> My pg_restore is stuck here for last 2 days.
>
> pg_restore: creating CONSTRAINT "schema_name.num_servicenummer_historie snh_prx"
Consuming CPU and disk IO, or just sitting there?
> -----Original Message-----
> From: Ron <ronljohnsonjr@gmail.com>
> Sent: Monday, June 03, 2019 1:24 PM
> To: pgsql-admin@lists.postgresql.org
> Subject: Re: ERROR:::::: could not rename temporary statistics file ...
>
> On 6/3/19 4:46 AM, soumik.bhattacharjee@kpn.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: ERROR:::::: could not rename temporary statistics file ...
In-Reply-To: <6c314d1a-e662-af06-03a3-fc504a9702bb@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox