[HH#785822] Postgresql DB Need to access via DB-Visualizer and need Stored Procedure Support

[HelioHost]

Username: jimkosloskey, Server: Tommy, Main domain: jim-kosloskey.com.helioho.st

Hello,



I have just registered a new account (jimkosloskey) for a Postgresql DB
(Tommy).



I have a very small project to evaluate the use of Stored Procedure in a
Postgresql DB. To do this I would like to use DB-Visualizer from my desktop
and have the ability to create and call Stored Procedures.



I understand I need to request both of those features.



I hereby submit that request.



I am new to this, so if there is more I need to do, or you need to know, let
me know. Just understand I am probably totally ignorant of any acronyms you
might use.



Thanks,



Jim Kosloskey

[Krydos]

Remote access enabled.

host=65.19.154.94
port=5432
username=jimkosloskey_novice
dbname=jimkosloskey_test_mule
password=<set in Plesk>
 

[HelioHost]

Thank you - I successfully connected via DB-Visualizer. Do I need permission
setting to create my test DB? I am getting a permissions error when I try.



Thanks,



Jim Kosloskey

[Krydos]

Are you creating your database through Plesk?

[HelioHost]

No, DB-Visualizer.

[HelioHost]

Do I need permissions to create a schema in my DB? Using DB-Visualizer for
that and me as Authorization.



Thanks



From: jim.kosloskey@jim-kosloskey.com
Sent: Sunday, August 4, 2024 6:55 PM
To: 'HelioHost Support'
Subject: RE: [HH#785822] Postgresql DB Need to access via DB-Visualizer and
need Stored Procedure Support



No, DB-Visualizer.

[Krydos]

You have to create the database through Plesk. You can't create databases through DB-Visualizer because it will only have access to the one database that you requested remote access for.

[HelioHost]

Ok I deleted my original DB in case I used DB-Visualizer and built another
one same name different user. Now I cannot connect using that DB Name
(jimkosloskey_test_mule) and user name (jimkosloskey_whosis). Do I need new
connection information (beyond the new user name and associated password)?



Thanks,



Jim Kosloskey

[Krydos]

Remote access enabled for the new user you created.

host=65.19.154.94
port=5432
username=jimkosloskey_whosis
dbname=jimkosloskey_test_mule
password=<set in Plesk>
 

[HelioHost]

I am trying to create a new schema and am getting permission errors:

[Krydos]

What is the error?

[HelioHost]

I included a screen shot of the error I am getting. Here it is again:

[wolstech]

The support email does not accept attachments or pictures. Please type the error out, or upload the picture somewhere and include a URL instead.

[HelioHost]

Sorry, I did not know.



0 [Code: 0, SQL State: 42501] ERROR: permission denied for
database jimkosloskey_test_mule create schema month_nm_2_no
authorization jimkosloskey_whosis



Jim

[Krydos]

Try creating the schema now.