{"id":1220,"date":"2021-12-16T12:14:56","date_gmt":"2021-12-16T09:14:56","guid":{"rendered":"https:\/\/files2.tojikon.net\/files-cloud\/2021\/10\/30\/how-to-set-up-a-postgresql-database-server-with-webmin-on-ubuntu-server\/https:\/\/files2.tojikon.net\/files-cloud\/2021\/10\/30\/how-to-set-up-a-postgresql-database-server-with-webmin-on-ubuntu-server\/"},"modified":"2021-12-16T12:14:56","modified_gmt":"2021-12-16T09:14:56","slug":"how-to-set-up-a-postgresql-database-server-with-webmin-on-ubuntu-server","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1220-how-to-set-up-a-postgresql-database-server-with-webmin-on-ubuntu-server\/","title":{"rendered":"How to set up a PostgreSQL database server with Webmin on Ubuntu Server"},"content":{"rendered":"
\n
\n

Related Articles<\/h3>\n<\/div>\n<\/section>\n

PostgreSQL is a lightweight, advanced databasing tool for Linux and other platforms. It is well supported on Ubuntu, but setting one up and managing it through the terminal can be pretty annoying.<\/p>\n

There\u2019s a better way you can set up a PostgreSQL database server on Ubuntu. How? With Webmin, the modern admin interface for Unix systems. Here\u2019s how to use Webmin to create a PostgreSQL database on your Ubuntu system.<\/p>\n

\"\"<\/p>\n

Getting Webmin installed on Ubuntu Server<\/h2>\n

If you\u2019re interested in using the PostgreSQL module on Webmin, you will need to set up Webmin on your Ubuntu Server. To get the app working, you\u2019ll need to install a DEB package from the Webmin website.<\/p>\n

To start the installation of Webmin, open up a terminal window and access the server over SSH. Or use the TTY console on the server by physically sitting at it. Once you\u2019ve gained command-line access, use the commands below to get the latest release of Webmin working on your Ubuntu Server machine.<\/p>\n

\nhttp:\/\/prdownloads.sourceforge.net\/webadmin\/webmin_1.981_all.deb\n<\/pre>\n
\nsudo apt install .\/webmin_1.981_all.deb\n<\/pre>\n
This section should be more than enough to help you get Webmin up and running on your Ubuntu Server setup. That being said, if you need more guidance in how to set up the tool, please follow our guide on how to set up Webmin on Ubuntu Server.<\/p>\n
Setting your root password<\/h2>\n
The Webmin web UI uses the user\u2019s root account and root password to log in. However, you won\u2019t be able to log in out of the box on Ubuntu Server, as the Ubuntu system locks the root account by default.<\/p>\n
if you wish to set up the root password on your Ubuntu Server system, start by gaining a root shell using sudo -s<\/strong>.<\/p>\n
\"\"<\/p>\n
\nsudo -s\n<\/pre>\n
Now that you have a root shell, you\u2019ll be able to set the root password for Ubuntu Server. Using the passwd<\/strong> command, tell Ubuntu you are giving the root account a new password. Make sure that the root password is memorable and secure.<\/p>\n
Note: if you need help generating a password, try out the StrongPasswordGenerator.<\/p>\n
\npasswd\n<\/pre>\n
With the root password correctly configured on Ubuntu, you can now access the Webmin web UI. Open up your favorite web browser, enter \u201croot\u201d into the username box, and the root password in the \u201cpassword\u201d box.<\/p>\n
\nhttp:\/\/YOUR_UBUNTU_SERVER_IP_ADDRESS_OR_HOSTNAME:10000\n<\/pre>\n
Installing the PostgreSQL packages through Webmin<\/h2>\n
PostgreSQL packages must be installed on Ubuntu Server before the PostgreSQL Webmin module is accessible. To install the package on your Ubuntu Server, follow the step-by-step instructions below.<\/p>\n
Step 1:<\/strong> Access the Webmin web UI interface. Then, click on the menu button in the left-hand sidebar.<\/p>\n
Step 2:<\/strong> Once inside of the sidebar, find the \u201cUn-used Modules\u201d section, and click on the down arrow icon to reveal its menu items.<\/p>\n
Step 3:<\/strong> Find \u201cPostgreSQL Database Server\u201d in the \u201cUn-used Modules\u201d section and click on it with the mouse. Selecting this will show you the PostgreSQL module section in Webmin.<\/p>\n
Step 4:<\/strong> Find the green \u201cInstall Now\u201d button inside of Webmin, and click on it with the mouse to tell Webmin you wish to install the PostgreSQL packages to Ubuntu.<\/p>\n
\"\"<\/p>\n
Step 5:<\/strong> After selecting the green \u201cInstall Now\u201d button, a blue \u201cInstall Button\u201d will appear. Select it to confirm you wish to install the PostgreSQL packages to your Ubuntu system with Webmin.<\/p>\n
\"\"<\/p>\n
Step 6:<\/strong> Find the \u201cRefresh Modules\u201d button at the bottom of the Webmin sidebar and click on it to refresh modules.<\/p>\n
Configuring your PostgreSQL Database in Webmin<\/h2>\n
The default settings for PostgreSQL in Webmin should suffice for most beginners. That being said, if you\u2019re not new to PostgreSQL and want to configure your database settings, here\u2019s how you can.<\/p>\n
Step 1:<\/strong> Find the Webmin sidebar on the left and click on it with the mouse. You\u2019ll then load up the PostgreSQL Database Server configuration area.<\/p>\n
Step 2:<\/strong> Find the gear icon at the top-left corner of the page, and click on it to access the PostgreSQL module settings.<\/p>\n
Step 3:<\/strong> After configuring the module settings, make your way to \u201cUser, Groups, and Permissions\u201d to change settings related to the PostgreSQL Database Server.<\/p>\n
Creating a new database in Webmin<\/h2>\n
Do the following if you wish to create a new PostgreSQL database in Webmin on your Ubuntu Server.<\/p>\n
Step 1:<\/strong> Access the PostgreSQL Database area in Webmin by selecting it under \u201cServer\u201d in the Webmin sidebar.<\/p>\n
Step 2:<\/strong> Find the \u201cCreate a new database\u201d button in the PostgreSQL Webmin area, and click on it with the mouse.<\/p>\n
\"\"<\/p>\n
Step 3:<\/strong> In the \u201cDatabase name\u201d box, enter your PostgreSQL database name. Then, set your custom settings, and click on the green \u201cCreate\u201d button to create the new database.<\/p>\n","protected":false},"excerpt":{"rendered":"
Related Articles PostgreSQL is a lightweight, advanced databasing tool for Linux and other platforms. It is well supported on Ubuntu, but setting one up and managing it through the terminal can be pretty annoying. There\u2019s a better way you can set up a PostgreSQL database server on Ubuntu. How? With Webmin, the modern admin interface …<\/p>\n","protected":false},"author":1,"featured_media":1221,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21],"tags":[33],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1220"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1220"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1220\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1221"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}