-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Sunday, January 27, 2019 16:52 To: Begin Daniel Cc: pgsql-general Subject: Re: Error message restarting a database On 1/27/19 1:38 PM, Begin Daniel wrote: > -----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. PGDATA from here: https://www.postgresql.org/docs/10/storage-file-layout.html I am going to say PGDATA exists given the below. > > 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. > To be clear you are running only one instance(cluster) of Postgres and that instance has several databases defined in it, correct? If you go to PGDATA.pg_tblspc do you have links to the tablespaces? I only installed one instance of Postgres on my PC, which I use to manage two databases (postgres and osmdump). osmdump is the database that complains. Regarding the links to the tablespaces, I first ran the following request. SELECT spcname FROM pg_tablespace; and got the following list. "pg_default" "pg_global" "workspace" "datadrive1" "datadrive2" "datadrive3" "datadrive0" I went to E:\pgsqlData\pg_tblspc and found the links to the five last tablespaces above (I manually created them, the first two were created when I installed Postgres). E:\pgsqlData\pg_tblspc \113608\PG_9.3_201306121\18364 link to the 888 items mentioned previously (physically stored in K:\pgsqlData\pg_tblspc...) I also found a PG_VERSION file in E:\pgsqlData. The file contains the value 9.3 Daniel
