postgreSQL12

pg12,服务启动正常,日志一直报:

img

把端口号当成role了?还没有办法创建5432这个role,以下是配置信息:

cat /var/lib/pgsql/12/data/postgresql.conf|grep '^[a-Z]'

listen_addresses = '*'        # what IP address(es) to listen on;
max_connections = 100            # (change requires restart)
shared_buffers = 128MB            # min 128kB
dynamic_shared_memory_type = posix    # the default is the first option
max_wal_size = 1GB
min_wal_size = 80MB
log_destination = 'stderr'        # Valid values are combinations of
logging_collector = on            # Enable capturing of stderr and csvlog
log_directory = 'log'            # directory where log files are written,
log_filename = 'postgresql-%a.log'    # log file name pattern,
log_truncate_on_rotation = on        # If on, an existing log file with the
log_rotation_age = 1d            # Automatic rotation of logfiles will
log_rotation_size = 0            # Automatic rotation of logfiles will
log_line_prefix = '%m [%p] '        # special values:
log_timezone = 'Asia/Shanghai'
datestyle = 'iso, mdy'
timezone = 'Asia/Shanghai'
lc_messages = 'en_US.UTF-8'            # locale for system error message
lc_monetary = 'en_US.UTF-8'            # locale for monetary formatting
lc_numeric = 'en_US.UTF-8'            # locale for number formatting
lc_time = 'en_US.UTF-8'                # locale for time formatting
default_text_search_config = 'pg_catalog.english'
cat /var/lib/pgsql/12/data/pg_hba.conf
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
#host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
#host    all             all             ::1/128                 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            ident
host    replication     all             ::1/128                 ident
host    all              all            0.0.0.0/0               trust

引用GPT回答:
在组合起来进行仿真时,可能存在一些时序和同步问题导致输出不正确。具体可能原因有很多,需要进行详细的分析和调试。

首先,你可以检查频率测量模块的输出是否按预期工作。如果该模块的输出正确,则问题可能出在频率分频模块中。

其次,你可以检查频率分频模块的时序和同步是否正确。例如,你可以检查时钟边沿是否正确、信号延迟是否正确等等。

最后,你可以使用模拟器进行调试,以确定是否存在其他问题。可以通过波形查看器来检查各个信号的变化情况,从而找出问题所在。

总之,需要仔细分析和调试,逐步确定问题所在,才能解决频率分频模块输出不正确的问题。

看了日志,有一个疑惑,还有一个排查建议:

  1. 看日志里,数据库14:30 显示shutdown了 ,你是正常启动还是正常stop?
  2. 报错一个role找不见,看你的hba中配置了Ident校验模式,看看pg_ident.conf 这个文件里的配置,是否有用户,在数据库中没有;