36.3. Creating a New Database

When PostgreSQL is first installed, a database called template1 is usually created. Because this is used as the template for any new databases, you should create your own to contain tables in which your application can store data. To do this, follow these steps:

1.
On the module's main page, click on the Create a new database link above or below the table of existing database icons.
2.
Enter a unique name for it into the Database name field. This should consist only of letters, numbers, and the _ character.
3.
When the Database file path field is set to Default, the files that actually contain the database's data will be created in the default directory. On Linux systems, this will usually be something like /var/lib/pgsql/data ...

Get Managing Linux® Systems with Webmin™ System Administration and Module Development now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.