Re: Issue during postgresql startup

[Yogesh Sharma <Yogesh1.Sharma@xxxxxxxxxxxxxxxxxx>]

Dear John,

 

>do you have backups from before this occurred ?

No, there is no backup available for the same.

 

Regards,

Yogesh

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce
Sent: Thursday, April 28, 2016 2:18 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] Issue during postgresql startup

 

On 4/28/2016 1:33 AM, Yogesh Sharma wrote:

>did you get that 'no such file or directory' error before or after you reset the transaction logs ?

The error message is coming before.

that means your file system lost files.    there's a number of ways that can happen, mostly revolving around file systems with unreliable caching combined with a power failure, or physical hardware data corruption can do it too.   mucking about in the postgres data file system can do it, too, of course.   do you have backups from before this occurred ?

>messing with the write-ahead logs is very dangerous.  that blog is talking about postgres 8.4, based on his paths.   is that what you're running?

We are running postgres 8.3.

thats a completely obsolete version, 8.3.23 was last updated in early 2013.

current supported versions are 9.1, 9.2, 9.3, 9.4, and 9.5

current releases:  9.1.21, 9.2.16, 9.3.12, 9.4.7, and 9.5.2

 

-- 

john r pierce, recycling bits in santa cruz

DISCLAIMER:
-----------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and
intended
for the named recipient(s) only. 
It shall not attach any liability on the originator or NEC or its
affiliates. Any views or opinions presented in 
this email are solely those of the author and may not necessarily reflect the
opinions of NEC or its affiliates. 
Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of 
this message without the prior written consent of the author of this e-mail is
strictly prohibited. If you have 
received this email in error please delete it and notify the sender
immediately. .
-----------------------------------------------------------------------------------------------------------------------