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 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

--

Dr Ben Madin

 

BVMS MVPHMgmt PhD MANZCVS GAICD

Managing Director

Mobile:

+61 448 887 220

E-mail:

ben@ausvet.com.au

Website:

www.ausvet.com.au

Skype: benmadin

Address: 

5 Shuffrey Street
Fremantle, WA 6160
Australia