Translations:Database servers/36/en: Difference between revisions

Translations:Database servers/36/en (view source)

578 bytes removed , 6 years ago

Importing a new version from external source

38,897

edits

@@ Line 1: / Line 1: @@
-Your created PostgreSQL account will have the same username as your Compute Canada username. You will be given a database. The name of the database will typically be "db_<username>" where <username> is your Compute Canada username. Users are not able to create databases. If you need more databases please send us a request at support@computecanada.ca . PostgreSQL uses IDENT authentication for connection from cedar compute nodes which means no  password is needed to be supplied to your PostgreSQL account. For security reasons your Compute Canada password is to NEVER be required or used in a script. This also means that user A from a cedar compute node cannot make a PostgreSQL connection to user B.
+The PostgreSQL account we create for you will have the same username as your Compute Canada username. You will be given a database. The name of the database will typically be "db_<username>" where <username> is your Compute Canada username. You cannot create a database yourself. If you need more than one database, please send us a request at support@computecanada.ca.
-When access is from the head node, however, PostgreSQL uses PAM authentication which means that you will be prompted
-for a password. Your password for PostgreSQL connection is the same as your Compute Canada password for this case. Example: