Adding and Removing pgsql_proxy_bind_address TServer flag incorrectly defaults port to 5433

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

https://www.yugabyte.com

Other

8.99k stars 1.07k forks source link

Open RunningJon opened 3 years ago

RunningJon commented 3 years ago

A customer created a Universe in Platform and overrode the default port of 5433 by making it 5432 (like PostgreSQL).

After the Universe was created, he added this TServer flag.

pgsql_proxy_bind_address = 0.0.0.0:5432

The database listened on port 5432 and there were no problems.

Next, he removed this flag in Platform. The port then changed to 5433 instead of remaining on 5432.

The workaround was to add the pgsql_proxy_bind_address flag back again.

hsu880 commented 3 years ago

According to our doc here:

5433 is the correct default. Not sure if this is a bug.

RunningJon commented 3 years ago

The customer overrode the default to make it 5432. Platform now shows the default to be 5432 but incorrectly defaults to 5433.

RunningJon commented 3 years ago

It is 100% a bug.

RunningJon commented 3 years ago