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@xxxxxxxxx> Sent: Monday, June 03, 2019 1:24 PM To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: Re: ERROR:::::: could not rename temporary statistics file ... On 6/3/19 4:46 AM, soumik.bhattacharjee@xxxxxxx 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.
