RE: Error message restarting a database

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Sunday, January 27, 2019 16:15
To: Begin Daniel
Cc: pgsql-general
Subject: Re: Error message restarting a database

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(dot)klaver(at)aklaver(dot)com]
> 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(dot)klaver(at)aklaver(dot)com]
>> Sent: Sunday, January 27, 2019 15:33
>> To: Begin Daniel; pgsql-general(at)lists(dot)postgresql(dot)org
>> 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?

Right, not a good day ;-)
- All tablespaces are connected to a single Postgres database instance
- I am still using Postgres 9.3 since I did not change anything related to PostgreSQL since I shut down the server a year ago
- I am not sure what you mean by top level directory.

I am using PgAdmin to access my PostgreSQL databases. I can access the default database (postgres), tablespace definitions, group roles and login roles. The other database instance I have is the one that send me error messages.