I installed the postgresql and devpkg-postgresql through swupd but that didn’t actually create any postgres user nor ran any service. I tried to create both manually, but it wouldn’t launch (unknown error), so I’m guessing it did not install the required files (I have the required dependencies, including dev tools, openssl, i even installed database-basic to be sure).
I tried to follow the documentation on the postgres website for manual install from source but that did not work either (i did the short and long version of chapter 16 / installation). I managed to run make install and it did what it had to, but it did not create the user, and still no service running.
I tried to add the user manually through useradd (since their command lists adduser), and that did not return me a valid user either. I tried to start the service manually through systemctl but that returned an unknown error.
I sank a couple hours into this searching the deep internet for answer but couldn’t find any, has anyone managed to run postgres, tell me what I’m doing wrong please kind OG people of the linux community (p.s. sorry about all my recent noobish inquiries on this forum, you are all too smart and kind!).
Even after : useradd postgres and passwd postgres I cannot su - postgres it says This account is currently not available. There is no postgres user in my /etc/passwd either. When i try to run useradd postgres again it tells me the user already exists. I tried to manualy add the user in my passwd file with the information copied from my ubuntu install of postgres but that didn’t work either.