1. Overview

• Definition: Covers the network settings and validation rules required to connect Mobio to a PostgreSQL database.
• Users: System Admin, Data Engineer.

2. Terminology & Configuration Parameters

• PostgreSQL — A cross-platform, open-source relational database management system.
• Standard port — 5432.

3. Prerequisites

• Related article: Create Connector: Database
• Network permissions: Your database server must have Inbound Rules configured to allow access from Mobio.

4. Configuration Limits by Field

Your connection must meet these minimum requirements before Mobio lets you save it:

• Database Name — Up to 63 characters. No spaces allowed. Case-sensitive: enter the exact database name. PostgreSQL itself treats an unquoted name as lowercase, but Mobio’s connection requires an exact match (e.g., if your server’s database is “db01” but you enter “DB01“, the connection fails).
• Hostname/IP — Up to 253 characters. Accepts IPv4 (e.g., 127.0.0.1) or an FQDN (domain name). IPv6 isn’t supported yet. Remove any http:// prefix or trailing slash /. Don’t include leading or trailing spaces (Mobio requires trimmed input).
• Port — Only positive integers (1–65535). The typical default port is 5432. No decimal points or other characters allowed.
• Username — Up to 63 characters. Mobio allows spaces in usernames but doesn’t automatically remove accidental extra spaces — enter this carefully. (If your database requires quoting a value with spaces in double quotes " ", enter it exactly as required.)
• Password — No length limit. Never include control characters like \0, \n, \r, \t. Avoid characters that can break a query, such as ', ", ;, --, /*. Mobio allows spaces (it doesn’t trim them automatically).

5. Operational Rules

• N/A

6. Frequently Asked Questions (FAQ)

• N/A

7. Next Steps

Back to Create Connector: Database