Re: Problem Postgres

Поиск
Список
Период
Сортировка
От Fabio Pardi
Тема Re: Problem Postgres
Дата
Msg-id 7a231238-3c1d-8d8d-544d-822c8cd034d6@portavita.eu
обсуждение исходный текст
Ответ на Problem Postgres  (Emanuele Musella <emamuse86@gmail.com>)
Ответы Re: Problem Postgres
Список pgsql-general

Hi Emanuele,


For the next time, is best if you post to an italian mailing list if your log messages are in italian. Else change settings in order to have english errors.

Back to your problem:

Looks like permissions on your installation are not OK, and have been manipulated from the default ones. The fact that happens every 20 minutes, means maybe something 'scheduled' is occurring, like, eg, a query (maybe from your monitoring system), or a checkpoint.


Could you please:

* post the full logfile of the next line, the one on 'ISTRUZIONE' and anything else you think is relevant in the logs

* tell us more about your installation (from package, compiled, which version of Postres and OS, if you did anything special after installation)

* post the permissions of the folder 'base' and those of base/16395/19739338

* tell us under which user is postgres running


regards,

fabio pardi



On 26/06/18 10:05, Emanuele Musella wrote:
Good morning,

we have the following error:

2018-06-26 09:48:44 CEST ERRORE:  non è stato possibile ottenere informazioni sul file "base/16395/19739338": Permission denied
2018-06-26 09:48:44 CEST ISTRUZIONE:  select p.datname,pg_database_size(p.datname) from pg_database p

This error repetly every 20 minutes.

Can you help me?

Regards 

Emanuele Musella

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

Предыдущее
От: Thomas Poty
Дата:
Сообщение: Re: Problem Postgres
Следующее
От: Ivar Fredriksen
Дата:
Сообщение: Single query uses all system memory