Обсуждение: Database Refresh confusion

Am 13.07.2018 um 13:10 schrieb Rijo Roy:
> Hello Experts,
>
> Today, my colleague asked me if there was any way to check the 
> progress of recovery (backup-recovery) in Postgresql. I told him to 
> check the postgresql logs and look out for keywords such as recovery. 
> He was refreshing the database by restoring a database backup but the 
> method he tried surprised me.
> The below commands were used:
> pg_basebackup -h remoteservername -p Port number -D /path -X s -c fast 
> -n -P -v
> And he just started the postgresql cluster using pg_ctl
>
> I told him that he missed creating a recovery.conf with a recovery 
> command,

that's not necessary, without recovery.conf postgres will start as a 
normal server.


> but he told me that he always does this way.  I told him that the 
> process is wrong and this will do a crash recovery and there are high 
> chances of data corruption.

No, this way is safe


> He replied saying he never faced an issue following his process of 
> doing it without recovery.conf
>
> 2 questions:
> 1. Is this a good practice for refreshing data into a new server.
> 2. Is there any other mechanism to track the restoration process other 
> than to check the postgresql logs.

pg_basebackup has a progress-feature, -P, see you command above


>
> The postgresql version used in 10.0 on a Linux 6.9

the latest version is 10.4 and contains a lot of bugfixes, consider a 
update soon.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com