Search Postgresql Archives

Re: Issue during postgresql startup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear Sameer and all,

 

>Looks like someone has been playing around with the database files or some disk issue.

>Basically Postgres stores each table inside

>$tablespace_dir/$database_dir/table_file

>In this error it seems one of the files have been removed/lost

 

Yes, I am suspecting a disk error or so.

In that case I tried to add a dummy file “base/16385/1299988” using dd command. But while postgre start the file deleted automatically and it failed with same error.

 

Is there any way to recover from this error or take dump of data and recreate DB from same dump ?

 

BTW log files in pg_xlog also increased abruptly from the same time when this error started coming. Is it related to above error ?

 

Any help will be much appreciated !

 

Let me know if any other help is required.

 

 

Thanks,

Yogesh

From: Sameer Kumar [mailto:sameer.kumar@xxxxxxxxxx]
Sent: Thursday, April 28, 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.Sharma@xxxxxxxxxxxxxxxxxx> 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 message is continuous occurred in system .

 

 

Looks like someone has been playing around with the database files or some disk issue.

 

Basically Postgres stores each table inside

 

$tablespace_dir/$database_dir/table_file

 

In this error it seems one of the files have been removed/lost

 

 


I have tried below procedure for the same but after recover this system, all DB tables are destroyed.
http://www.hivelogik.com/blog/?p=513

 

You might want to post the steps and backup file/date which you have used. 

 

Please let me know if any solution.

Regards,
Yogesh



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. .
-----------------------------------------------------------------------------------------------------------------------


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

--

Best Regards

Sameer Kumar | DB Solution Architect 

ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com


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. .
-----------------------------------------------------------------------------------------------------------------------

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux