FATAL: could not open configuration file "/opt/PostgreSQL/8.4/data1/postgresql.

最新推荐文章于 2022-11-11 15:44:49 发布
原创 最新推荐文章于 2022-11-11 15:44:49 发布 · 591 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#数据库

本文深入探讨了在使用PostgreSQL时遇到的权限问题，特别关注了chown命令的应用及其解决方法。通过具体实例，展示了如何正确地为特定用户分配文件所有权，以确保数据库系统的安全性和稳定性。

权限问题：

chown postgres:postgres -R /opt/PostgreSQL/

 

PostgreSql报错 FATAL: data directory “/opt/huawei/install/data/db1“ has group or world access
qq_42548880的博客
08-02 1867
发生这个错误的一般原因是：虚拟机突然断电 然后再启PostgreSql 就起不来了 看报错： omm@node1 ~]$ gs_ctl start -D “/opt/huawei/install/data/db1/” [2021-08-02 10:11:24.764][6461][][gs_ctl]: gs_ctl started,datadir is -D “/opt/huawei/install/data/db1” [2021-08-02 10:11:24.869][6461][][gs_ctl]: w
主机突然关机 postgresql9.6 启动不起来，报解决办法(非正常停止) 无法创建锁文件 “/var/run/postgresql/.s.PGSQL.5432.lock“: 没有那个文件或目录
公众号Technology_stack作者，IT咨询请公众号私信
12-26 1778
一、问题描述 1.由于主机突然关机导致 Postgresql 非正常停止，lock文件丢失，二次启动找不到这个文件 二、解决办法 1.编辑 post配置文件 修改unix_socket_directories 默认指定路径 vim /var/lib/pgsql/9.6/data/postgresql.conf unix_socket_directories = '/tmp' 2.在unix_socket_directories 指定的路径下创建.s.PGSQL.5432.lock 文件并追加内容，给文件
解决FATAL: Could not open 'kernel/arch/mips/oprofile/oprofile.ko': No such file or directory
AmyDaddy的专栏
08-14 1135
depmod
oracle failed to open for read,vty_read_config: failed to open configuration file Permission denie...
weixin_42474537的博客
04-07 627
[root@kunpeng82 sdn-ip-topology]# zebra -d -f quagga-sdn.confvty_read_config: failed to open configuration file /root/ryu/SDN-IP-Ryu/sdn-ip-topology/quagga-sdn.conf: Permission deniedcan't open config...
PostgreSQL Configuration Files --PostgreSQ配置文件
weixin_33774308的博客
03-23 455
2019独角兽企业重金招聘Python工程师标准>>> ...
sinfo: error: resolve_ctls_from_dns_srv: res_nsearch error: Host name lookup failure
撞强※非专业，更专注
06-11 5721
slurm bug id:10066 url:https://bugs.schedmd.com/show_bug.cgi?id=10066
postgresql主从搭建
归来仍少年
12-04 2506
master : 172.16.0.105 slave : 172.16.0.103 1.正常搭建postgresql,并且进行数据库初始化 2.修改master的postgresql.conf配置文件 vi postgresql.conf listen_addresses = ‘*’ port = 5432 max_connections = 100 wal_level = hot_standby 3.在master上创建同步账号，并且授权 create user replica with passwor
FATAL: could not load library "/opt/pgsql/lib/pg_duckdb.so": /opt/pgsql/lib/pg_duckdb.so: undefined symbol: _ZNSt10filesystem7__cxx114path14_M_split_cmptsEv
08-27
我们正在处理一个动态链接错误，具体是当PostgreSQL尝试加载pg_duckdb.so扩展时，遇到了未定义符号的错误：_ZNSt10filesystem7__cxx114path14_M_split_cmptsEv。这个符号是C++标准库中文件系统模块的一部分，属于C++...
2025-10-24 07:54:47.947 UTC [41] FATAL: database "sonar" does not exist sonarqube-server | 07:54:48.873 [main] WARN org.sonar.application.config.AppSettingsLoaderImpl - Configuration file not found: /opt/sonarqube/conf/sonar.properties sonarqube-server | Exception in thread "main" org.sonar.process.MessageException: Bad format of JDBC URL: jdbc:sonarqube-db://postgres:5432/sonar sonarqube-server exited with code 0 sonarqube-server | 07:54:49.532 [main] WARN org.sonar.application.config.AppSettingsLoaderImpl - Configuration file not found: /opt/sonarqube/conf/sonar.properties sonarqube-server | Exception in thread "main" org.sonar.process.MessageException: Bad format of JDBC URL: jdbc:sonarqube-db://postgres:5432/sonar sonarqube-server exited with code 1 sonarqube-server | 07:54:50.310 [main] WARN org.sonar.application.config.AppSettingsLoaderImpl - Configuration file not found: /opt/sonarqube/conf/sonar.properties sonarqube-server | Exception in thread "main" org.sonar.process.MessageException: Bad format of JDBC URL: jdbc:sonarqube-db://postgres:5432/sonar sonarqube-server exited with code 1 sonarqube-server | 07:54:51.246 [main] WARN org.sonar.application.config.AppSettingsLoaderImpl - Configuration file not found: /opt/sonarqube/conf/sonar.properties sonarqube-server | Exception in thread "main" org.sonar.process.MessageException: Bad format of JDBC URL: jdbc:sonarqube-db://postgres:5432/sonar sonarqube-server exited with code 1 sonarqube-server | 07:54:52.566 [main] WARN org.sonar.application.config.AppSettingsLoaderImpl - Configuration file not found: /opt/sonarqube/conf/sonar.properties sonarqube-server | Exception in thread "main" org.sonar.process.MessageException: Bad format of JDBC URL: jdbc:sonarqube-db://postgres:5432/sonar sonarqube-server exited with code 1 sonarqube-db | 2025-10-24 07:54:53.020 UTC [49] FATAL: database "sonar" does not exist sonarqube-server | 07:54:54.696 [main] WARN org.sonar.application.config.AppSettingsLoaderImpl - Configuration file not found: /opt/sonarqube/conf/sonar.properties sonarqube-server | Exception in thread "main" org.sonar.process.MessageException: Bad format of JDBC URL: jdbc:sonarqube-db://postgres:5432/sonar
最新发布
10-25
- /opt/postgres/data:/var/lib/postgresql/data # 确保卷路径存在 sonar: depends_on: - postgres restart: always environment: SONARQUBE_JDBC_URL: "jdbc:postgresql://postgres:5432/sonar" # 修正URL...
WARNING: relaunching as opennms Invoking fix-karaf-setup.sh script... Pruning data directory: /opt/opennms/data find: Failed to change directory: Permission denied find: failed to restore initial working directory: Permission denied ============================================================================== OpenNMS Installer ============================================================================== Configures PostgreSQL tables, users, and other miscellaneous settings. 15:02:53.183 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.223 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.238 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.239 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.484 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.484 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.485 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. 15:02:53.486 [Main] INFO org.opennms.features.scv.jceks.JCEKSSecureCredentialsVault - No existing keystore found at: /opt/opennms/etc/scv.jce. Using empty keystore. DEBUG: Platform is IPv6 ready: true - searching for libjicmp.so: - trying to load /usr/lib64/libjicmp.so: OK - searching for libjicmp6.so: - trying to load /usr/lib64/libjicmp6.so: OK - searching for libjrrd.so: - trying to load /usr/lib64/libjrrd.so: NO - trying to load /usr/lib64/libjrrd.so: NO - trying to load /libjrrd.so: NO - trying to load /opt/opennms/lib/libjrrd.so: NO - trying to load /opt/opennms/lib/linux64/libjrrd.so: NO - trying to load /usr/java/packages/lib/libjrrd.so: NO - trying to load /usr/lib64/libjrrd.so: NO - trying to load /lib64/libjrrd.so: NO - trying to load /lib/libjrrd.so: NO - trying to load /usr/lib/libjrrd.so: NO - trying to load /usr/lib/jni/libjrrd.so: NO - trying to load /usr/lib/libjrrd.so: NO - trying to load /usr/local/lib/libjrrd.so: NO - trying to load /opt/NMSjicmp/lib/32/libjrrd.so: NO - trying to load /opt/NMSjicmp/lib/64/libjrrd.so: NO - trying to load /opt/NMSjicmp6/lib/32/libjrrd.so: NO - trying to load /opt/NMSjicmp6/lib/64/libjrrd.so: NO - Failed to load the optional jrrd library. - This error is not fatal, since jrrd is only required for optional features. - For more information, see http://www.opennms.org/index.php/jrrd - searching for libjrrd2.so: - trying to load /usr/lib64/libjrrd2.so: NO - trying to load /usr/lib64/libjrrd2.so: NO - trying to load /libjrrd2.so: NO - trying to load /opt/opennms/lib/libjrrd2.so: NO - trying to load /opt/opennms/lib/linux64/libjrrd2.so: NO - trying to load /usr/java/packages/lib/libjrrd2.so: NO - trying to load /usr/lib64/libjrrd2.so: NO - trying to load /lib64/libjrrd2.so: NO - trying to load /lib/libjrrd2.so: NO - trying to load /usr/lib/libjrrd2.so: NO - trying to load /usr/lib/jni/libjrrd2.so: NO - trying to load /usr/lib/libjrrd2.so: NO - trying to load /usr/local/lib/libjrrd2.so: NO - trying to load /opt/NMSjicmp/lib/32/libjrrd2.so: NO - trying to load /opt/NMSjicmp/lib/64/libjrrd2.so: NO - trying to load /opt/NMSjicmp6/lib/32/libjrrd2.so: NO - trying to load /opt/NMSjicmp6/lib/64/libjrrd2.so: NO - Failed to load the optional jrrd2 library. - This error is not fatal, since jrrd2 is only required for optional features. - For more information, see http://www.opennms.org/index.php/jrrd2 15:02:53.500 [Main] WARN org.opennms.install.Installer - Could not create file: /opt/opennms/etc/libraries.properties 15:02:53.534 [Main] INFO org.opennms.install.Installer - * using 'postgres' as the PostgreSQL user for OpenNMS 15:02:53.534 [Main] INFO org.opennms.install.Installer - * using 'opennms' as the PostgreSQL database name for OpenNMS 15:02:53.534 [Main] INFO org.opennms.core.schema.Migrator - validating database version java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.opennms.bootstrap.Bootstrap$4.run(Bootstrap.java:524) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.opennms.core.schema.MigrationException: an error occurred getting the version from the database at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:296) at org.opennms.core.schema.Migrator.validateDatabaseVersion(Migrator.java:324) at org.opennms.core.schema.Migrator.setupDatabase(Migrator.java:1008) at org.opennms.install.Installer.install(Installer.java:248) at org.opennms.install.Installer.main(Installer.java:1009) ... 6 more Caused by: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "postgres" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:693) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:203) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:253) at org.postgresql.Driver.makeConnection(Driver.java:434) at org.postgresql.Driver.connect(Driver.java:291) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at org.opennms.core.db.install.SimpleDataSource.getConnection(SimpleDataSource.java:106) at org.opennms.core.schema.Migrator.getDatabaseVersion(Migrator.java:284) ... 10 more Suppressed: org.postgresql.util.PSQLException: FATAL: Ident authentication failed for user "postgres" at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:693) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:203) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:267) ... 18 more 怎么解决
07-23
编辑 `pg_hba.conf` 文件，将本地连接的认证方式从 `ident` 改为 `trust` 或 `md5`，然后重新加载 PostgreSQL 配置： ```bash sudo -u postgres psql -c "SELECT pg_reload_conf();" ``` ### 相关库加载失败 ...
记录一次docker安装postgresql(pg)数据库容器后异常关机后启动异常问题
qq_34412985的博客
12-26 3722
使用docker安装的pg9.5容器，突然云主机升级直接停机后pg数据库容器启动不了后查看容器日志提示以下内容， 解决：按提示将容器的配置文件复制出来后修改后再复制到容器中 sudo docker cp pg_hba.conf 4d62f4628665:/var/lib/postgresql/data/pg_hba.conf //将本地配置文件复制到容器中 sudo docker cp 4d62f4628665:/var/lib/postgresql/data/pg_hba.conf . /...
lidar_align编译安装踩坑
luoyang7891的博客
05-06 1313
我的系统是ubuntu18.04 在利用官方教程进行安装时，出现如下报错： Could not find a package configuration file provided by "NLOPT" 修改CMakelist.txt文件17行： list(APPEND CMAKE_FIND_ROOT_PATH ${CMAKE_SOURCE_DIR}) 改为如下即可： list(APPEND CMAKE_FIND_ROOT_PATH ${CMAKE_SOURCE_DIR}/${PROJE
Fatal error, can‘t open config file ‘xxx‘: Permission denied
weixin_44989150的博客
07-06 7015
Fatal error, can’t open config file ‘/usr/redis/redis.conf’: Permission denied docker启动redis，用本地配置文件出现错误：Fatal error, can’t open config file ‘/usr/redis/redis.conf’: Permission denied 原因：本地的配置文件权限不足，给所属人，所属组，其他人都加上执行权限就可以 命令：chomd 755 文件名 ...
WARNING: can‘t open config file: /usr/local/ssl/openssl.cnf 错误
zp33
09-02 6962
WARNING: can’t open config file: /usr/local/ssl/openssl.cnf 出现此种错误第一种可能是配置错误，百度就可以找到解决方法 第二种可能是安装在C盘 openssl.exe打开时没有权限，用管理员权限打开就可以
PostgresQL在Ubuntu下源码安装 遇到的问题
luojinbai的专栏
01-13 2757
下载了一个VMware和Ubuntu的iso镜像，弄了个虚拟机尝试着使用源码安装PostgreSQL，我下载的PostgreSQL 的版本是9.3.5.    因为是linux和postgres的菜鸟，所以我参考下面这篇文章进行安装postgrs，   http://mingxinglai.com/cn/2014/03/compile-postgresql-in-linux/      第
initdb: error: could not create directory “/var/lib/postgresql/data/pg13“: Permission denied
weixin_42324368的博客
11-11 4813
harbor db容器 显示 restarting 重启状态，且重新安装过段时间任然如此，查看日志，harbor日志在配置文件中默认路径在/var/log/harbor
PostgreSQL 启动失败解决方法
Cheers Li 软件测试博客
07-11 6万+
PostgreSQL 启动失败解决 机房断电了，PostgreSQL 起不起来了。 [root@scoder19 9.3]# service postgresql-9.3 start Starting postgresql-9.3 service: [FAILED] 日志文件（/var/lib/pgsql/9.3/pgstartup.log）：报错如下： FATAL:  data
PostgreSQL的几种常见问题和解决方法
热门推荐
international24的博客
04-30 7万+
1. 前言 1.1 概述 本文介绍了postgresql的几种常见问题，并从现象出发，逐步排查问题，分析导致问题的原因并给出解决方案。 本文介绍的问题分为两大类：一类是关于PostgreSQL无法启动的问题，另一类是PostgreSQL启动后，部分数据库对象无法访问的问题。 1.2软件环境 本文使用的 PostgreSQL 版本是 9.2。 1.3一些约定术语 PostgreSQ...
gitlab在docker报错could not open /var/opt/gitlab/.ssh/authorized_keys解决
沛哥儿的专栏
10-21 3110
在简书上有个网友给了个偷巧的办法。在docker start 容器后，立即执行赋权操作，然后再启动容器这个操作。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值