Postgresql Database Corrupt | Unix Linux Forums | High Performance Computing

  Go Back    


High Performance Computing Message Passing Interface (MPI) programming and tuning, MPI library installation and management, parallel administration tools, cluster monitoring, cluster optimization, and more HPC topics.

Postgresql Database Corrupt

High Performance Computing


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 02-12-2013
ahsanpmd ahsanpmd is offline
Registered User
 
Join Date: Dec 2012
Last Activity: 7 August 2014, 11:59 PM EDT
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Postgresql Database Corrupt

I am managing a linux cluster which has been build on Platform Cluster Manager PCM 1.2.1) from IBM Platform Computing. Unfortunately somebody deteled data files of postgresql from /var/lib directory. I somehow managed to start the postmaster service again, but all the administrative commands of cluster are not not working. like addhost


Code:
[root@pmd ~]# addhost
KusuDB: Operational Error occurred when connecting to the DB
       Most likely cause: insufficient permissions for user=nobody
FATAL:  database "kusudb" does not exist

ERROR:  Database query failed!  Make sure the database is available

[root@pmd ~]#

I dont want to rebuild cluster as it will lead to the loss of much effort which I did on installing certain applications and running them on the cluster.
Please help me !

Last edited by Scott; 02-12-2013 at 05:21 AM.. Reason: Code tags
Sponsored Links
    #2  
Old 02-12-2013
DGPickett DGPickett is offline Forum Advisor  
Registered User
 
Join Date: Oct 2010
Last Activity: 29 August 2014, 5:00 PM EDT
Location: Southern NJ, USA (Nord)
Posts: 4,409
Thanks: 8
Thanked 538 Times in 516 Posts
If the primary files and any mirrors are gone, restore from the transaction logs is usually the only path.
Sponsored Links
    #3  
Old 02-12-2013
ahsanpmd ahsanpmd is offline
Registered User
 
Join Date: Dec 2012
Last Activity: 7 August 2014, 11:59 PM EDT
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
where I can find the transaction logs
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Script causing database corrupt dbashyam Shell Programming and Scripting 3 11-30-2011 04:52 AM
corrupt disk kekanap HP-UX 11 11-29-2011 10:22 AM
How to corrupt a superblock? sujathan Solaris 2 02-29-2008 04:35 AM
Script to connect to PostgreSQL database rahulrathod Shell Programming and Scripting 0 04-12-2007 03:16 AM
Causing a disk to be corrupt Yummator UNIX for Dummies Questions & Answers 1 03-24-2004 10:36 PM



All times are GMT -4. The time now is 10:16 PM.