Arch Linux

Llama

Banned

From: St.-Petersburg, Russia

Registered: 2008-03-03

Posts: 1,379

[SOLVED] PostgreSQL: password?

Hi,

While installing PostgreSQL got stuck here (ArchWiki):

As user 'postgres' start the database (see first paragraph of this document for instructions on how to become a postgres user):

$ su - postgres
$ initdb -D '/var/lib/postgres/data'

su requires a password, but what kind of password? Presumably, it's the postgres user's password, but this user has been created silently, without asking for a password. Neither the root password, nor my own user's passwod fit, which looks reasonable.

Last edited by Llama (2013-04-24 16:04:00)

discon

Member

Registered: 2010-06-28

Posts: 23

Re: [SOLVED] PostgreSQL: password?

Take a look at the "Before you start" section of the wiki.

In short, either become root before becoming postgres, or use sudo with the su command.

Llama

Banned

From: St.-Petersburg, Russia

Registered: 2008-03-03

Posts: 1,379

Re: [SOLVED] PostgreSQL: password?

Thanks, discon!

Your advice is lucid enough, the Wiki is not, IMO.

WorMzy

Forum Moderator

From: Scotland

Registered: 2010-06-16

Posts: 11,892

Website

Re: [SOLVED] PostgreSQL: password?

use sudo with the su command.

In the same way that you use 'vim +\!nano' to open a text editor?

Use 'sudo -i', not 'sudo su'. 'sudo su' is just redundant.

---

Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.