Next: Creating Tables and Roles, Previous: Creating a Database User, Up: PostgreSQL Setup [Contents][Index]
Create a database for use by the application:
$ sudo -u postgres createdb trip --owner=trip --locale=en_GB.UTF-8
If the default locale for the database does not match the running user’s
locale, e.g. en_GB.UTF-8
, specify the locale when creating it.
E.g.:
$ sudo -u postgres createdb trip --owner=trip --locale=en_GB.UTF-8 \ --template=template0
• Database User Permissions |