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