Code SonarQube 2019(2)PostgreSQL as Database
Create database user sonar
> createuser -P -s -e sonar
Create database
> createdb -Osonar -Eutf-8 sonar
Connect to the database
> psql -U sonar -d sonar -h localhost -p 5432
List the database
> \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------
demo | carl | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | carl | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
sonar | sonar | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
Adjust the configuration for SonarQube
> vi conf/sonar.properties
sonar.web.port=9000
sonar.web.host=0.0.0.0
sonar.jdbc.url=jdbc:postgresql://localhost/sonar
sonar.jdbc.username=sonar
sonar.jdbc.password=sonar
Start the service, it works pretty good
> bin/linux-x86-64/sonar.sh start
References:
https://www.jianshu.com/p/6179927319e8
分享到:
相关推荐
postgresql-database_rev6.json
postgresql sample database 示例数据库
2019PostgreSQL大会可分享嘉宾PPT, 都是一些业界大神, 公开资料收集, 2019年大会在北京举行的
postgresql database 官方原版
More importantly, the book pays special attention to topics such as monitoring roles, backup, and recovery of your PostgreSQL 10 database, ensuring high availability, concurrency, and replication. ...
postgresql database version 11 win 64 zip
Beginning PostgreSQL on the Cloud Simplifying Database as a Service on Cloud Platforms 英文无水印原版pdf pdf所有页面使用FoxitReader、PDF-XChangeViewer、SumatraPDF和Firefox测试都可以打开 本资源转载...
PostgreSQL(postgresql-13.5.tar.bz2) PostgreSQL是一种特性非常齐全的自由软件的对象-关系型数据库管理系统(ORDBMS),是以加州大学计算机系开发的POSTGRES,4.2版本为基础的对象关系型数据库管理系统。...
Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql 10.20.2 Windows 64位安装包Postgresql ...
详细描述了DB2与GreenPlum/PostgreSQL在各方面的差异,主要用于DB2数据库向GreenPlum/PostgreSQL数据库的迁移。
mysql2postgresql, 转换mysql模式到 PostgreSQL mysql2postgresql转换mysql模式和数据到 PostgreSQL用法使用命令在xml格式中创建转储: mysqldump --xml -u USER_NAME DB_NAME> DUMP_FILE_NAME
基于JSP的电话号码管理系统,使用了tomcat和postgresql 数据库,作为内部号码管理系统使用。
PostgreSQL(postgresql-14.2-2-windows-x64.exe),适用于Windows系统:PostgreSQL是一种特性非常齐全的自由软件的对象-关系型数据库管理系统(ORDBMS),是以加州大学计算机系开发的POSTGRES,4.2版本为基础的对象...
PostgreSQL is an open source relational database management system that began as a research project at the University of California, Berkeley. It was originally released under the BSD license but now ...
EMS PostgreSQL Manager is a powerful tool for PostgreSQL® Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the ...
PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by ...
Simon Riggs is one of the few Major Developers and Committers on the PostgreSQL database project, and is also CTO of 2ndQuadrant, providing 24x7 support and services to PostgreSQL users worldwide....
PostgreSQL(postgresql-14.2-2-osx.dmg),适用于macOS系统:PostgreSQL是一种特性非常齐全的自由软件的对象-关系型数据库管理系统(ORDBMS),是以加州大学计算机系开发的POSTGRES,4.2版本为基础的对象关系型...
Building a Spatial Database in PostgreSQL: David Blasby Refractions Research PostGIS aims to be an “OpenGIS Simple Features for SQL” compliant spatial database; Adding spatial extensions to ...