Re: Problem Postgres

From: Enrico Pirozzi <e(dot)pirozzi(at)nbsgroup(dot)it>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Problem Postgres
Date: 2018-06-26 14:21:26
Message-ID: 7ad96807-b232-f467-30d3-73d6616a629e@nbsgroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anto Aravinth 2018-06-26 15:08:05 Re: Using COPY to import large xml file
Previous Message Andreas Kretschmer 2018-06-26 12:33:35 Re: We find few queries running three times simultaneously with same parameters on postgres db