Postgresql Database Corrupt Post: 302769379

Sponsored Content

Special Forums UNIX and Linux Applications High Performance Computing Postgresql Database Corrupt Post 302769379 by ahsanpmd on Tuesday 12th of February 2013 04:58:52 AM

02-12-2013

Registered User

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 06:21 AM.. Reason: Code tags

ahsanpmd

View Public Profile for ahsanpmd

Find all posts by ahsanpmd

9 More Discussions You Might Find Interesting

1. Cybersecurity

Security Databases are corrupt. HELP!!

Help! SCO Unix 5.05. A relatievely new system went down on me today. I got the dreaded error: Out of Space on Device (1/42). I was able to clear up some space in the /tmp directory, however, when I try to boot, the system prompts me to go into single user mode and I get the...

2. UNIX for Dummies Questions & Answers

I got a corrupt /etc/inittab file....what next?

Hi guys, For some reason a client has given us a Sun Netra T1 with Solaris 8 to administer for them. That's always good business. However, the other day we rebooted the machine and to our amazement, after doing the preliminary hardware tests, we got an error messgae saying that /etc/inittab was...

3. UNIX for Dummies Questions & Answers

Causing a disk to be corrupt

Hmm, how to ask this without sounding too malicious... How might one go about causing a disk corruption in OS X specifically or via the command line in UNIX in general? Doesnt matter the severity of the problem, I just want to scare the person a little, then fix the problem for them. Any...

4. HP-UX

Corrupt Member File

I have been fine adding/removing printers up until this week. Now when I go to add a new remote printer I get "corrupted member file". I go to /etc/lp/member and the byte count on the new printer name is 0. I VI the file and put /dev/null in to make it the correct size and it all looks fine and...

5. Shell Programming and Scripting

Script to connect to PostgreSQL database

Hi All, Has anyone of you connected to a remote PostgreSQL database through a shell/perl script. Can you please let me know the steps involed? Thanks. Rahul.

6. Solaris

How to corrupt a superblock?

I need to corrupt a superblock of a mounted device in a soalris m/c and check recovery from an alternate superblock. How can this be done?

7. HP-UX

corrupt disk

Hallo Friends, I have application X running on hpux 11.11 and oracle 9i release 2. I recently had a hardware failure on disk /dev/dsk/c2t0d0 Below is the systemlog file : root@a7dmc:/var/adm/syslog > /opt/resmon/bin/resdata -R 155713541 -r /storage/events/enclosures/gazemon/0_1_1_0.0.0...

8. Shell Programming and Scripting

Script causing database corrupt

Hi, Closing the thread

9. Shell Programming and Scripting

Setting up postgreSql database

Hi I have a small bash script which I want to run on an Amazon EC2 Ubuntu instance for setting up a postgreSQL database: #!/bin/bash USERNAME='postgres' start=$SECONDS TMP_DIR=/local/test/4g4d PORT=23456 rm -rf $TMP_DIR/db mkdir -p $TMP_DIR/ echo "creating database..."...

LEARN ABOUT CENTOS

rgmanager

clusvcmgrd(8)                                                  Red Hat Cluster Suite                                                 clusvcmgrd(8)

NAME

       rgmanager - Resource Group (Cluster Service) Manager Daemon

DESCRIPTION

       rgmanager  handles  management  of  user-defined cluster services (also known as resource groups).  This includes handling of user requests
       including service start, service disable, service relocate, and service restart.  The service manager daemon also  handles  restarting  and
       relocating services in the event of failures.

HOW IT WORKS

       The  service  manager is spawned by an init script after the cluster infrastructure has been started and only functions when the cluster is
       quorate and locks are working.

       During initialization, the service manager runs scripts which ensure that all services are clear to be started.  After that, it  determines
       which services need to be started and starts them.

       When an event is received, members which are no longer online have their services taken away from them.  The event should only occur in the
       case that the member has been fenced whenever fencing is available.

       When a cluster member determines that it is no longer in the cluster quorum, the service manager stops all services and  waits  for  a  new
       quorum to form.

COMMAND LINE OPTIONS

       -f     Run in the foreground (do not fork).

       -d     Enable debug-level logging.

       -w     Disable internal process monitoring (for debugging).

       -N     Do  not perform stop-before-start.  Combined with the -Z flag to clusvcadm, this can be used to allow rgmanager to be upgraded with-
              out stopping a given user service or set of services.

SEE ALSO

       clusvcadm(8)

                                                                     Jan 2005                                                        clusvcmgrd(8)