atarantino75 Posted October 22, 2023 Posted October 22, 2023 Buongiorno, mi sono appena registrato sul Vs servizio Hosting. L'intento è creare e gestire un database PostgreSql. Purtroppo l'accesso remoto non è abilitato. potete aiutarmi? banca dati: atarantino75_daniashop Grazie
wolstech Posted October 22, 2023 Posted October 22, 2023 Quote Good morning, I just registered on your hosting service. The intent is to create and manage a PostgreSql database. Unfortunately remote access is not enabled. can you help me? Escalating to have this enabled.
Krydos Posted October 22, 2023 Posted October 22, 2023 What is the username that you want to have remote access?
atarantino75 Posted October 25, 2023 Author Posted October 25, 2023 (edited) In realtà non riesco ancora ad accedere da remoto. utente: atarantino75_inf75 database : atarantino75_daniashop Potete controllare Grazie https://translate.google.com/?sl=auto&tl=en&text=In realtà non riesco ancora ad accedere da remoto. utente%3A atarantino75_inf75 database %3A atarantino75_daniashop Potete controllare Grazie&op=translate Quote I actually still can't log in remotely. user: atarantino75_inf75 database: atarantino75_daniashop You can check Thanks Edited October 25, 2023 by Krydos Added Translation
Krydos Posted October 25, 2023 Posted October 25, 2023 Maybe I forgot to restart PostgreSQL. Can you login now?
atarantino75 Posted October 26, 2023 Author Posted October 26, 2023 (edited) Scusate ma continua a non essere accessibile da remoto. nome banca dati: atarantino75_daniashop nome utente da abilitare : atarantino75_inf75 Potete controllare grazie https://translate.google.com/?sl=auto&tl=en&text=Scusate ma continua a non essere accessibile da remoto. nome banca dati%3A atarantino75_daniashop nome utente da abilitare %3A atarantino75_inf75 Potete controllare grazie&op=translate Quote Sorry but it's still not accessible remotely. database name: atarantino75_daniashop username to enable: atarantino75_inf75 You can check thanks Edited October 27, 2023 by Krydos Translated to English
wolstech Posted October 26, 2023 Posted October 26, 2023 I'll have Krydos check this one more time, but it's possible if not likely that this issue is on your end. Some networks (notably schools and workplaces) block the ports required for postgres remote access to function. If you cannot get this to work and Krydos doesn't find anything wrong, you will need to upload a script like adminer and use that to work on your database instead.
Krydos Posted October 27, 2023 Posted October 27, 2023 I changed the password of your atarantino75_inf75 user to test it for you. I can assure you it is working. $ psql --host=65.19.141.77 --dbname=atarantino75_daniashop --user=atarantino75_inf75 Password for user atarantino75_inf75: psql (14.9, server 13.12) SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off) Type "help" for help. atarantino75_daniashop=> \dt Did not find any relations. atarantino75_daniashop=> You can change the password of the atarantino75_inf75 user back to what it was now, but remote connections are definitely enabled.
Recommended Posts