1. Dan Bro
  2. Valentina Studio
  3. Saturday, October 23 2021, 02:37 PM
  4.  Subscribe via email
I have started to learn about SQL and installed Valentina Studio & PSQL on my Ubuntu.

I have defined a password via `sudo -u postgres psql postgres` and then `\password postgres`.

then I have entered `Valentina Studio` and connected to this server with 'discover localhost server` - it found the `PostgresSQL` and I entered the password that I set up before in the terminal and it looked ok and like it was connected.

I have created 4 empty new databases in the `VStudio` and tried to import to them some databases which are located on my desktop.

I got the `database does not exist` while it sure does as you can see in the screenshot.
When I tried to do the same with `template1` the skelton database of psql, it worked.

But why the Vstudio and the PSQL are not connected to each other?

Thanks.

https://i.stack.imgur.com/PwDDx.png
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
But it’s psql doesn’t connect to the database. I think the error message is different for permission problems
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Perhaps a permission problem if VStudio hasn't the read or write permission on the file ?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Sergey Pashkov Accepted Answer
Hello Dan,

Not sure (psql docs doesn't state it) but what if you create a database with a name in lower-case?
Will you be able to connect to it using psql?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories