On 1/27/19 12:56 PM, Begin Daniel wrote:
Not a good day, forgot to actually Cc list last time.
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx]
Sent: Sunday, January 27, 2019 15:43
To: Begin Daniel
Subject: Re: Error message restarting a database
On 1/27/19 12:38 PM, Begin Daniel wrote:
Please reply to list also
Ccing list.
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx]
Sent: Sunday, January 27, 2019 15:33
To: Begin Daniel; pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Error message restarting a database
On 1/27/19 12:23 PM, Begin Daniel wrote:
I worked with a PostgreSQL database (9.3) for a couple of years on my
PC. I shut down the PostgreSQL server about a year ago and I obviously
did not access the database since. Now I am trying to access again to
the database but I get the following error message...
FATAL: *"pg_tblspc/113608/PG. 9.3_ 201306121/18364" is not a valid data
directory
DETAIL: File *" pg_tblspc/113608/PG. 9.3_ 201306121/18364/PG_VERSION" is
missing.
Anyone has an idea on how to solve this problem?
What OS and version?
Best guess is your OS updated Postgres in the past year and the newer
version is trying to load an older data directory.
Daniel
OS and version...
Windows 10 Pro, Version 1809 installed on 2019-01-11
OS Build 17763.253
Whoops, just realized the errors are pointing at a tablespace/dir.
Does the directory in the error message exist?
I have multiple tablespaces. According to the definition of my tablespaces, the error point on the following directory: K:\pgsqlData\PG_9.3_201306121\18364
The directory exists with 888 items in it, but there is no file named PG_VERSION
Are all the tablespaces connected to a single Postgres instance?
Are you still using Postgres 9.3?
Does the Postgres top level data directory still exist?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
