Re: Problem Postgres - Mailing list pgsql-general

From Enrico Pirozzi
Subject Re: Problem Postgres
Date
Msg-id 7ad96807-b232-f467-30d3-73d6616a629e@nbsgroup.it
Whole thread Raw
In response to Re: Problem Postgres  (Fabio Pardi <f.pardi@portavita.eu>)
List pgsql-general
Hi Emanuele,

you can post here in italian :)

http://lists.psql.it/mailman/listinfo

Regards
Enrico

Il 26/06/2018 10:45, Fabio Pardi ha scritto:
>
> 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
>
>
> --
> Questo messaggio è stato analizzato con Libra ESVA ed è risultato non
> infetto.
>

--
Enrico Pirozzi
NBS Group S.r.l.
via Val Tiberina 23/A
63074, San Benedetto del Tronto (AP)
Tel. 0735-7626201




pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: We find few queries running three times simultaneously with same parameters on postgres db
Next
From: Anto Aravinth
Date:
Subject: Re: Using COPY to import large xml file