<div dir="ltr"><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">Salve,</span><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">sto cercando di effettuare una connessione ad un DB Postgres/Postgis su server debian11/apache2/postgres14 da QGIS tramite Servizio.</span><br></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px"><br></span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">Nel server ho creato con l'editor nano il file di configurazione pg_service.conf in /etc/postgresql-common/.</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px"><br></span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">[prova]</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">host=[ho provato sia con localhost che con l'indirizzo ip del server]</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">port=5432</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">dbname=prova</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">user=prova</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">password=prova</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px"><br></span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">Dal server </span><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">riesco a connettermi con il comando psql service=prova.</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px"><br></span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">Dall'esterno, sia tramite qgis che tramite pgadmin4 ricevo l'errore "definition of service 'prova' not found".</span></div><div><span style="font-family:Roboto,RobotoDraft,Helvetica,Arial,sans-serif;font-size:14px">Sempre dall'esterno, inserendo nella scheda nuova connessione le credenziali riesco a connettermi sia da qgis che da pgadmin.</span></div><div><br></div><div>C'è qualcosa da impostare in apache2 o altro?</div><div><br></div><div>Grazie</div><div>Danilo</div></div>