PostgreSQL backup issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

PostgreSQL backup issue

Jayadevan
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
Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL backup issue

David G Johnston
On Tuesday, May 22, 2018, Jayadevan M <[hidden email]> wrote:
 pg_basebackup ... | tee -- Also, the output from pg_basebackup does not get logged in $logfile even on those days when the backup works fine.

I would conclude that pg-basebackup is placing its output in stderr instead of stdout then...

David J.
Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL backup issue

Michael Paquier-2
On Tue, May 22, 2018 at 10:35:46PM -0700, David G. Johnston wrote:
> I would conclude that pg-basebackup is placing its output in stderr instead
> of stdout then...

The output of pg_basebackup's verbose mode goes to stderr (look for
example at the verbose flags in pg_basebackup.c).
--
Michael

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL backup issue

Jayadevan
In reply to this post by David G Johnston

I would conclude that pg-basebackup is placing its output in stderr instead of stdout then...



Thanks. Modifying the last potion to '>>$logfile 2>&1' worked.

Regards,
Jayadevan