Thanks for the suggestion - plenty of disk space left (several hundred gigabytes free).
Kind Regards, Joshua White On Tue, 16 Oct 2018 at 15:03, Ben Madin <b...@ausvet.com.au> wrote: > Do you have adequate disk space left on your array? > > cheers > > Ben > > > On 15 October 2018 at 17:46, Joshua White <joshua.wh...@monash.edu> wrote: > >> Hi all, >> >> I'm hoping someone can point me in the right direction. I've got a >> PostgreSQL 10 server instance on CentOS 6, which I set up and manage. I >> have full admin rights on this machine, so I can access logs, etc. >> >> Recently I attempted to create a new database in this cluster. The >> command succeeds, but when I try to connect to the new database, I get a >> "could not open file" error: >> >> psql: FATAL: could not open file "base/618720/2610": No such file or >> directory >> >> It has been some time since I set up the database, so I don't know how >> long ago this became an issue. I can't seem to find any other instances of >> this problem online either. The logs are not helpful - even on the highest >> debug setting, I only see the "connection authorized" then the fatal "could >> not open file" error. >> >> The data directory is on a separate disk array to the OS. Recently >> checked it and there are no disk errors. >> >> Any thoughts or ideas would be much appreciated. >> >> Kind Regards, >> Joshua >> >> > > > -- > > [image: Ausvet Logo] <https://www.ausvet.com.au/> > > Dr Ben Madin > > BVMS MVPHMgmt PhD MANZCVS GAICD > Managing Director > Mobile: > +61 448 887 220 <+61448887220> > E-mail: > b...@ausvet.com.au > Website: > www.ausvet.com.au > Skype: benmadin > Address: > 5 Shuffrey Street > Fremantle, WA 6160 > Australia >
