pgAdmin 4 simplifies the administration and management of PostgreSQL servers with its user-friendly graphical interface and robust toolset. There is a help system (online and offline). PgAdmin is a free, open-source PostgreSQL database administration GUI for Microsoft Windows, Mac OS X, and Linux systems. More than 30 interface languages are available. In addition, in pgAdmin you will find a lot of important and useful tools, such as creating tables, a module to work with queries, analysis and compression of databases, changing the configuration of the server, determining access rights, and so on. Restore is performed using the Restore tool. In pgAdmin, the Backup tool in the Tools menu is used for this purpose. In order to secure your data, we recommend that you make regular backups. WE recommend to unselect 'pgAdmin 4' and 'Stack Builder' - As we will install these tools later. In the next step, select the component you wish to install. Choose the Installation directory - Ensure you have read/write permissions to the target directory. The main window of the utility is divided into three parts: the properties window (displays information about the selected object), SQL pane (shows the SQL operator with the help of which the selected object was created), object browser (in this browser you will see database and server objects, as well as connections to it). Next, launch the installer to start the installation process. With the help of pgAdmin it is very convenient to administer PostgreSQL servers, as well as to create databases (all the tools you need to do this are installed by default with the program). The pgAdmin program is one of the clients intended for PostgreSQL servers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |