Replicating Users across clusters

[mesunderlin]

We have two Vertica clusters, a primary and a secondary. We would like to have some sort of automation, or even semi-automated way to ensure that any users added to the primary also get added to the secondary.

Even something that would run an SQL on v_catalog.users and then generate SQL to run on the secondary ....

Hoping this is not a unique use case to my company and that this is "solved and moved on" for someone else!!!
--
Mark E. Sunderlin
Data Architect // AOL Platforms
P: 703-265-6935 // C: 540-327-6222 // 22000 AOL Way, Dulles, VA 20166
AIM: MESunderlin

[id10t]

Hi!

[DELETED]

[id10t]

Hi!

[DELETED]

[scutter]

If he’s using LDAP authentication, then the stored password issue isn’t an issue.

—Sharon

[mesunderlin]

>>If he’s using LDAP authentication, then the stored password issue isn’t an issue.

Right, we are using LDAP, so password replications is not an issue.

>>Or do you want a final solution? Do you want a script that generates restore-able dumps of users?

Well, that would be nice.

But if you could maybe just expand on this, we could likely finish it off:

>>main server::[EXEC] dump users meta data to file(FORMAT: sql statements)

[id10t]

Hi!

[DELETED]

[mesunderlin]

Hi!

But if you could maybe just expand on this, we could likely finish it off:

No problem, pay me and you will get

PS
I have to say - for company like AOL its a boorishness to ask a free solution:)
May be some nice developer, who do not appreciate it own time (time is money, right?) will provide to you a solution.

To be fair, I was hoping someone else already had this done as it seems like a common enough use case. However, if no one has this lying around already done, then there is no need for anyone to write it for us.