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
