Hacker News new | past | comments | ask | show | jobs | submit | jskrablin's comments login

Take a look at https://github.com/hapostgres/pg_auto_failover it's quite simple to use and manage. You can use libpq support for target_session_attrs (been there since Pg 10 - https://paquier.xyz/postgresql-2/postgres-10-libpq-read-writ... ) so you don't need active loadbalancer in front of your Pg cluster.

You can however create your own health/status check service on top of pg_autoctl show state and use HAProxy if required.

I don't think there's something easier to setup and manage than pg_auto_failover, Patroni always appeared very complicated to me.


Please stop with this nuclear nonsense. There's enough nuclear warheads in EU to make sure nothing is left of major Russian cities in case somebody got too bald. Dictators aren't suicidal maniacs, they're "just" maniacs.


That's true for the most part, but there are plenty of suicidal maniacs in this world, and it is partially luck that none of them have yet managed to become dictators of countries with nuclear arsenals. It's not a given.


You don't think you know how nuclear war works



ChatGPT did it!


Gomorrah (Gomorra), book by Roberto Saviano explains fashion brands business like this in detail (among others). Highly recommend, though sometimes quite depressing read.


I don't want to live in a city. It's noisy, polluted, crowded and I really like my small countryside house with plenty of land around it. Lived in a city for 20 years, got fed up with it, despite all of the alleged 'advantages' it offers. I guess I don't deserve decent infrastructure in your world view?


No, you don’t. plain and simple. Tons of people living together share the costs. the few in the suburbs need to pay for their own infra. They’re not now. The cities are subsidizing the suburbs. that’s not fair.

https://m.youtube.com/watch?v=7Nw6qyyrTeI


I've watched that video and seen it quoted a fair number of times, but I don't see how it jives with the reality of tax collection and spending - at least in my area of residence (ATL). I'd love some hard data on how the city is subsidizing the suburbs.

Instead, the recent trend has been that wealthy areas near downtown (e.g. Buckhead) have been trying to incorporate so that they're no longer subsidizing the rest of the city.


[flagged]


The food is not only bought with money, but also subsidized. With tax dollars from cities.


dude... where do the imports of petroleum and fixed nitrogen which are critical for Ag come from? hint: look at the US ports and see what surrounds them.

farming and suburbia are subsidized out the wazoo. and a lot of Ag doesn't go to feed people... you're bark is much, much worst than your bite.


Your sentiment can be summarized as "Fuck you, I got mine." Hardly convincing.

As an aside, the countryside can survive without cities but cities cannot survive without the countryside. Perhaps consider your dependences before brazenly brushing them off.


There's absolutely no way farmers can be more than subsistence farmers without selling to the masses in the city. Country farmers like to pretend they enjoy living off the land but outside of what they actually sell to make money, they would be losing same amenities as the city that they are not willing to give up.


no, my sentiment is you’re stealing from me and not even aware of it. you’re taking more than your portion.

Cities need farms (a few people and a few roads) they don’t need suburbs (people wasting resources, living large, and stealing tax resources from the cities to subsidize their lifestyle)


I think it's great to live in the country but you should not expect the government to bail you out. That's part of the deal. I myself have thought about buying country property, but as a responsible property owner, I bear the cost for adding infrastructure, and, in return, I get the sole enjoyment. That's the deal. If you want the infrastructure built for you then you need to accept public use of it. That means the government gets to decide how large that public is too.


You can have whatever local infrastructure yourself and your community can afford.

You can have whatever connection to the rest of your state your community and the state can afford and decide upon.

FWiW I've very much been there, I grew up in the most remote corner of a state 3x larger than Texas with a population (then) of under 1 million.

We graded our own airstrip, 150 km of road, maintained our own vehicles and aircraft, fed and managed our horses and camels, loaded and unloaded ships off the mud flats at low tide.


If you’re willing to split the cost with ten people rather than ten thousand, have at.


Most of the noise and pollution in cities comes from cars.


    > I guess I don't deserve decent infrastructure in your world view?
Do you pay enough taxes to demand it? Probably not.



Or use a few drops of threadlocker...


Every political system clouds the reason and appeals to emotion. There are very few policies anywhere that are grounded in science. They may be, initially, until they get massacred by politicians to get them aligned with currently dominant ideology (which by definition is a belief system, grounded mostly in fairy tales about who's better than everyone else).

Just take a look at the current state of democracy... and let me know where the science is hiding.


> Every political system clouds the reason and appeals to emotion

No, I don't subscribe to this.


No.


Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: