Postgresql 12 and HAProxy – asking for guidance

I have two PG12 servers and they are in a Master-Slave relationship (replication).

What I want to do is have a virtual ip and link it to the master DB server being replicated to the slave one. I want the slave DB server to promote to master when the formal master dies. (failover)

I am trying to use HAProxy but have no idea. Examples from Google have other applications involved. I tried to use repmgr but I keep getting error during installation. (FATAL: no pg_hba.conf entry for host "__IP__", user "__USER__", database "__DB__", SSL off)

Can anyone please give me an advice or guide me with an example?

Casting Guidance cantrip for every roll?

What prevents a cleric from casting the Guidance spell every single turn and having everyone have 1D4 extra for their rolls, especially since you can combo it with this:

It seems like every skill check should always be made with advantage due to the 'Working Together' rules. Is this accurate?

This can end with almost all the checks being a D20+1D4 plus advantage. Seems a bit broken mechanic without some houseruling that prevents the same spell on the same target for some time, or I am missing some rule that prevents this?

The same would affect Resistance, but since you probably are in the middle of a combat, the Touch range could prevent it effectively, but for normal skill rolls where the touch of the cleric is possible and the situation is not stressing?

using Guidance and Resistance for long term effects

The Guidance and Resistance cantrips both last for 1 minite, but a lot of saves and checks represent longer stretches of time, and I want to know if those cantrips can be applied in those situations.

For instance, can a creature on watch benefit from Guidance for their Wisdom (Perception) roll?

Can a creature traveling for extra hours in the day benefit from Resistance for their Constitution save to prevent exhaustion?

Guidance on Learning to GM Star Trek Adventures

I have been GMing DnD5e for almost two years now and have two consistent groups ongoing. As a Christmas gift, I will be running a game using the Star Trek Adventures game system for someone.

I have the rulebook, have begun reading it, and suspect that this question will be closed for being too broad: what notable differences from DnD5e should I pay attention to so I can most effectively learn and teach this new system? For your information, only one of my potential players has played a roleplaying game in the last 25 years, as she is in one of my 5e groups.

This question is less about the success/failure system inherent to the roles, but more specifically about how the ‘scenes’ are set up, how the characters are intended to act, and the types of challenges that ought to be presented, but all answers providing important details that I must adapt to are relevant.

Thank you!

Is this variation of the Guidance cantrip balanced? [closed]

As a player who currently can cast Guidance, I find its decision making process a little less than exciting. Essentially, if I’m not concentrating on a spell and there’s no time pressure, cast Guidance. I’d like to make the spell more meaningful. So my thought:

GUIDANCE
Casting Time: 1 action
Range: Touch
Components: V, S
Duration: Concentration, up to 1 minute
Classes: Cleric, Druid

You touch one willing creature. Once before the spell ends, the target can roll one ability check with advantage. The spell then ends. The target cannot benefit from the effects of Guidance until they have completed a short rest.

I think this provides a more meaningful decision point behind the spell, since it can’t be used for every check. It could even provide a meaningful benefit in combat, if you were to use it on, say, your barbarian friend who was planning on grappling someone. I do worry if it is almost too weak, since Working Together wouldn’t stack with it. Would allowing it to be used for attack rolls or saving throws then make it too strong? (Per my understanding, those don’t qualify as ability checks).

Best guidance for allowing users to connect via HTTP in case of a certificate error

I’ve coded my app to use https, but if a https transaction fails for any reason, I assume it’s because the server isn’t configured for https, and thereafter start all transactions with http. Seems like that’s a vulnerability. Likewise, a script kiddie using a proxy to intercept the traffic on his client hardware would be able to make all https transactions fail.

I’m told that if someone tries to MITM your app’s HTTPS request then the request should fail (invalid certificate) and your app should fail with an error, not fallback to HTTP. In a world where SSL is reliably available, sure, but maintaining valid SSL certs is a task in itself. For example, letsencrypt recently revoked some of their certificates and forced renewal of same because of some security problem. Aside from revocations, certs are short term and have to be renewed, and the renewal process involves a lot of stitchware, and can fail. If SSL goes down, I don’t want my site to go dark.

What is the best guidance for either:

  1. More reliably maintaining certificates (such that if they do fail, the resulting downtime falls within the "five nines" SLA unavailability window) without it being such a manual headache, or

  2. Allowing the site to continue to work if SSL has failed? Is it easy to allow most activity to proceed using http, but allow known-critical transactions to require https.

Note that no browsers are involved in the scenarios that concern me.

How to avoid the guidance cantrip from dominating the game without creating any benefit?

The guidance cantrip is bothering me – not because it makes ability checks easier but because it does not have a relevant opportunity cost and because it disrupts the flow of the game. Any time a skill check is required that can be foreseen players can just use the cantrip. I find this very annoying, since it causes a lot of extra dice rolling and discussion without any meaningful decisions that would add anything to the game.

I do know that the spell requires concentration, that I can create opportunity costs through my content and that I could just ban the spell outright. This was extensively discussed in this question: Casting Guidance cantrip for every roll?

I could ban the spell but I would like to avoid that and creating additional complications specifically for this spell is a lot of work. Are there other, easier solutions?

General guidance on pricing goods, services, and balancing economy

As I’m making my way through a campaign, I’m beginning to realize that I don’t know what to do about money. My tier 2 (out of 6) players have 200 shins (gold in Numenera terms) between 5 of them, we don’t know if that’s a lot or a little, and we stopped caring about money altogether – finding monetary rewards is not exciting, and money is not a motivator. I’m trying to price and offer some goods and services — which will create the desire for players to spend (and acquire) wealth.

Is there some generic guideline against which I can use to price things? I think I just don’t have a good gut feeling how to price hiring a group of guards or a spy for a month vs a sack of grain or price of a sword.

How do I begin to estimate price of goods and services? Are there good resources to help me?

Guidance for a basic responsive website

Hello, this is my first post on this forum.
I need to make a new website, a quite simple one with some pages.
It is a company website (my company) and for selling a product.
The product is a software for Windows (I mention that so you can know more or less what the site is about).

I've been reading how to make a responsive website, but I have some questions and I need some place to ask them, so here I am. I hope that I came to the right place, and if it is not, please point me where I…

Guidance for a basic responsive website

Do Guidance and Bardic Inspiration bonus dice stack?

The feature/cantrip descriptions says nothing about their dice can not stack:

Bardic Inspiration

… use a bonus action on your turn to choose one creature other than yourself within 60 feet of you who can hear you. That creature gains one Bardic Inspiration die, a d6. Once within the next 10 minutes, the creature can roll the die and add the number rolled to one ability check, attack roll, or saving throw it makes.

Guidance

You touch one willing creature. Once before the spell ends, the target can roll a d4 and add the number rolled to one ability check of its choice.

That feels wrong to me, since a pair of 1-level characters can have ridiculously high (up to +10, +6 average) bonus to an ability check.

To my knowledge, bonuses in D&D 5e (advantage, proficiency bonus, etc.) do not stack, hence the question. Can a player use both Bardic Inspiration die AND d4 from Guidance for the same check?

I’ve found a related question, but it is about 3.5e.