Re: [GENERAL] Issue during postgresql startup

2016-05-02 Thread Yogesh Sharma
Dear All, Could you please update your suggestion on below mail Regards, Yogesh From: Yogesh Sharma Sent: Friday, April 29, 2016 3:57 PM To: John R Pierce; pgsql-general@postgresql.org Subject: RE: [GENERAL] Issue during postgresql startup Dear All, I am sharing my further observation

Re: [GENERAL] Issue during postgresql startup

2016-04-29 Thread Yogesh Sharma
tically. I’ll appreciate any kind of opinion on my understanding. Thanks, Yogesh Sharma From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, April 28, 2016 2:51 PM To: pgsql-general@postgresql.org Subject: Re: [GENER

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread John R Pierce
On 4/28/2016 1:54 AM, Yogesh Sharma wrote: >do you have backups from before this occurred ? No, there is no backup available for the same. oops. it is possible some of your tables can be recovered by someone highly experienced in postgres data recovery. such people work for the various

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread Yogesh Sharma
ral@postgresql.org 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 l

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread John R Pierce
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

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread Yogesh Sharma
what you're running? We are running postgres 8.3. Regards, Yogesh From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce Sent: Thursday, April 28, 2016 1:44 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Issue during postgresql star

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread Yogesh Sharma
8, 2016 1:45 PM To: Yogesh Sharma; pgsql-general Subject: Re: [GENERAL] Issue during postgresql startup On Thu, 28 Apr 2016 15:22 Yogesh Sharma, <yogesh1.sha...@nectechnologies.in<mailto:yogesh1.sha...@nectechnologies.in>> wrote: Dear All, Thanks for your support. Could you please

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread Achilleas Mantzios
On 28/04/2016 10:21, Yogesh Sharma wrote: Dear All, Thanks for your support. Could you please tell me, how to recover my system. I am facing below errors. --- could not open relation 1663/16385/1299988: No such file or directory --- This

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread Sameer Kumar
On Thu, 28 Apr 2016 15:22 Yogesh Sharma, wrote: > Dear All, > > Thanks for your support. > > Could you please tell me, how to recover my system. > > I am facing below errors. > --- > could not open relation 1663/16385/1299988: No such

Re: [GENERAL] Issue during postgresql startup

2016-04-28 Thread John R Pierce
On 4/28/2016 12:21 AM, Yogesh Sharma wrote: Could you please tell me, how to recover my system. I am facing below errors. --- could not open relation 1663/16385/1299988: No such file or directory --- This message is continuous occurred in system

[GENERAL] Issue during postgresql startup

2016-04-28 Thread Yogesh Sharma
Dear All, Thanks for your support. Could you please tell me, how to recover my system. I am facing below errors. --- could not open relation 1663/16385/1299988: No such file or directory --- This message is continuous occurred in system . I have