Connecting to PostgreSQL Server

[edbo]

@ced

It is doable to make an install directly on Windows but it requires a good skill in Python on Windows. But once Python setup, normally it should be installable with pip.

In the world of scientists a Python distribution is used called Anaconda https://www.anaconda.com/ It comes with a lot of packages and boilerplate. It has it’s own package installer but can also use pip.

@jayd

I believe I understand correctly now that the tritond server would still be required on the windows machines if I were to connect to a remote linux postgresql server?

Nope that’s not needed, imagine you have several workstations to work in Tryton. You have to:

• setup a postgresql database on a server
• on that same server (for the sake of clarity) you install tryton-server (e.g. creating a Python virtual environment and than installing with pip the tryton-server with pip install trytond)
• you have to configure your tryton-server to be able to connect to the postgresql database with the connection string. And then run the tryton-server in administrator mode to initialize the database
• on your workstations you have to install the tryton-clients. Your tryton-clients connect to the tryton-server. You fill those parameters into the connection dialog when you start the tryton-client

@jayd

I noticed the distribution available in my package manager was older (3. something), and I assume that could cause problems if I wanted to restore a backup database built using the newer 5.0 windows client - would that indeed have potential issues?

You cannot mix major versions between tryton-server and tryton-clients. So you cannot connect with tryton-client 5.0.2 to a tryton-server 3.8.4. However you can connect with a tryton-client 5.0.2 to a tryton-server 5.0.9.

If needed I can write down the steps I take to install tryton-server into a Python virtual environment.