Page 1 of 1

Connect button to Postgresql disappeared in DR17?

PostPosted: Wed Mar 24, 2021 3:55 pm
by canimo
Hi,
I have just upgraded to resolve 17 (studio) and I am not able to connect to my shared postgresql db on my Synology Nas anymore. (its status is "disconnected")

I have noticed that in the project management window now there is only the "create" button and the "connect" one is gone.
Is the procedure changed in DR 17?

- If I try to connect using the "create" button (New database -> Create), with the right credential of the already existing db, I got an "unable to connect" message.
Code: Select all
Failed to connect to the database server as the
connection was refused. Please ensure that the database
server is configured to allow connections from this device.



- If I try to actually create a new one, I get this error
Code: Select all
Failed to create database: ERROR: new encoding (UTF8)
is incompatible with the encoding of the template
database (SQL_ASCII) HINT: Use the same encoding
as in the template database, or use template0 as
template. (22023) QPSQL: Unable to create query.


Some more info:
- my shared db access is hosted on my Synology Nas
- I cann correctly access the shared db using PGadmin III

How can I fix it? Thank you. Carlo

Re: Connect button to Postgresql disappeared in DR17?

PostPosted: Wed Mar 24, 2021 4:58 pm
by Jim Simon
The Connect button moved to the top along with the Backup icons.

Re: Connect button to Postgresql disappeared in DR17?

PostPosted: Wed Mar 24, 2021 5:00 pm
by Glenn Sakatch
Ya, this caught me too....i love it when they move buttons around.

Re: Connect button to Postgresql disappeared in DR17?

PostPosted: Wed Mar 24, 2021 7:27 pm
by canimo
Thank you guys, it worked!

I usually hesitate to ask for help here since I want to be sure I am not taking others' time with no reason.

I cannot believe how many hours I did spend trying fixing it before asking :roll:

Thank you again ;)