questions regarding setup a new barman server

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: questions regarding setup a new barman server
Date: 2018-07-15 08:47:49
Message-ID: CA+t6e1n0KgnhefYGAVLyJv_auF0kXAdkgXYsmqg8HpvKuS7oVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
I'm trying to configure a barman server that would manage the backup and
restore in the cluster in our company. I'm trying understand a few things
and I have many questions. I would be happy to get some anwers :

1)I decided to use the streaming option for the backups - for wals and for
full physical backup with pg_basebackup. However, I was asked (according to
documentation) to configure the archive_command. My question is why ? Is
there a reason to use the archive_command and the streaming
(pg_recievewal) option ? Now, If I disable the archive_command and use only
the streaming option, to automate the process of recieving wals I need to
run for each server : barman receive-wal my-pg-server ? Is there a reason
to have both archive_command and streaming option ?

2)When I use the command barman receive-wal ptktl-psgsqldb1 I'm getting the
next output once a wal is switched :
ptktl-psgsqldb1: pg_receivewal: starting log streaming at 1F1/F7000000
(timeline 3)
ptktl-psgsqldb1: pg_receivewal: finished segment at 1F1/F8000000 (timeline
3)

However, I dont see those wals in the incoming directory. Why is that ? Is
it just an alert for a switch or a message that means that that wal was
recieved ?

3)When using the check option I have the next error :
empty incoming directory:
FAILED ('/PostgreSQL/barman//ptktl-psgsqldb1/incoming' must be empty when
archiver=off) but I set streaming_archiver to on. Moreover I dont see any
errors in the errors directory.

4)When I tried to take a full backup via barman backup ptktl-psgsqldb1 it
seems that the backup is stuck :
Starting backup using postgres method for server ptktl-psgsqldb1 in
/PostgreSQL/barman//ptktl-psgsqldb1/base/20180715T114042
Backup start at LSN: 1F1/FB040E28 (00000003000001F1000000FB, 00040E28)
Starting backup copy via pg_basebackup for 20180715T114042

The database is empty ( a new one) but still it doesnt finish...
Any idea why ?

I think that 4 and 2 are connected. Any idea guys ?

Thanks , Mariel.

Browse pgsql-admin by date

  From Date Subject
Next Message Rahul Saha 2018-07-16 12:10:55 [Admin] Deleting Orphan Relfilenode
Previous Message Mariel Cherkassky 2018-07-15 07:26:54 Re: invalid value for parameter "client_encoding": "ISO_8859_8"