Postgres.app

Chris Hughes ataddata at bigpond.net.au
Wed Aug 18 23:46:40 UTC 2021


Use the following:-

host	all				all				159.196.2.37/24				md5  This my static IP address. If your system uses the lease an IP address this stops the problem.
or
host	all				all				192.168.10.1/24				md5  This is if your computers has a static address.



-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Michael Houlberg
Sent: Thursday, 19 August 2021 8:21 AM
To: OmnisDev List - English
Subject: Re: Postgres.app

OK, I’ve made some real progress.  After years of primarily using MySQL, I’m giving PostgreSQL a look again.

I installed the Postgres.app again with PostgreSQL 13, but this time also installed pgAdmin4.  I’ve created the database, created a user/role, gave the user login capabilities, set privileges up for the database and so forth.  Logging on with a localhost connection is all good.

Now I want to connect from another computer on the LAN.

I went into postgresql.conf and editing this line:
listen_addresses = '*'		# what IP address(es) to listen on;

I went into pg_hba.conf and added this line:
host	all				all				0.0.0.0/0				md5

I restarted the server.

But the other machine still has this error:
“Client or interface function not available”

Any help appreciated,
Michael Houlberg
Houlberg Development, LLC

> On Aug 17, 2021, at 11:18 PM, Sten-Erik Björling <s-e.bjorling at enviro.se> wrote:
> 
> Hi,
> 
> In addition to the use of PG Admin and tools like DBeaver for DB admin I also recommend that you look into https://pgtune.leopard.in.ua helping you to optimise the settings in Postgres for increased performance. If that is needed…
> 
> To access the server from other devices you have to add an entry in the pg_hba.conf file:
> 
> host	all				all				0.0.0.0/0				md5
> 
> Take care, all the best…
> 
> Stene
> ______
> 
>> 17 aug. 2021 kl. 20:32 skrev Michael Houlberg <michael at houlbergdevelopment.com>:
>> 
>> $listers:
>> 
>> I’ve been looking at the Postgres app available at postgresapp.com which has some nice features.  Mainly it’s really easy to install, and when used with the Postico application, easy to administer.  My thinking is that I could specify this for users who are not too tech savvy and they could easily set themselves up.
>> 
>> But I have a couple of questions.
>> 
>> Can I set up roles and users?  It seems to ignore this completely.
>> 
>> Can I connect from another computer on the LAN?  It seems like it is intended as a single-user environment.
>> 
>> Has anyone got some experience with this?
>> 
>> Thanks,
>> Michael Houlberg
>> Houlberg Development, LLC
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list