Re: Problem creating a database

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 <ben(at)ausvet(dot)com(dot)au> wrote:

> Do you have adequate disk space left on your array?
>
> cheers
>
> Ben
>
>
> On 15 October 2018 at 17:46, Joshua White <joshua(dot)white(at)monash(dot)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:
> ben(at)ausvet(dot)com(dot)au
> Website:
> www.ausvet.com.au
> Skype: benmadin
> Address:
> 5 Shuffrey Street
> Fremantle, WA 6160
> Australia
>