4

Im trying to setup a streaming replication on a rds postgresql database using pg_recvlogical. When I send the command to start streaming

pg_recvlogical -d <database> -h <host> -p <port> --slot (slot_name) --start -f -

I receive the message:

"could not send replication command "Show data_directory_mode": ERROR: must be superuser or replication role to run this operation".

Im using the master user, which already has superuser role, and set rds.logical_replication to 1 on parameter group associated to the database. Anyone can help to undestand how can I resolve this issue?

Improve this question
2
  • same here. I think it a bug Commented Apr 29, 2020 at 23:49
  • any luck with this? Commented Jul 9, 2020 at 14:36

1 Answer 1

Reset to default
1

Logical replication with pg_recvlogical does currently not work correctly on RDS. The workaround is to use a 10.x pg_recvlogical client. Since the 'data_directory_mode' parameter was introduced with 11.x, a 10.x client will not send the command and hence work fine.

Source: https://forums.aws.amazon.com/thread.jspa?messageID=936554

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.