Re: Getting started with first user.

Поиск
Список
Период
Сортировка
От Agnar Renolen
Тема Re: Getting started with first user.
Дата
Msg-id b4638391-aae4-1195-ac0c-8334711e749f@gmail.com
обсуждение исходный текст
Ответ на Re: Getting started with first user.  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general

Found out a way out.

Logged in as root, and created a password for the postgres user.

Then logged in as postgres and and ran "createuser -s me".

Then logging in as me, ran "createdb"
Agnar

On 09/01/2018 17:13, Adrian Klaver wrote:
On 01/09/2018 01:48 AM, Agnar Renolen wrote:
I have just installed PostGIS (Postgres9.6) on a Debian server using apt-get.

But I have problems doing anything:

I installed as root, but trying doing things as my local user "me"

me> createuser me
createuser: could not connect to database postgres: FATAL: role "me" does not exist

Then, trying the same as root, but gettinge the same result.

root> createuser me
createuser: could not connect to database postgres: FATAL: role "root" does not exist

Then trying with the -U postgres option.

root> createuser -U postgres me
createuser: could not connect to database postgres: FATAL: Peer authentication failed for user "postgres"

How do I get started?


https://wiki.debian.org/PostgreSql#User_access



В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: data-checksums
Следующее
От: Moises Lima dos Anjos
Дата:
Сообщение: Hi i like to unscribe me, sorry for the incovenient.