Problem creating a database
От | Joshua White |
---|---|
Тема | Problem creating a database |
Дата | |
Msg-id | CAGY1NOkYep1Mshow9aZe6wM1YipTYuL09MpR0QHDjcqbOxm0Jg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Problem creating a database
Re: Problem creating a database Re: Problem creating a database |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: