Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hXl5f-0000QT-DP for pgsql-admin@arkaria.postgresql.org; Mon, 03 Jun 2019 11:25:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hXl4f-0005s9-3x for pgsql-admin@arkaria.postgresql.org; Mon, 03 Jun 2019 11:24:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hXl4e-0005s2-LL for pgsql-admin@lists.postgresql.org; Mon, 03 Jun 2019 11:24:20 +0000 Received: from mail-ot1-x32d.google.com ([2607:f8b0:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hXl4X-0007zm-Pi for pgsql-admin@lists.postgresql.org; Mon, 03 Jun 2019 11:24:19 +0000 Received: by mail-ot1-x32d.google.com with SMTP id n18so15704092otq.0 for ; Mon, 03 Jun 2019 04:24:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=wRzzx9KL6HF1nwutEm1MayyMgqeGYzUbBtUpr6rY/7U=; b=ouE7nsSom83zlHh6bivjOSbpqmqThicNGYtRPrvJMKriapiLiqZERSDBZgoaLL63Zx DXYSv10SIVIA0EAdEOkct3CuIJr8L3GGFU5uNAtmSZsYpHVfrZaV1AKGt/s/ZzYDC6Vh tp/AfKf0Y18ja1KoEVboYNx/xdapVxv7GOjLzJMsVYHqR/PkW6Qhr8+EuYwEPGAVRT+L 13QH675Q1FacTr6PS0hQIWEZ9eOGqnpXW044MINfq6KPlW4g7eC5Qaam3vAmyC1CLQ6/ 1uxQyPrG36ir8XiJHQnBiivla9CigyoZT7ulkYLfqt1LwP9Y5C+2QPZp0f/7gkX+8Dnn BE5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=wRzzx9KL6HF1nwutEm1MayyMgqeGYzUbBtUpr6rY/7U=; b=RK2bgOqSUL2o/NAhCyL/Zaj7ppFCzVCCbG9Rhi6sZAmr8TIqkqOvs98TQG5O3fEC1t Py9I/A/ovPxkovl6I/goBbblTApbfArTZr8jQFw/o9p6UtmxxKidSKnVh8IJEd6A4X9S kBvvwOWPOnYiqNXn1O3+Y28F2hOWrhPOWjvpTp/48xriGfDJaULD1N2s21uw0XcksRcW pXkf932wrZKDQ9YuKJqVquC0vhoVKasan8bG7r07ORN/0WDDkVLyXtqQXhTU+dQFfrNC iTDZFSH/xxMWCTRiP+AeDeA8mpBV3hT/01SOHXjXjy6ZBxfYLqOSUg0NGCs5wHKpDl0y iOSQ== X-Gm-Message-State: APjAAAUIlniRrY5pAeTe1pc0SewlqkdPCVq9Ev9Nrm54Bo5mP7EnSz8k fKGwmwn7h/QEexXTuu40v8Qx/2ejtk8= X-Google-Smtp-Source: APXvYqz63P4XXQcFPPA6xxg2MtZEgZQjswQdgHBmx9H2mHJY2mC/fybkTjlQgBPfn2KRLFiAxOXC9A== X-Received: by 2002:a9d:3f08:: with SMTP id m8mr725999otc.365.1559561052897; Mon, 03 Jun 2019 04:24:12 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id n187sm5539308oif.25.2019.06.03.04.24.11 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 03 Jun 2019 04:24:12 -0700 (PDT) Subject: Re: ERROR:::::: could not rename temporary statistics file ... To: pgsql-admin@lists.postgresql.org References: <2A91BEF8171A5349931391E0C721CC533D53302F@CPEMS-KPN301.KPNCNL.LOCAL> From: Ron Message-ID: <7afa9150-e79e-b016-4618-d7df23211d62@gmail.com> Date: Mon, 3 Jun 2019 06:24:11 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: <2A91BEF8171A5349931391E0C721CC533D53302F@CPEMS-KPN301.KPNCNL.LOCAL> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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.