so it’s not the most secure version at this moment (no ssl tunnel, no md5 passwords), but the basic settings required for a client on another machine to connect to our basic ubuntu postbooks server are as follows
edit the file /opt/xTuple/postgres/data/pg_hba.conf
in the IPv4 section add a new line below rgw localhost directive
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.xxx.xxx/24 md5
edit the file /opt/xTuple/postrges/data/postgresql.conf
set the listen address (line 59) to *
listen_addresses = ‘*’ # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to ‘localhost’, ‘*’ = all
double check ports and other settings while you are in the files
restart the server
/opt/xTuple/postgres/bin/pg_ctl stop
/opt/xTuple/postgres/bin/pg_ctl start