Kovah

Kovah, 5 months ago

@timo3000 Bei Hetzner gibts gute kleine Server auf denen das läuft was du möchtest für 5€ im Monat. Wenn ARM kein Problem ist gibt es sogar mehr Leistung für das gleiche Geld.
Bin dort seit Jahren Kunde und extrem zufrieden.

Mit dem Link bekommst du 20€ Guthaben zum testen: https://hetzner.cloud/?ref=77Qtn2Mu0tDz

Kovah, 5 months ago

@amadeus The Whale is especially hard to watch. You know it's a good drama if you have this dull feeling in your stomach... 😅

Kovah, 6 months ago

@denniskoch agree, I never ever changed anything in it, but I guess it’s needed for very special use cases.
I would remove it and move the cache folder inside into the storage directory.

Kovah, 6 months ago

@tomasv The problem is Postgres being super picky about how and what must/should be exported to be properly imported somewhere else. After I almost got the import working without any warnings of duplicate tables or relations, Postgres complained that the old user wasn't matching the new one, thus the import cannot be completed. I ended up changing my dev environment to match the prod system to be able to import that database.

Kovah, 6 months ago

@tomasv @ascherbaum As someone coming from MySQL, Postgres hard to use more often than it should be. And I'm pretty sure that the core devs have a strong opinion about why Postgres is the way it is.

Kovah, 6 months ago

@tomasv Well that's the joke: the schema is exactly the same. But I haven't found a way to export just the data and then export it into a database which is exactly the same. I juggled with --only-data, --clean and a couple of other options during export and import.
I'm using TablePlus, which seems to use pg_dump and pg_restore.

Anyway, this should not be a help thread. I got it working, but with a lot of headache. Maybe I'm too dumb, but I can't remember similar with MySQL databases.

Kovah, 6 months ago

@tomasv @ascherbaum Good to know, thanks for taking the time to investigate this further.
Maybe I can put together something and put it on my blog.

Kovah, 6 months ago

@tomasv @ascherbaum I've put together the rough time line and recreated the issues I had for the exact error messages. https://blog.kovah.de/en/2023/the-odyssey-of-a-postgres-restore/
The solution sounds rather trivial, but the journey to find it was exhausting.

Kovah, 6 months ago

@ascherbaum @tomasv Thanks for the long response. I feel like I understand only half of what you are trying to explain. 😕
I might be naive, but the user should not have to read pages of documentation just to copy data from one database into the other. It’s really just that and I can do this in MariaDB in like a minute.

Kovah, 6 months ago

@ascherbaum @sycobuny @tomasv I am not sure what template0 and template1 are, and why my database has some things in the last one.
I double checked how MySQL dumps are created. The resulting dumps drop a table if it exist, then create it, then the data is imported. I'm pretty sure it's been like that for years and it's working fine. I expected Postgres to behave the same, but obviously it works differently. Maybe it was my fault to not check how it's done in Postgres before.

Kovah, 6 months ago

@ascherbaum @sycobuny @tomasv Do you have a link to a good beginner-friendly explanation, what template0 and template 1 are and what they do? Would like to know more about that. 😊

Kovah, 6 months ago

@dseguy I think it’s totally fine to have $variable ?? null in your code. It makes sure the variable has at least some value and is defined.

Kovah, 6 months ago

@selea Do it!

Kovah, 6 months ago

@astrojuanlu Thankfully, I'm not directly affected by burnout right now, but I've been trough it before. And it's horrible. Being compensated for hard work can be a huge booster, but if merely anyone values you work to spend $10, all the hundreds of hours feel like a complete waste of time.

Kovah, 6 months ago

@ercanbrack Unfortunately, compensation is mostly not the first thing people think of when they start a passion project (like I did with LinkAce). When such a project becomes popular, it becomes more and more evident, that other people and companies expect open source software to be also free.
As I wrote in the other comment, it can be a huge booster if you a properly compensated, but in 95% maintainers are left alone with $5 donations from a couple of fans. 🤷