immudb
immudb copied to clipboard
postgresql connot be connected
I am trying to connect postgresql port 5432 using pgAdmin/DBeaver but not connected I got this error in pgAdmin
**'ServerManager' object has no attribute 'user_info'**
The server is running successfully with default values
immudb-v1.2.2-windows-amd64.exe
_ _ _
(_) | | |
_ _ __ ___ _ __ ___ _ _ __| | |__
| | '_ ` _ \| '_ ` _ \| | | |/ _` | '_ \
| | | | | | | | | | | | |_| | (_| | |_) |
|_|_| |_| |_|_| |_| |_|\__,_|\__,_|_.__/
immudb 1.2.2
Commit : 89c3e3e8a4293909421d23025d7a26bb04b35a5e
Built by: [email protected]
Built at: Tue, 18 Jan 2022 17:27:58 +03
================ Config ================
Data dir : ./data
Address : 0.0.0.0:3322
Metrics address : 0.0.0.0:9497/metrics
Config file : configs/immudb.toml
Max recv msg size: 33554432
Auth enabled : true
Dev mode : false
Default database : defaultdb
Maintenance mode : false
Synced mode : true
----------------------------------------
Superadmin default credentials
Username : immudb
Password : immudb
========================================
immudb 2022/03/21 11:22:44 INFO: Opening database 'systemdb' {replica = false}...
immudb 2022/03/21 11:22:44 INFO: Reading snapshot at 'data\systemdb\index\commit'...
immudb 2022/03/21 11:22:44 INFO: Successfully read snapshot at 'data\systemdb\index\commit'
immudb 2022/03/21 11:22:44 INFO: Indexing in progress at 'data\systemdb'
immudb 2022/03/21 11:22:44 INFO: Binary Linking up to date at 'data\systemdb'
immudb 2022/03/21 11:22:44 INFO: Database 'systemdb' {replica = false} successfully opened
immudb 2022/03/21 11:22:44 INFO: Loading SQL Engine for database 'systemdb' {replica = false}...
immudb 2022/03/21 11:22:44 INFO: Opening database 'defaultdb' {replica = false}...
immudb 2022/03/21 11:22:44 INFO: Flushing index 'data\systemdb\index'...
immudb 2022/03/21 11:22:44 INFO: Flushing not needed at 'data\systemdb\index'
immudb 2022/03/21 11:22:44 INFO: SQL Engine ready for database 'systemdb' {replica = false}
immudb 2022/03/21 11:22:44 INFO: Reading snapshot at 'data\defaultdb\index\commit'...
immudb 2022/03/21 11:22:44 INFO: Successfully read snapshot at 'data\defaultdb\index\commit'
immudb 2022/03/21 11:22:44 INFO: Indexing in progress at 'data\defaultdb'
immudb 2022/03/21 11:22:44 INFO: Binary Linking up to date at 'data\defaultdb'
immudb 2022/03/21 11:22:44 INFO: Database 'defaultdb' {replica = false} successfully opened
immudb 2022/03/21 11:22:44 INFO: Loading SQL Engine for database 'defaultdb' {replica = false}...
immudb 2022/03/21 11:22:44 INFO: Flushing index 'data\defaultdb\index'...
immudb 2022/03/21 11:22:44 INFO: Flushing not needed at 'data\defaultdb\index'
immudb 2022/03/21 11:22:44 INFO: pgsl server is running at port 5432
immudb 2022/03/21 11:22:44 INFO: SQL Engine ready for database 'defaultdb' {replica = false}
immudb 2022/03/21 11:22:44 INFO: Webconsole enabled: 0.0.0.0:8080
immudb 2022/03/21 11:22:44 INFO: Web API server enabled on 0.0.0.0:8080/api (http)
You can now use immuadmin and immuclient CLIs to login with the immudb superadmin user and start using immudb.
note the psql from CLI is connecting succesfully
could you help me to get success connection from pgAdmin or DBeaver
Hi @amrosdevops, at the moment connection over pgsql wire protocol is limited to queries that are not involving catalog or internal data (like user_info in your case). More work is needed here in order to expose catalog and increase immudb integration capability with third party software