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.
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" |