Re: Problem creating a database - Mailing list pgsql-general
Do you have adequate disk space left on your array?
cheers
Ben
On 15 October 2018 at 17:46, Joshua White <joshua.white@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 directoryIt 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
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
pgsql-general by date: