From: | Mike Lissner <mlissner(at)michaeljaylissner(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | CREATE SUBSCRIPTION fails with long passwords |
Date: | 2019-04-24 17:07:45 |
Message-ID: | CAMp9=EyTcrRk1QPzmfNkt2OY8HOh-5DVW_CuXa-p2c8JoJOSMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
This made me a bit crazy tonight. Steps to reproduce:
1. Create a new role and give it a really long password. Ours was 108
chars.
2. Set up all the necessary replication permissions/roles.
3. From another computer, try to connect as that user using psql — it works!
4. Now try a CREATE SUBSCRIPTION command like:
create subscription my_sub connection 'host=192.168.0.111 port=5432
user=the_new_user password=long_password dbname=my_db sslmode=require'
publication new_server;
You'll get the following error:
ERROR: could not connect to the publisher: FATAL: password authentication
failed for user "the_new_user"
Now, go back and shorten that password, and try again. You'll get:
create subscription my_sub connection 'host=192.168.0.111 port=5432
user=the_new_user password=long_password dbname=my_db sslmode=require'
publication new_server;
NOTICE: created replication slot "my_sub" on publisher
CREATE SUBSCRIPTION
And it'll be off to the races. I watched the logs on both servers during
these experiments. Nothing much in there, aside from the logs above.
Is this known functionality? Seems like a nasty bug and it took me a while
to figure it out.
Thanks,
Mike
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2019-04-24 18:59:46 | Re: amcheck assert failure |
Previous Message | Tom Lane | 2019-04-24 14:26:57 | Re: bug: evil autoConcat when each string is on new line |