1. Dan Bro
  2. Valentina Studio
  3. Суббота, Октябрь 23 2021, 02:37 PM
  4.  Подписаться через 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
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
But it’s psql doesn’t connect to the database. I think the error message is different for permission problems
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
Perhaps a permission problem if VStudio hasn't the read or write permission on the file ?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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?
Комментарий
There are no comments made yet.
  • Страница :
  • 1


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