PostgreSQL Database Remote Connection Error: Difference between revisions
Created page with "= PostgreSQL Database Remote Connection Error = = Error: `no pg_hba.conf entry for host` = When trying to connect remotely to your PostgreSQL database, if you get an error message that says `no pg_hba.conf entry for host`, this means you don't have remote access. = Remote Access to PostgreSQL is Disabled by Default = Most users do not need or want remote access to their PostgreSQL databases, so it's disabled on our shared hosting accounts by default for security reas..." |
mNo edit summary |
||
| Line 1: | Line 1: | ||
= PostgreSQL Database Remote Connection Error = | = PostgreSQL Database Remote Connection Error = | ||
= Error: | = Error: 'no pg_hba.conf entry for host' = | ||
When trying to connect remotely to your PostgreSQL database, if you get an error message that says | When trying to connect remotely to your PostgreSQL database, if you get an error message that says 'no pg_hba.conf entry for host', this means you don't have remote access. | ||
= Remote Access to PostgreSQL is Disabled by Default = | = Remote Access to PostgreSQL is Disabled by Default = | ||
| Line 13: | Line 13: | ||
To request remote access to PostgreSQL, please post a request in our [https://helionet.org/index/forum/45-customer-service/?do=add Customer Service forum], making sure to provide your '''hosting account username''', '''database name''', and the '''database user name''' you want to have remote access. An admin will enable remote access for you and provide you with the remote connection details. | To request remote access to PostgreSQL, please post a request in our [https://helionet.org/index/forum/45-customer-service/?do=add Customer Service forum], making sure to provide your '''hosting account username''', '''database name''', and the '''database user name''' you want to have remote access. An admin will enable remote access for you and provide you with the remote connection details. | ||
= Can I edit the PostgreSQL | = Can I edit the PostgreSQL 'pg_hba.conf' file myself? = | ||
No. Allowing users to edit this file could enable them to remove password protection from other users' databases and access anything they wanted on the entire server, which would obviously be a huge security vulnerability. | No. Allowing users to edit this file could enable them to remove password protection from other users' databases and access anything they wanted on the entire server, which would obviously be a huge security vulnerability. | ||
| Line 21: | Line 21: | ||
No. Plesk, like most control panels, has extremely limited support for PostgreSQL, and you can't enable remote access yourself. | No. Plesk, like most control panels, has extremely limited support for PostgreSQL, and you can't enable remote access yourself. | ||
If you prefer to handle remote database access yourself, you can create a MariaDB database inside Plesk. When creating the new MariaDB database, select one of the | If you prefer to handle remote database access yourself, you can create a MariaDB database inside Plesk. When creating the new MariaDB database, select one of the 'Allow remote connections' options under MariaDB's 'Access control' settings. | ||
If you want to enable remote database connections to PostgreSQL databases yourself, you would need to get one of our [https://heliohost.org/vps/ VPS plans]. | If you want to enable remote database connections to PostgreSQL databases yourself, you would need to get one of our [https://heliohost.org/vps/ VPS plans]. | ||
Revision as of 03:29, 1 November 2024
PostgreSQL Database Remote Connection Error
Error: 'no pg_hba.conf entry for host'
When trying to connect remotely to your PostgreSQL database, if you get an error message that says 'no pg_hba.conf entry for host', this means you don't have remote access.
Remote Access to PostgreSQL is Disabled by Default
Most users do not need or want remote access to their PostgreSQL databases, so it's disabled on our shared hosting accounts by default for security reasons.
How to Request Remote Access to PostgreSQL
To request remote access to PostgreSQL, please post a request in our Customer Service forum, making sure to provide your hosting account username, database name, and the database user name you want to have remote access. An admin will enable remote access for you and provide you with the remote connection details.
Can I edit the PostgreSQL 'pg_hba.conf' file myself?
No. Allowing users to edit this file could enable them to remove password protection from other users' databases and access anything they wanted on the entire server, which would obviously be a huge security vulnerability.
Can I enable remote access to PostgreSQL myself?
No. Plesk, like most control panels, has extremely limited support for PostgreSQL, and you can't enable remote access yourself.
If you prefer to handle remote database access yourself, you can create a MariaDB database inside Plesk. When creating the new MariaDB database, select one of the 'Allow remote connections' options under MariaDB's 'Access control' settings.
If you want to enable remote database connections to PostgreSQL databases yourself, you would need to get one of our VPS plans.