Hi,
I have been unable to connect to the PostgreSQL database with the tryton
client.
When creating the profile, it always says "Database: Could not connect to
server"
Using tryton/trytond 4.2.0
This is what I have done:
started postgresql-9.5
psql -U postgres
CREATE USER al WITH PASSWORD 'a';
CREATE DATABASE aldb WITH OWNER al;
#GRANT ALL PRIVILEGES ON DATABASE aldb to al;
\q
output for psql -U postgres -c "list"
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-----------+----------+----------+------------+------------+-----------------------
aldb | al | UTF8 | en_CA.utf8 | en_CA.utf8 |
postgres | postgres | UTF8 | en_CA.utf8 | en_CA.utf8 |
template0 | postgres | UTF8 | en_CA.utf8 | en_CA.utf8 | =c/postgres
+
| | | | |
postgres=CTc/postgres
template1 | postgres | UTF8 | en_CA.utf8 | en_CA.utf8 | =c/postgres
+
| | | | |
postgres=CTc/postgres
(4 rows)
tryton-admin -c /etc/tryton/trytond.conf -d aldb --all
where /etc/tryton/trytond.conf is:
[database]
uri = postgresql://al:a@localhost/
path = /var/lib/trytond
After I create the database, I open the client. I have tried various
hostnames, with and without ports, and various attempts for the uri in the
.conf file without luck.
I would appreciate any help! I have been at this for a while.
Thanks,
Allan
--
You received this message because you are subscribed to the Google Groups
"tryton" group.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tryton/d96fc001-cd3d-4f6b-8f46-dcdb994fd238%40googlegroups.com.
