Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gKGoD-0005au-P4 for pgsql-admin@arkaria.postgresql.org; Wed, 07 Nov 2018 05:55:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gKGoC-0001qc-7K for pgsql-admin@arkaria.postgresql.org; Wed, 07 Nov 2018 05:55:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gKGoB-0001qP-Sx for pgsql-admin@lists.postgresql.org; Wed, 07 Nov 2018 05:55:20 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gKGo9-0004Yk-ME for pgsql-admin@lists.postgresql.org; Wed, 07 Nov 2018 05:55:19 +0000 Received: by mail-ot1-x336.google.com with SMTP id f24so13791803otl.5 for ; Tue, 06 Nov 2018 21:55:17 -0800 (PST) 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-language; bh=lRi/I6izh+cN6hqi+KMrrWao0rWQHzQdLXObbRCxtvQ=; b=qjWK+LLTnoPkFhpDdcSXXzuZPVyRQ4MN+w+MKUJ1PpFqGVCjvr3Jvwt7Ay2eKQebCk L9XfnBLEA8sS8CI36lTb+4H47njyr0mxHRWbgKgUZ25gyP/LGw/Pf7tEYungpOM1ViDM lseFvnhGeYeMtv4SIgA8dcCfTMuxvPVD1RvfxH8A0CuaUAuoRd57M/j2HPk37Tjgp8Xr RLqfwWJ6WAQPPzB6MPSgydckwYgdfSHjgcTpM6GOdxaS4k4GcDsKdVkXCKm5eIdcAB+y dA9bg95vngosIaTc3k4QBxRa0pbMChwl9IrWgWQspzzKID1g0cPkItCBaw7AZRlWemUT ffAg== 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-language; bh=lRi/I6izh+cN6hqi+KMrrWao0rWQHzQdLXObbRCxtvQ=; b=SMawXirvJOI0fkP8E762vuwsyyBAhlOBwYW/Pd11fIKPom6c1NtEabGrCa5vE0cloJ msvMk6o1JkN6bZg8AWrDy/z2zu9OLx/D9rgFkIQEHtgilu6p61a+9ijHD2xNvwKwlaqG E+pP966myfQLuAWN5K6gAhEF5muv6nBrVaE7Au5BpzfwQkGclJyDpKTOsqLILalqwKul XKk98JA7dj312GlXoEEdnk7scKeSQ+B10JE0vT+5NB33ehPIj+GW9p8eCa40f9esuVic OJ7wuO+cTXA3jbEvUPmU8nCxRzrgjw/LLzilQ2WwS94u/PCCepy+Wwsn7eRS25Sh2ypu E1CQ== X-Gm-Message-State: AGRZ1gL1KJwEpH+wOEKYsXJcmUQ/oQ8TIbaO8lMroOuuLGtqBWtBePM0 F77qqBb1khPG4/8lW3b443KItOJs X-Google-Smtp-Source: AJdET5dG5D+lsAgn3tTh7YsBq41gb9n2QBeHXTfLlx+TOKxMCtISyZb0wGjbmBDL2VIZfEVfVEEJvQ== X-Received: by 2002:a9d:5209:: with SMTP id e9mr313256oth.91.1541570115612; Tue, 06 Nov 2018 21:55:15 -0800 (PST) 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 p8sm13417248otl.2.2018.11.06.21.55.14 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 06 Nov 2018 21:55:14 -0800 (PST) Subject: Re: Recovery data base!! To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <3369df73-467b-21e2-94cb-2163034e1ec5@gmail.com> Date: Tue, 6 Nov 2018 23:55:14 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------B7BC1DB653F6D19F468E1588" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------B7BC1DB653F6D19F468E1588 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 11/06/2018 11:12 PM, Elson Vaz wrote: > Hello people, > > I need a lot of help, > > Accidentally I deleted all the files from the database, the last copy that > I have a day late. What do you mean by "the last copy that I have a day late"? > I tried with R studio to recover the files, but some files are not correct > / corrupted. > I have also back up the complete database directory for a month. > The postgres I have is 9.4, and the OS is RedHat > > Can someone help me . -- Angular momentum makes the world go 'round. --------------B7BC1DB653F6D19F468E1588 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit On 11/06/2018 11:12 PM, Elson Vaz wrote:
Hello people,

I need a lot of help,

Accidentally I deleted all the files from the database, the last copy that I have a day late.

What do you mean by "the last copy that I have a day late"?

I tried with R studio to recover the files, but some files are not correct / corrupted.
I have also back up the complete database directory for a month.
The postgres I have is 9.4, and the OS is RedHat

Can someone help me .

--
Angular momentum makes the world go 'round.
--------------B7BC1DB653F6D19F468E1588--