From: | Ben Madin <ben(at)ausvet(dot)com(dot)au> |
---|---|
To: | Joshua White <joshua(dot)white(at)monash(dot)edu> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Problem creating a database |
Date: | 2018-10-16 04:03:56 |
Message-ID: | CA+weYr3Yw4ytg_48JUmmMzhFwz2_41eXEzKJwJN5Cj_upH_v5A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua White | 2018-10-16 06:57:35 | Re: Problem creating a database |
Previous Message | Ben Madin | 2018-10-16 04:01:15 | Re: Saving view turns SELECT * into field list |