wbspot.blogg.se

1. #POSTGRESQL CREATE DATABASE IN SPECIFIC LOCATION DRIVER#
2. #POSTGRESQL CREATE DATABASE IN SPECIFIC LOCATION CODE#
3. #POSTGRESQL CREATE DATABASE IN SPECIFIC LOCATION PASSWORD#

CREATE DATABASE alfresco OWNER alfresco ENCODING 'utf8'

#POSTGRESQL CREATE DATABASE IN SPECIFIC LOCATION PASSWORD#

For more information about PostgreSQL performance, see Tuning PostgreSQL.Ĭreate a Postgres user with the username given by the sync property, sql.db.username, with password given by the sync property sql.db.password: CREATE USER alfresco WITH PASSWORD 'admin' Ĭreate a Postgres database with the name given in the property, sql.db.url, owned by the user alfresco that you will use to run PostgreSQL, and ensure that this user has write permissions on all tables and sequences. Increasing the work_mem value increases performance and allows PostgreSQL to perform larger in-memory sorting. Review your memory requirements in work_mem in the nf file in your PostgreSQL directory. If there are multiple Sync Service instances forming a cluster hidden behind a load balancer, max_connections should be greater than or equal to the sum of all db.pool.max from all config.yml files.įor example, if max_connections=450, and there are 3 Sync Service instances, then the correct setting in config.yml is db.pool.max : 150. So, the value of the db.pool.max property in the config.yml file must be less than or equal to 100. If max_connections is left unchanged, bear in mind that in the PostgreSQL database, the default max_connections is 100.

#POSTGRESQL CREATE DATABASE IN SPECIFIC LOCATION DRIVER#

See step Starting the Sync Service.ĭownload the appropriate driver that’s compatible with JDBC42 from the PostgreSQL JDBC Driver download page.Ĭopy the JAR file into the same directory as the Sync Service JAR.

The Sync Service isn’t packaged with a PostgreSQL driver, so it’ll need to be downloaded separately and cited in the start-up. The repository doesn’t communicate with the database. It persists events taken from the JMS queue into the database. Note: Only the Sync Service communicates with the database. Run the command psql -version to confirm your PostgreSQL version.Alfresco recommends that you use a separate PostgreSQL instance for the Sync Service. Your version might be 9.5, 11 or 12 or any other version. Take note that 10 is the version of my PostgreSQL installation on my server. However, the PostgreSQL configuration directory in Ubuntu is located in /etc/postgresql/10/main. You can now locate the Postgres Database files by navigating the directory that was displayed. This should display an output similar to this: data_directory If you are successfully logged in, you will see a prompt similar to this: psql (11.5 (Ubuntu 11.5-3.pgdg18.04+1), server 10.10 (Ubuntu 10.10-1.pgdg18.04+1))Īt this point you will execute the query below to display the directory where Postgres Database files are stored on your Linux macchine: SHOW data_directory It will also request for the postgres password which you set up when you were setting up PostgreSQL on your machine.

#POSTGRESQL CREATE DATABASE IN SPECIFIC LOCATION CODE#

This can be accomplished by running the code below: psql Next, you will need to login into the psql terminal/prompt. It will request for the postgres user password which you set up when you were setting up PostgreSQL on your machine. Run the command below in your terminal to switch user to postgres user: su - postgres Here's how I located the directory of my Postgres database files in Ubuntu: