This is a bug report forwarded and translated from a Chinese LibreOffice user chat group. The original reporter complains that the example given by Base's database wizard for connecting to a PostgreSQL database is wrong. The port number can not be specified like in the example. Steps to reproduce: 1. Open Base, the Database Wizard dialog appears; 2. In "Select database" step, Select "Connect to an existing database", choose PostgreSQL from the dropdown list, click Next; 3. Now in "Connection settings" step, the text above the input box says "Datasource URL: (e.g. host=$host:$port dbname=$database)"; 4. Type URL according to the example, "host=localhost:5432 dbname=test". Expected Result: Type URL like the example, "host=localhost:5432 dbname=test", and connect to the PostgreSQL database. Actual Result: Type URL like the example, "host=localhost:5432 dbname=test", but can not connect to the PostgreSQL database. Use "host=localhost port=5432 dbname=test" instead, and correctly connect to the database. Additional information: The original reporter was using LO 7.1.3 on Windows 10, connecting to PostgreSQL 12.6: Version: 7.1.3.2 (x64) / LibreOffice Community Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1 CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win Locale: zh-CN (zh_CN); UI: zh-CN Calc: threaded I myself don't have any experience about PostgreSQL or any SQL database, and therefore can not try to reproduce.
*** This bug has been marked as a duplicate of bug 132476 ***