![]() We strongly recommend encrypting the password using the command rstudio-server encrypt-password. A warning will be present in Posit Workbench log output when a plain-text password is being used. PostgreSQL password encryptionĪ plain-text password in the password or connection-uri options of the /etc/rstudio/nf file must only be used temporarily for testing purposes. Always ensure that whichever account that is used to access the database contains a strong password - do not use an account that has no password! You should also ensure that only one PostgreSQL user has access to the Posit Workbench database for maximum security. This is to ensure that your database is secure. When setting up your PostgreSQL database for use with Posit Workbench, ensure that you do not use the default postgres user account that comes with a standard installation. The schema must be owned by the connecting user or by a group that contains the connecting user. Provider = postgresql connection-uri = Workbench will refuse to start when given a schema that does not already exist. If specifying additional options other than the ones provided above, such as sslmode, the use of a URI is required. PostgreSQL connection URIs are also supported if preferred. Corresponds to the # PostgreSQL "connect_timeout=" connection string parameter. The default if not specified is 10 seconds. # It is strongly recommended that you encrypt the password! password = test # Specifies the maximum amount of seconds allowed before a database connection attempt # is considered failed. # The encrypted password can be generated using the helper command rstudio-server encrypt-password. This may be encrypted with the secure-cookie-key. ![]() ![]() # Note: when connecting to a PostgreSQL database, a default empty rstudio database must first be created! provider = postgresql # Specifies the host (hostname or IP address) of the database host host = localhost # Specifies the database to connect to database = rstudio # Specifies the TCP port where the database is listening for connections port = 5432 # Specifies the database connection username username = rstudio # Specifies the database connection password. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |