How do I start PostgreSQL?

Hello,

  • _OpenMandriva Lx version:_5.0

  • Desktop environment (KDE, LXQT…): Plasma

  • Description of the issue (screenshots if relevant):
    I have downloaded and installed postgresql, postgresql-server, and postgresql-devel, but usually there is other setup like creating a password for user postgres or starting a postgresql background service, but I can’t find any instructions for that. At least, none that work.

  • Relevant informations (hardware involved, software version, logs or output…):

systemctl start postgresql. The user is already created with default settings (no password, but allowing access from localhost only - you can set a password from there).

Thank you for the quick response. I tried that, but it says Unit postgresql.service not found.

Ah, right, it’s because you’re on 5.0.
Try systemctl start postgresql16

We used to have a versioned systemd file here, but switched to unversioned because a user shouldn’t have to adapt scripts when we move to a newer version.

Thank you. That worked.

1 Like

Please mark the thread solved. :slightly_smiling_face:

One more question. Do I need to setup a script in the startup so that happens every time I boot up? And, if so, how do I do that?

systemctl enable postgresql16

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.