Топ-100
 
CerebroSQL

PostgreSQL Database Connection Wizard

The connection wizard allows you to set up a sheet connection to the database and save it for later use

Connection Wizard
Connect manager for PostgreSQL.jpg
Calling the database connection wizard
  • click the "Show connection manager" button in the "Connection control" block

  • keyboard shortcut Alt+F2 

Previously saved connections are displayed in the "Connection list"

Block "Filter"
  • Drop-down list - allows you to display only a specific group of connections in the tree

  • Button "Load list group" - display the list of groups in the tree "Connection list"

  • "Search" button - show connection search window

Create a new connection
  • "Vendor library (libpg.dll)" - full path to the client library for working with PostgreSQL . The default library is ".\DLL\PG\libpg.dll"

  • "Alias*" - unique identifier, displayed in the list of saved connections

  • "Group name" - the name of the group in the list. 

  • "Server*" - DNS name of the server or its IP address

  • "Port" is the port of the server on which the PostgreSQL listener is running . The default port is 5432.

  • "Database" - the name of the database to connect to. Default: postgres

  • "Login*" - username. 

  • "Password*" is the password.

  • "Charset" - encoding, by default WIN1251. Supported encodings in  12 versions 

  • "Advanced"  - additional options

 

Control buttons
  • "Test connect" - test the connection to the PostgreSQL database using the entered parameters

  • "Connect" - connect to the database using the entered parameters

  • "Save" - save the connection

  • "Delete connect" - delete a previously saved connection (the connection selected in the "Connection list" is deleted)

 

After connecting to the DBMS, the change of the current database is performed, among other things, through the drop-down list "Current database".

To disconnect from the database all connections of the current sheet, click on the button "Disconnect current list"