Skip Navigation

Help with Postgres

  • I couldn't get my container started with postgress running but I had an idea:

    I started the upgrade process with Lemmy-Easy-Deploy,

    canceled out of it before it removed the containers,

    ran sudo docker exec -i lemmy-easy-deploy-postgres-1 psql -U lemmy -c "alter user lemmy with password 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'"

    with the password set in my env file,

    then restarted the upgrade process. It's running again.

    • Help with Postgres

  • The odd part is that it was running fine until the upgrade.

    • Help with Postgres

  • I used the Lemmy-Easy-Deploy method but the catch is that I migrated from Google Cloud Free Tier to a paid server with another host. I have the backups so I can always restore from that if I really have to. I have an env file with the password that it should be using but I'm not sure how it was changed...

    • Selfhosted @lemmy.world
    MarsAgainstVenus @lemmy.world

    Help with Postgres

    I went to upgrade Lemmy from 18.4 to 18.5 but in the process it failed with an incorrect Postgres password error. I'm trying to create a new docker container and mount the postgres volume in order to reset the "lemmy" user password but can't figure out how to get it running without knowing the password.

    Could anyone point me in the right direction, please?

    Project

    Having trouble deploying Lemmy? Try my new script! Get up and running in minutes!

  • What Cloudflare API am I supposed to use?

    • Mastodon Usage Soaring as Twitter Rebranding Leads to User Exodus: CEO Eugen Rochko

  • Good point. I did follow a few accounts I already follow on Mastodon. But then I thought "I have a Mastodon account already... Why am I doing this?"

    And the Emojis instead of starring a post was throwing me off.

    edit: I see there is a star online now. Maybe it was just the Kimis app that was weird.

    • Mastodon Usage Soaring as Twitter Rebranding Leads to User Exodus: CEO Eugen Rochko

  • Is Firefish the same thing as Calckey?

    I created a Calckey account a couple of weeks ago but it was basically a weird Mastodon with even fewer people from what I could tell.

    • Lemmy.world update: Downtime today / Cloudflare

  • You have more faith in people than I do…

    • Here's How Reddit F**ks Advertisers

  • Project Manager

    • Stars leave Oppenheimer premiere as Hollywood actors' strike called

  • What’s wrong with it? (I’ve never seen it)

    • Permanently Deleted

  • I’m think I’m seeing a trend…

    • Libreddit and Teddit are practically dead

  • Did you request him to a add the ones you want?

    • App Store Update Released 🥳 - Please Update Your Account if on Lemmy.world - Working on better fix now - Push notifications online, fixing some issues there too

  • I added my account a second time and deleted the first one but it deleted both, lol.

    But this seems to have fixed the issue! Thanks @[email protected], @[email protected], and @[email protected]!

    • Reddit protest updates: news on the apps shutting down and Reddit’s fights with mods - The Verge

  • What sub was it?

    • I'm obviously old. what is this "rule" trend I'm seeing everywhere on Lemmy?

  • I blocked them this morning. Didn’t want to but it was overwhelming.

    • “Sync for Lemmy is happening!”

  • I’ve been testing both and I definitely prefer Memmy overall. Mlem has better image display options and has search. Memmy doesn’t display images unless you tap on the post. Search should be released in the next day or two, though.

    Artemis being an Apollo clone had me very excited, though.

    Edit: new app just released on TestFlight showing real promise: Limbo

    • YSK that you can edit titles on Lemmy, unlike Reddit.

  • I'm on lemmy.world and I can see the time and date your comment was posted and same for edited.