开发者社区> 问答> 正文

PolarDB集群如何初始化

PolarDB集群如何初始化

展开
收起
提个问题 2024-06-01 12:06:04 27 0
1 条回答
写回答
取消 提交回答
  • 使用如下命令来进行初始化:

     initdb -D /data/polardb/pgdata
    

    执行过程如下:

    [polardb@td1 ~]$ initdb -D /data/polardb/pgdata
    The files belonging to this database system will be owned by user "polardb".
    This user must also own the server process.
    The database cluster will be initialized with locale "en_US.UTF-8".
    The default database encoding has accordingly been set to "UTF8".
    The default text search configuration will be set to "english".
    Data page checksums are disabled.
    fixing permissions on existing directory /data/polardb/pgdata ... ok
    creating subdirectories ... ok
    selecting default max_connections ... 100
    selecting default shared_buffers ... 128MB
    selecting dynamic shared memory implementation ... posix
    creating configuration files ... ok
    running bootstrap script ... 2020-06-10 15:51:15 CST LOG:  polar_csnlog remove  /data/polardb/pgdata/pg_csnlog/0000
    ok
    performing post-bootstrap initialization ... ok
    creating edb sys ... ok
    loading edb contrib modules ...
    edb_redwood_bytea.sql ok
    edb_redwood_date.sql ok
    dbms_alert_public.sql ok
    dbms_alert.plb ok
    dbms_job_public.sql ok
    dbms_job.plb ok
    dbms_lob_public.sql ok
    dbms_lob.plb ok
    dbms_output_public.sql ok
    dbms_output.plb ok
    dbms_pipe_public.sql ok
    dbms_pipe.plb ok
    dbms_rls_public.sql ok
    dbms_rls.plb ok
    dbms_sql_public.sql ok
    dbms_sql.plb ok
    dbms_utility_public.sql ok
    dbms_utility.plb ok
    dbms_aqadm_public.sql ok
    dbms_aqadm.plb ok
    dbms_aq_public.sql ok
    dbms_aq.plb ok
    dbms_profiler_public.sql ok
    dbms_profiler.plb ok
    dbms_random_public.sql ok
    dbms_random.plb ok
    dbms_redact_public.sql ok
    dbms_redact.plb ok
    dbms_lock_public.sql ok
    dbms_lock.plb ok
    dbms_scheduler_public.sql ok
    dbms_scheduler.plb ok
    dbms_crypto_public.sql ok
    dbms_crypto.plb ok
    dbms_mview_public.sql ok
    dbms_mview.plb ok
    dbms_session_public.sql ok
    dbms_session.plb ok
    edb_gen.sql ok
    edb_objects.sql ok
    edb_redwood_casts.sql ok
    edb_redwood_strings.sql ok
    edb_redwood_views.sql ok
    utl_encode_public.sql ok
    utl_encode.plb ok
    utl_http_public.sql ok
    utl_http.plb ok
    utl_file.plb ok
    utl_tcp_public.sql ok
    utl_tcp.plb ok
    utl_smtp_public.sql ok
    utl_smtp.plb ok
    utl_mail_public.sql ok
    utl_mail.plb ok
    utl_url_public.sql ok
    utl_url.plb ok
    commoncriteria.sql ok
    waitstates.sql ok
    installing extension edb_dblink_libpq ... ok
    installing extension edb_dblink_oci ... ok
    installing extension pldbgapi ... ok
    snap_tables.sql ok
    snap_functions.sql ok
    sys_stats.sql ok
    loading edb contrib modules ...
    installing extension polar_utl_raw ... ok
    installing extension polar_dbms_obfuscation_toolkit ... ok
    installing extension appendchildxml ... ok
    installing extension polar_asciistr ... ok
    installing extension polar_cyclechecker_noticer ... ok
    installing extension polar_datetime_double ... ok
    finalizing initial databases ... ok
    syncing data to disk ... ok
    WARNING: enabling "trust" authentication for local connections
    You can change this by editing pg_hba.conf or using the option -A, or
    --auth-local and --auth-host, the next time you run initdb.
    Success. You can now start the database server using:
    pg_ctl -D /data/polardb/pgdata -l logfile start
    

    ——参考链接

    2024-06-23 15:53:57
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
PolarDB+AnalyticDB助力交通物流行业系统升级 立即下载
PolarDB NL2SQL: 帮助您写出准确、优化的SQL 立即下载
云栖大会:开源 PolarDB 架构演进、关键技术与社区建设 立即下载