Connection to PostgreSQL (IDE)
You can easily connect to Alfresco database using database IDE, pgAdmin for example. But I prefer to use Intellij’s 0xdbe. All necessary information you can find in alfresco-global.properties file (host, port, login and password).
Connection to PostgreSQL (SSH)
First you need to stop Alfresco and start PostgreSQL server:
After you can start interactive terminal by running:
Password could be found in alfresco-global.properties
file.
Now you are able to select from alfresco tables:
Connection to H2 (for IntelliJ IDEA)
For IDEA it’s quite easy to connect to H2 database. Search for alf-dev.h2
file and just drag-and-drop to database tab:
And you can open the console (Ctrl+Shift+F10 or right click on the database and select Console)