WebFaction
Community site: login faq

Hi,

I'd like to create a database that can be accessed by users of my mobile app. Can I do this using webfaction databases? I haven't found how the way to remotely connect and manage postgresql db.

Thanks.

asked 29 Jan '16, 22:25

vkjr
112
accept rate: 0%


You don't have to do anything special to make a remote connection to a PostgreSQL database on your WebFaction server.

Just point your PostgreSQL client at your WebFaction server IP (or any host name that resolves to that IP), port 5432, and then connect to your database with the username and password for any database user you've created for that database.

permanent link

answered 30 Jan '16, 00:38

seanf
12.2k42136
accept rate: 37%

I'm getting "no pg_hba.conf entry for host..." error. Should I edit pg_hba.conf to allow connections? What should I put there? Thanks.

(30 Jan '16, 08:32) vkjr

You can not edit the pg_hba.conf on the shared Postgres server. We have redeployed the pg_hba.conf on your server. Please retry and if you still have an issue please open a support ticket.

(30 Jan '16, 12:20) aaront ♦♦

Yes, still have an issue.

(31 Jan '16, 10:33) vkjr

Please open a support ticket via https://help.webfaction.com/ so we can work directly with you to resolve the issue.

(31 Jan '16, 12:01) aaront ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×84
×4
×1

question asked: 29 Jan '16, 22:25

question was seen: 1,610 times

last updated: 31 Jan '16, 12:01

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2020 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM