PostgreSQL says it’s included in Ubuntu related operating systems, but I’m not sure. I’m unable to start the service, or set up new servers in PgAdmin. I’ve tried to install the repositories but I’m either getting “1831” architecture errors, or no release file errors. I’ve tried fixing the list file, but it doesn’t seem to help. If anyone can help i would really appreciate it

The course I’m taking provides download links for an installer for windows, and Mac. After this and another problem I’ve had on Mac back in the day I’m thinking of switching to windows. Maybe the development software works better there.

  • adr1an@programming.dev
    0·
    2 years ago

    I had issues with setting a postres user, or adding my user to the postgres user group… It’s confusing because there are Linux users and Postgres users, you can mix and match… make it work. I did, but forgot how. Switched to docker (setting postgres user and password in docker compose) and moved ahead… Simpler, cleaner, manageable.

    • Creatortray@lemmy.worldOP
      0·
      2 years ago

      I actually got it working thanks to @fal@yiffit.net i learned two things. First i need to be more careful about what questions I’m asking. The second thing is to use ChatGPT wisely.

  • Fal@yiffit.netEnglish
    01·
    2 years ago

    This whole question is extremely confusing, and the fact that you would consider switching to windows makes me think this is just trolling.

    sudo apt-get install postgres is literally all you need to do. Then systemctl start postgresql.service

    But you should probably be using docker anyway.

    docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres

    Like, you’re editing sources list files? Where did you read that that’s a thing you should be doing?

  • ExperimentalGuy@programming.dev
    01·
    2 years ago

    Start up a fresh VM in the distro you’re using and follow instructions on how to initialize it there. If you do this and it works on the VM, you’ll know it’s some sort of system config error instead of a user error. I have no other ideas bc I’ve never done that before but best of luck :)