Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory

Поиск
Список
Период
Сортировка
От Celia McInnis
Тема Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory
Дата
Msg-id CAGD6t7L0sMMzaZgx1a0zp+ZA60GjG6Qufa3wu=zKLp2V-9T5QA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-general
Дерево обсуждения
YES!!! The chdir caused the error! Thanks very much for this help. BTW it was worse than just "not a very good idea" to use chdir - After generating the error, I would lose the ability to see things in my database until restarting postgresql. All's okay now!

On Wed, Sep 8, 2021 at 8:56 PM Thomas Munro <thomas.munro@gmail.com> wrote:
On Thu, Sep 9, 2021 at 9:19 AM Celia McInnis <celia.mcinnis@gmail.com> wrote:
> Note that the file does exist:! (How do I know if it is looking under the correct directory? Other times I have done similar temporary table creations with no problems!):

PostgreSQL internally uses relative paths.  It's probably not a very
good idea to use 'chdir' in a procedure.

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory
Следующее
От: Abhishek Bhola
Дата:
Сообщение: Postgresql 11: terminating walsender process due to replication timeout