Do you have a backup of the database?
From: Shanmugavelayudham, Varunraj [mailto:varunraj.shanmugavelayudham@stryker.com]
Sent: Tuesday, June 20, 2017 6:21 AM
To: pgadmin-support@postgresql.org
Subject: [EXTERNAL] Unable to start POSTGRES Database
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
The information contained in this email message, including any attachments, is intended solely for use by the individual or entity named above and may be confidential. If the reader of this message is not the intended recipient, you are hereby notified that you must not read, use, disclose, distribute or copy any part of this communication. If you have received this communication in error, please immediately notify me by email and destroy the original message, including any attachments. Thank you. **hibu IT Code:1414593000000**
