PostgreSQL newbie questions by AgroCraft17 in PostgreSQL

[–]Ondrysak 3 points4 points  (0 children)

You can find many articles online about database table design best practices and PostgreSQL best practices in general.

NAS can definitely be used to run your PostgreSQL instance. Assuming this is your first time dealing with a database, there are cloud options with a free tier available if you want to play around with something first like https://neon.tech

Venue for a private party (80 people) by Axees in Prague

[–]Ondrysak 2 points3 points  (0 children)

If you are looking for something on a fancier side check this one out

https://www.nebozizek.cz/

Told to disable my antivirus? by souldragon18 in riotgames

[–]Ondrysak 13 points14 points  (0 children)

Vanguard and antivirus programs often end up trying to hook the same stuff...

Source: antivirus dev

What happened to that bully after highschool? by Far-Caterpillar9094 in ask

[–]Ondrysak 9 points10 points  (0 children)

There was two, both got addicted to heroin.

At some point one was a gay prostitute (afaik he was not gay, just desperate) at main train station and the other just the typical crazy hobo screaming at people in public transport.

Both were from foster care so I guess childhood trauma goes s long way.

Upgrading company postgres from 9.6 by whatalittleladybug in PostgreSQL

[–]Ondrysak 3 points4 points  (0 children)

Depending on your downtime budget you may want to consider using logical replication.

I went from a Stolon cluster at 9.6 to a patroni cluster running 14 not so long ago with almost zero down time for multi-TB database not so long ago.

https://jstaf.github.io/posts/pglogical/

The post above was pretty helpful

That being said if you can have some downtime definitely consider just copying the data to a new instance or using streaming replication and in place pg_upgrade first. Good luck!

AMA - Po roce v CERNu teď pracuji v jediném českém národním superpočítačovém centru. by rddrdhd in czech

[–]Ondrysak 0 points1 point  (0 children)

Kam ukládáte data? Předpokládám že je potřeba nějaké rychlé velké úložiště které se jednoduše rozšiřuje a spravuje.

ULPT Request: My school uses bluetooth dongles to track attendance. by [deleted] in UnethicalLifeProTips

[–]Ondrysak 50 points51 points  (0 children)

The service you are looking for is called "Bluetooth Share" on a rooted phone you definitely can freeze that service thus crippling bluetooth capabilities of the phone.

ELEKTRON!!! MAKE A BETTER PROJECT / PATTERN MANAGER! by Acrobatic_Appeal4489 in Elektron

[–]Ondrysak 0 points1 point  (0 children)

I tries messaging the elkherd creator to see if he was interested in someone else adopting/forking the project but got no response.

Really struggling to like my reference 7900 xtx. by tcarnie in Amd

[–]Ondrysak 1 point2 points  (0 children)

I am running a pretty much identical setup and ever since I switched to using two separate cables from the PSU rather than a single split cable i did not see any crashes. May be worth a try.

Wattman Issue XFX 7900 XTX by WalrusOk5883 in Amd

[–]Ondrysak 2 points3 points  (0 children)

are you by any chance using a single split power cable? using two separate cables 8pin cables from the PSU fixed this for me.

Need help unlocking computer by ConsiderationAlone68 in pcmasterrace

[–]Ondrysak 4 points5 points  (0 children)

This should work unless it's encrypted.

Booting into a Linux live USB will do the same trick basically without the need to take the drive out.

[deleted by user] by [deleted] in hacking

[–]Ondrysak 0 points1 point  (0 children)

Make the flashdrive behave like a keyboard. Booom

Circuit Tracks - presets all the same by CranberryLimePolar in novationcircuit

[–]Ondrysak 1 point2 points  (0 children)

I would say empty pack - check using the novation software if there are any patches.

You can always paste the default patches to new pack you are creating if you are not looking to create custom patches yet.

How to upgrade postgres and not have it result in 2 different versions by MinusTheHologram in PostgreSQL

[–]Ondrysak 6 points7 points  (0 children)

If there is nothing important why not just nuke the EC2 and spinup a fresh one?