Problem Postgres

2018-06-26 Thread Emanuele Musella 
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

Re: Postgres Point in time Recovery (PITR),

2019-10-18 Thread Emanuele Musella 
Exactly,

in our environment, we have a full backup of directory PGDATA and every 15
minutes we do archival backup where there are archival file.

So we can restore in a specific time. Before the archival backup we forced
switch wal file to generate archival file so we don't lost any transaction.

Emanuele

Il giorno ven 18 ott 2019 alle ore 10:12 Luca Ferrari 
ha scritto:

> On Fri, Oct 18, 2019 at 7:59 AM Daulat Ram 
> wrote:
> > Can you please share some ideas and scenarios how we can do the PITR in
> case of disaster.
>
> In order to be able to do PITR you need:
> - a base backup of your database
> - WALs from the backup going on
>
> See .
> Then, to keep it simple, if the disaster happens in the time window
> between the backup and the last WAL archiving, you can restore an
> instance at any point in time previously the disaster itself.
>
> Luca
>
>
>