pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Error message is displayed if user create new database with pgbouncer port 6432

Open FaharAbbasRizvi opened this issue 2 years ago • 0 comments

Error message is displayed if user create new database with pgbouncer port 6432

To Reproduce

Steps to reproduce the behaviour:

  1. Install PostgreSQL 15 and Install pgbouncer through StackBuilder
  2. Launch pgAdmin4
  3. Add a New server
  4. Provide the name
  5. In the Connection field, select port 6432 and maintainceDB select postgres and add New server
  6. Server added successfully
  7. create new database pgbouncer
  8. Following error message is displayed: invalid command 'SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_settings WHERE name = 'bytea_output'; SET client_encoding='UTF8';', use SHOW HELP;
  9. create another database pgbouncer1
  10. Following error message is displayed: connection failed: :1), port 6432 failed: FATAL: no such database: pgbouncer1

Please note that databases should be created successfully through psql if port is 6432.

Expected behavior

If the user connects with pgbouncer 6432 port then the database should be created.

Screenshots

Screen Shot 2023-05-22 at 1 31 31 PM Screen Shot 2023-05-22 at 1 36 04 PM

Desktop (please complete the following information):

  • OS: [e.g. Windows 10, OSX monterey]
  • Version: [e.g. 7.1]
  • Mode: [All
  • Package type: [Any]

FaharAbbasRizvi avatar May 22 '23 08:05 FaharAbbasRizvi