Unable to start POSTGRES Database

From: "Shanmugavelayudham, Varunraj" <varunraj(dot)shanmugavelayudham(at)stryker(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Unable to start POSTGRES Database
Date: 2017-06-20 10:21:10
Message-ID: DM5PR0101MB31163DB39B83E19ECC16AE7DF4C50@DM5PR0101MB3116.prod.exchangelabs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

My Postgres Database (used for ThingWorx) is not starting. Below is the error message. I tried to backup the database using command "pg_dump" and after that, when I restart my application, I started getting below message when I try "Connecting" to database using "pgAdmin III".

Error logs:-
2017-06-20 04:03:33 MDT LOG: database system was interrupted while in recovery at 2017-06-20 04:02:22 MDT
2017-06-20 04:03:33 MDT HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2017-06-20 04:03:33 MDT LOG: could not open tablespace directory "pg_tblspc/16394/PG_9.4_201409291": No such file or directory
2017-06-20 04:03:33 MDT LOG: could not read directory "./pg_tblspc/16394": No such file or directory
2017-06-20 04:03:33 MDT LOG: could not read directory "pg_tblspc/16394": No such file or directory
2017-06-20 04:03:33 MDT LOG: database system was not properly shut down; automatic recovery in progress
2017-06-20 04:03:33 MDT LOG: redo starts at 0/105887C8
2017-06-20 04:03:33 MDT FATAL: could not create directory "pg_tblspc/16394/PG_9.4_201409291/16395": File exists
2017-06-20 04:03:33 MDT CONTEXT: xlog redo hot_update: rel 16394/16395/16461; tid 0/8 xmax 10663 ; new tid 0/10 xmax 0
2017-06-20 04:03:33 MDT LOG: startup process (PID 1916) exited with exit code 1
2017-06-20 04:03:33 MDT LOG: aborting startup due to startup process failure

Thanks & Regards
Varunraj Shanmugavelayudham
IS Manager, Shared Services| Stryker
*Office: +91 124 4850432| Mobile: +91 9910121742
SIGNATURE THEMES
Ideation, Focus, Responsibility, Futuristic, Relator

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Rogers, Lenny (US-KOP) 2017-06-20 18:47:43 RE: [EXTERNAL] Unable to start POSTGRES Database
Previous Message Murtuza Zabuawala 2017-06-20 03:56:27 Re: Empty reset dialog in v1.5 OSX