Fwd: Cannot log in as newly created user EXTRA INFO

Поиск
Список
Период
Сортировка
От Emma Saurus
Тема Fwd: Cannot log in as newly created user EXTRA INFO
Дата
Msg-id 5677925D.7030509@westnet.com.au
обсуждение исходный текст
Ответ на Cannot log in as newly created user  (Emma Saurus <emmasaurus@westnet.com.au>)
Ответы Re: Fwd: Cannot log in as newly created user EXTRA INFO  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Fwd: Cannot log in as newly created user EXTRA INFO  (Kevin Grittner <kgrittn@gmail.com>)
Список pgsql-bugs
Hi, I'd like to add another error example to my original query, please.
This is a simpler example of another method I have tried which does not
work for me (and which I'm sure people will advise me to try):

postgres-# CREATE USER EmmaChwan WITH ENCRYPTED PASSWORD 'password';
 > CREATE ROLE
postgres=# \q

C:\Users\EmmaChwan>psql
 > Password:
 > psql: FATAL: password authentication failed for user "EmmaChwan"

Thanks! Emma

-------- Forwarded Message --------
Subject:     Cannot log in as newly created user
Date:     Sat, 19 Dec 2015 19:14:09 +0800
From:     Emma Saurus <emmasaurus@westnet.com.au>
To:     pgsql-bugs@postgresql.org



Hello, I hope that you may be able to help me with this very basic
problem. I have read many fora posts as well as your documentation, and
have been unable to resolve it myself.

I am running PostgreSQL 9.3.10. I can log in as the default postgres
user. I follow instructions to create a new role with a password. I log
out and try to log in as the new user, but am not permitted. I've tried
several variations of code without success. Latest, most
out-of-the-manual code as follows:

---
postgres=# CREATE ROLE EmmaChwan CREATEDB LOGIN PASSWORD 'password';
> CREATE ROLE
postgres=# \q

C:\Users\EmmaChwan>psql
> Password:
> psql: FATAL:  password authentication failed for user "EmmaChwan"
---

I don't know if it's related, but just for the record: I had
installation issues, too.

I tried to install postgres 9.4 several times with the EnterpriseDB
Windows package (also re-downloaded the package a couple of times). I
was never given the option of entering a password, and the generic
password 'postgres' did not allow me to log in. I tried installing
without any antivirus/firewall software active; still no success.

When I installed version 9.3, I was given the password creation screen
and could log in via command line with the password I set. Success! Kinda...

I'm running Windows 8 x64 on an Intel processor, if that information is
of any use at all. I've seen a number of users post with the same 'no
password screen' problem, and each was told, "Nuh-uh, you did too get a
password screen." I can cast one vote in favor of those posters not
being crazy / premature 'Next'-button clickers.

Any help you can offer would be greatly appreciated. It's very
discouraging to get stuck on something so basic!
Thanks, Emma

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

Предыдущее
От: Emma Saurus
Дата:
Сообщение: Cannot log in as newly created user
Следующее
От: Greg Clough
Дата:
Сообщение: Re: BUG #13770: Extending recovery_min_apply_delay on Standby causes it to be unavailable for a while