Template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgresĬlient Authentication is how PostgreSQL decides which user accounts can connect to which databases from which hosts. Template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres Postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | Moodle | moodleuser | UTF8 | cs_CZ.utf8 | cs_CZ.utf8 | Name | Owner | Encoding | Collation | Ctype | Access privileges To make sure the database was created correctly, use the \l at the psql console or execute psql -l shell command. Postgres=# CREATE DATABASE moodle WITH OWNER moodleuser ENCODING 'UTF8' LC_COLLATE='cs_CZ.utf8' LC_CTYPE='cs_CZ.utf8' TEMPLATE=template0 įor more details refer to Character Set Support chapter in PostgreSQL manual. The following example creates new database called 'moodle' optimised for a Czech Moodle site: If the PostgreSQL server's default collation does not suit your needs, you can provide explicit LC_CTYPE (character classification) and LC_COLLATE (string sort order) setting for your Moodle database. Postgres=# CREATE DATABASE moodle WITH OWNER moodleuser See the 'Client Authentication' section below for further details. Some authentication methods (like ident) do not require the password. Please note that the actual authentication method depends on your PostgreSQL server's pg_hba.conf file. Postgres=# CREATE USER moodleuser WITH PASSWORD 'yourpassword' Create the user for the Moodle database and assign a password:.After some preamble you should see the prompt postgres=#. The exact form depends on how your PostgreSQL is configured but will be something likeĮnter the password for your 'postgres' user set during installation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |