Unix/Linux 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 Linux or Unix Question    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 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 Unix and Linux 02-12-2013
DGPickett DGPickett is offline Forum Advisor  
Registered User
 
Join Date: Oct 2010
Last Activity: 17 February 2015, 1:56 PM EST
Location: Southern NJ, USA (Nord)
Posts: 4,671
Thanks: 8
Thanked 586 Times in 559 Posts
If the primary files and any mirrors are gone, restore from the transaction logs is usually the only path.
Sponsored Links
    #3  
Old Unix and Linux 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 Linux or Unix Question

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Unix or Linux Image 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 09:03 AM.