Issue backing up the Ranger KMS DB?

rwinters — Fri, 14 Jun 2019 04:32:59 GMT

Hi,

Can you provide the procedure for backing up ranger kms? I've backed up the ranger and ranger audit databases using the postgres dump command (pg_dump), but I'm running into an issue when I try the same procedure for the rangerkms database. I tried the following command and got the error shown below. To access the ranger kms I have to login using the keyadmin user. I was thinking that this is my issue, that I'm trying to create a backup of this database using the wrong user? Any thoughts are suggestions are appreciated as I haven't been able to find any support articles on this. Thanks in advance...

pg_dump -U rangeradmin rangerkms > rangerkms.sql

Password:

pg_dump: [archiver (db)] query failed: ERROR: permission denied for relation ranger_masterkey

pg_dump: [archiver (db)] query was: LOCK TABLE public.ranger_masterkey IN ACCESS SHARE MODE

Re: Issue backing up the Ranger KMS DB?

rwinters — Sat, 15 Jun 2019 01:26:29 GMT

For those might find this down the road. I just realized I wasn't connecting to the rangerkms db with the correct user. To backup the database I used the rangerkms user (instead of rangeradmin as in my original post.)

sudo pg_dump -U rangerkms rangerkms > rangerkms.sql

question Issue backing up the Ranger KMS DB? in Support Questions

Issue backing up the Ranger KMS DB?

Re: Issue backing up the Ranger KMS DB?