-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] 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.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? 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.
