PostgreSQL Database Remote Connection Error - Revision history

KazVee: Add note for users to confirm they use PostgreSQL when asking for remote access. Convert to ordered list so all details more likely to be provided at once.

2026-05-12T19:11:17Z

Add note for users to confirm they use PostgreSQL when asking for remote access. Convert to ordered list so all details more likely to be provided at once.

← Older revision		Revision as of 19:11, 12 May 2026
Line 11:		Line 11:
	== How to Request Remote Access to PostgreSQL ==		== How to Request Remote Access to PostgreSQL ==

	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'''
			# Your '''database name'''
			# The '''database user name''' you want to have remote access
			# Confirmation that your database is '''PostgreSQL'''

			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? ==		== Can I edit the PostgreSQL 'pg_hba.conf' file myself? ==

KazVee: Use {{Template:VPSInfo}} for VPS Info

2025-08-31T18:48:47Z

Use {{Template:VPSInfo}} for VPS Info

← Older revision		Revision as of 18:48, 31 August 2025
Line 23:		Line 23:
	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 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 a ~~[https://heliohost.org/vps/~~ VPS~~]. We offer a range of VPS plans, starting at only $4 a month, and a 10% discount when you pay for 6 months upfront~~.		If you want to enable remote database connections to PostgreSQL databases yourself, you would need a VPS. {{Template:VPSInfo}}

	== Remote Access Transfers with Account Moves ==		== Remote Access Transfers with Account Moves ==

	Once remote access to your PostgreSQL database has been set up for you by an admin, if you [[:Moving_Your_Account \| move your account]] to another server, your remote access will be transferred to the new server. Please note that depending on your setup, you may need to adjust your code or configuration to reflect the new server name or IP address.		Once remote access to your PostgreSQL database has been set up for you by an admin, if you [[:Moving_Your_Account \| move your account]] to another server, your remote access will be transferred to the new server. Please note that depending on your setup, you may need to adjust your code or configuration to reflect the new server name or IP address.

KazVee: Update VPS details to show starting price of $4/month

2025-08-31T17:21:01Z

Update VPS details to show starting price of $4/month

← Older revision		Revision as of 17:21, 31 August 2025
Line 23:		Line 23:
	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 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 a [https://heliohost.org/vps/ VPS]. We offer a range of VPS plans, and a 10% discount when you pay for 6 months upfront.		If you want to enable remote database connections to PostgreSQL databases yourself, you would need a [https://heliohost.org/vps/ VPS]. We offer a range of VPS plans, starting at only $4 a month, and a 10% discount when you pay for 6 months upfront.

	== Remote Access Transfers with Account Moves ==		== Remote Access Transfers with Account Moves ==

	Once remote access to your PostgreSQL database has been set up for you by an admin, if you [[:Moving_Your_Account \| move your account]] to another server, your remote access will be transferred to the new server. Please note that depending on your setup, you may need to adjust your code or configuration to reflect the new server name or IP address.		Once remote access to your PostgreSQL database has been set up for you by an admin, if you [[:Moving_Your_Account \| move your account]] to another server, your remote access will be transferred to the new server. Please note that depending on your setup, you may need to adjust your code or configuration to reflect the new server name or IP address.

KazVee: Add note that remote PostgreSQL access transfers to new server during an account move

2025-04-20T20:16:53Z

Add note that remote PostgreSQL access transfers to new server during an account move

← Older revision		Revision as of 20:16, 20 April 2025
Line 24:		Line 24:

	If you want to enable remote database connections to PostgreSQL databases yourself, you would need a [https://heliohost.org/vps/ VPS]. We offer a range of VPS plans, and a 10% discount when you pay for 6 months upfront.		If you want to enable remote database connections to PostgreSQL databases yourself, you would need a [https://heliohost.org/vps/ VPS]. We offer a range of VPS plans, and a 10% discount when you pay for 6 months upfront.

			== Remote Access Transfers with Account Moves ==

			Once remote access to your PostgreSQL database has been set up for you by an admin, if you [[:Moving_Your_Account \| move your account]] to another server, your remote access will be transferred to the new server. Please note that depending on your setup, you may need to adjust your code or configuration to reflect the new server name or IP address.

KazVee: Fix code sections to restore single "=" where they should be

2025-01-22T06:19:03Z

Fix code sections to restore single "=" where they should be

← Older revision		Revision as of 06:19, 22 January 2025
Line 11:		Line 11:
	== How to Request Remote Access to PostgreSQL ==		== How to Request Remote Access to PostgreSQL ==

	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 'pg_hba.conf' file myself? ==		== Can I edit the PostgreSQL 'pg_hba.conf' file myself? ==

KazVee: Fix headers & mention 10% discount on 6-month upfront VPS payment

2025-01-17T16:27:02Z

Fix headers & mention 10% discount on 6-month upfront VPS payment

KazVee at 03:29, 1 November 2024

2024-11-01T03:29:50Z

← Older revision		Revision as of 03:29, 1 November 2024
Line 1:		Line 1:
	= PostgreSQL Database Remote Connection Error =		= PostgreSQL Database Remote Connection Error =

	= Error: `no pg_hba.conf entry for host` =		= 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.		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 `pg_hba.conf` file myself? =		= 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 `Allow remote connections` options under MariaDB's `Access control` settings.		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].

KazVee: 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..."

2024-10-17T15:41:56Z

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..."

New page

= 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 [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 `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 [https://heliohost.org/vps/ VPS plans].

← Older revision		Revision as of 16:27, 17 January 2025
Line 1:		Line 1:
	= PostgreSQL Database Remote Connection Error =		== PostgreSQL Database Remote Connection Error ==

	= Error: 'no pg_hba.conf entry for host' =		== 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.		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 ==

	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.		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 =		== How to Request Remote Access to PostgreSQL ==

	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 'pg_hba.conf' file myself? =		== 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.

	= Can I enable remote access to PostgreSQL myself? =		== 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.		No. Plesk, like most control panels, has extremely limited support for PostgreSQL, and you can't enable remote access yourself.
Line 23:		Line 23:
	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 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 a [https://heliohost.org/vps/ VPS]. We offer a range of VPS plans, and a 10% discount when you pay for 6 months upfront.