Hello all,
I have a PostgreSQL backup script which executes daily. The backup creates no output on "some" days - no pattern observed yet. There is no space issue.
Here are the relevant lines from the shell script.
mkdir $bdir
echo "Backup began at " `date` | tee -a $logfile
pg_basebackup --checkpoint=fast --xlog-method=fetch -v -P -h xx.xxx.xx.xx -U replication -R -D $bdir | tee -a $logfile
echo "Backup completed at " `date` | tee -a $logfile
The directory $bdir does get created. But it remains empty. The echo before and after the backup is writing to $logfile.
Everything that happens on the database gets logged in PGLOG file. Even the connection request by replication user is not there in PGLOG file on the days when the backup doesn't work. Best way to trouble-shoot this? Also, the output from pg_basebackup does not get logged in $logfile even on those days when the backup works fine. How can I get the output into the logfile?
Regards,
Jayadevan