Thread: 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
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