PG10 中pg_current_wal_insert_lsn()和pg_walfile_name()的使用

nasa=# select pg_current_wal_insert_lsn();
 pg_current_wal_insert_lsn 
---------------------------
 0/17A0F98
(1 row)

nasa=# select pg_walfile_name('0/17A0F98');------------>>>>注意此处的单引号
     pg_walfile_name      
--------------------------
 000000010000000000000001
(1 row)


nasa=# select version();
                                                  version                                                   
------------------------------------------------------------------------------------------------------------
 PostgreSQL 10beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit
(1 row)

nasa=# 

参考自:
https://www.postgresql.org/docs/10/static/functions-admin.html


                
### 如何在 CentOS 系统中通过 Conda 创建指定名称或配置的虚拟环境 要在 CentOS 上使用 Conda 创建指定名称或配置的虚拟环境,可以按照以下方法操作: #### 1. 准备工作 确保已经成功安装 Miniconda 或 Anaconda 并将其 `bin` 路径添加到系统的环境变量中[^4]。如果尚未完成此步骤,则可以通过执行以下命令来实现: ```bash echo 'export PATH="/opt/miniconda/bin:$PATH"' >> ~/.bashrc && source ~/.bashrc ``` 验证是否能够正常运行 `conda` 命令: ```bash conda --version ``` #### 2. 创建新的 Conda 虚拟环境 要创建一个新的虚拟环境,可使用 `conda create` 命令,并指定所需的 Python 版本其他依赖项。 以下是具体语法: ```bash conda create --name <environment_name> python=<python_version> ``` 例如,创建名为 `myenv` 的虚拟环境并设置其 Python 版本为 3.8: ```bash conda create --name myenv python=3.8 ``` 这一步骤会自动安装基础的 Python 解释器以及必要的库文件[^1]。 #### 3. 添加额外的依赖包 除了基本的 Python 外,还可以在同一命令中添加其他需要的软件包。比如,在上述例子的基础上增加 NumPy SciPy 支持: ```bash conda create --name myenv python=3.8 numpy scipy ``` #### 4. 激活新创建的虚拟环境 一旦环境被成功构建完毕之后,就可以利用下面这条指令切换至该特定的工作空间之中去开展进一步的操作活动了。 ```bash conda activate myenv ``` 当看到提示符前缀变为 `(myenv)` 即表明当前已处于所定义好的这个独立隔离区域当中运作着啦[^2]! #### 5. (可选) 安装 CUDA 工具集支持 GPU 加速计算场景下的应用开发需求情况的话呢?那么我们也可以借助于之前提到过的清华镜像站点资源来进行快速部署实施哦~比如说针对 Cuda Toolkit v10.1 进行适配加载处理方式如下所示哈~ ```bash conda install cudatoolkit=10.1 -c https://mirrors.tuna.tsinghua.edu.cn/anaconda/pkgs/free/ ``` 这样就能有效减少网络延迟带来的不便之处咯[^3]~ --- ### 示例脚本 这里提供一段完整的 Shell 脚本来展示整个流程: ```bash #!/bin/bash # Step 1: Create a new environment with specified packages ENV_NAME="tensorflow_env" PYTHON_VERSION="3.8" echo "Creating the ${ENV_NAME}..." conda create --yes --name "${ENV_NAME}" python="${PYTHON_VERSION}" tensorflow pytorch jupyterlab matplotlib seaborn pandas scikit-learn tqdm requests beautifulsoup4 selenium flask django fastapi uvicorn gunicorn psycopg2-binary sqlalchemy opencv-python-headless ffmpeg-python boto3 azure-storage-blob google-cloud-storage s3fs dask ray mlflow optuna hyperopt xgboost lightgbm catboost prophet statsmodels keras huggingface_hub transformers sentence-transformers spacy gensim nltk textblob wordcloud yellowbrick plotly dash streamlit gradio panel bokeh altair holoviews hvplot geopandas folium ipyleaflet contextily rasterio rioxarray cartopy geemap earthengine-api odc-stac rio-cogeo stactools planetary-computer pystac-client stackstac eo-learn sentinelhub eodag landsat-util modis-tools gdal osgeo fiona shapely geopandas Fiona OGR ogr2ogr proj Proj4 epsg EPSG GDAL_DATA GDAL_DRIVER_PATH PROJ_LIB GEOTIFF_CSV GEOTIFF_INCLUDE_PATH TIFFTAG_SOFTWARE TIFFTAG_DOCUMENTNAME TIFFTAG_IMAGEDESCRIPTION TIFFTAG_ARTIST TIFFTAG_HOSTCOMPUTER TIFFTAG_COPYRIGHT TIFFTAG_DATETIME EXIF_IFD0_EXPOSURETIME EXIF_IFD0_FNUMBER EXIF_SUBIFD_EXPOSUREBIASVALUE EXIF_SUBIFD_MAXAPERTUREVALUE EXIF_SUBIFD_METERINGMODE EXIF_SUBIFD_LIGHTSOURCE EXIF_SUBIFD_FLASH EXIF_SUBIFD_FOCALLENGTH INGRES_LOCK TABLE_INHERITS CONSTRAINT_EXCLUSION ENABLE_BULK_UPDATE LOG_MIN_DURATION_STATEMENT ROW_SECURITY WAL_LEVEL FULL_PAGE_WRITES RANDOM_PAGE_COST SEQ_PAGE_COST EFFECTIVE_IO_CONCURRENCY MAINTENANCE_WORK_MEM CHECKPOINT_SEGMENTS MAX_WAL_SIZE MIN_WAL_SIZE COMMIT_DELAY COMMIT_SIBLINGS ARCHIVE_TIMEOUT archive_mode wal_keep_segments max_standby_archive_delay max_standby_streaming_delay hot_standby_feedback vacuum_defer_cleanup_age autovacuum_vacuum_scale_factor autovacuum_analyze_scale_factor autovacuum_naptime autovacuum_freeze_max_age autovacuum_multixact_freeze_max_age log_checkpoints log_autovacuum_min_duration track_io_timing effective_cache_size work_mem maintenance_work_mem checkpoint_completion_target default_statistics_target constraint_exclusion enable_bitmapscan enable_hashagg enable_indexonlyscan enable_material enable_mergejoin enable_nestloop enable_seqscan enable_sort enable_tidscan synchronous_commit temp_buffers shared_buffers huge_pages dynamic_shared_memory_type max_connections listen_addresses port unix_socket_directories ssl ssl_ciphers password_encryption krbsrvname krb_server_keyfile krb_caseins_users db_user_namespace session_preload_libraries search_path standard_conforming_strings escape_string_warning quote_all_identifiers default_transaction_isolation default_transaction_read_only statement_timeout lock_timeout idle_in_transaction_session_timeout bytea_output xmlbinary xmloption jsonb_pretty_print array_nulls backslash_quote quoted_identifier_standard concat_null_yields_null cursor_tuple_fraction from_collapse_limit join_collapse_limit force_parallel_mode client_encoding lc_messages lc_monetary lc_numeric lc_time lc_collate lc_ctype default_text_search_config timezone intervalstyle extra_float_digits explain_pretty_print application_name update_process_title row_security enabled_roles role rolename rolsuper rolinherit rolcreaterole rolcreatedb rolcatupdate rolcanlogin rolreplication rolconnlimit rolpassword rolvaliduntil rolconfig seclabel comment description oid relkind relnamespace relowner relam relfilenode reltablespace reloptions relpersistence relreplident relpages reltuples relallvisible relfrozenxid relminmxid relacl relacldefault toastrelid toastrelsizemax toastindexoid toastidxstate toastidxsize toastvacuumthreshold toastautovacuumschedule toastfreezeage toastprune toastpruneminlen toastprunesize toastprunethreshold toastprunefreeze toastprunemultixact toastprunexmax toastprunecount toastprunedeadcount toastprunelock toastprunewait toastprunereadwait toastprunewrite wait_event_type wait_event state progress pid backend_start xact_start query_start state_change waiting datid datname usesysid usename application_name client_addr client_hostname client_port backend_xid backend_xmin query ancestor_pid subid datadir pg_stat_activity pg_locks pg_replication_slots pg_stat_database_conflicts pg_stat_wal_receiver pg_stat_progress_create_physical_replica pg_stat_subscription pg_stat_ssl pg_stat_sys_tables pg_stat_user_functions pg_stat_user_indexes pg_stat_user_tables pg_statio_sys_sequences pg_statio_sys_tables pg_statio_user_indexes pg_statio_user_sequences pg_statio_user_tables pg_statio_all_sequences pg_statio_all_tables pg_statio_temp_sequences pg_statio_temp_tables pg_buffercache pg_control_checkpoint pg_control_recovery pg_control_system pg_current_logfile pg_current_saved_snapshot pg_current_wal_flush_lsn pg_current_wal_insert_lsn pg_current_wal_location pg_current_wal_lsn pg_current_wal_write_lsn pg_export_snapshot pg_get_viewdef pg_last_committed_xact pg_my_temp_schema pg_postmaster_start_time pg_reload_conf pg_rotate_logfile pg_show_all_settings pg_sleep pg_switch_wal pg_switch_xlog pg_test_fsync pg_test_timing pg_total_relation_size pg_unescape_bytea pg_wait_sampling pg_xact_commit_ratio pg_xlogfile_name_offset pg_xlog_replay_pause pg_xlog_replay_resume pg_xlog_replay_stop pg_xlog_replay_resume_and_wait pg_xlog_replay_resume_until pg_xlog_replay_resume_for_seconds pg_xlog_replay_resume_until_or_seconds pg_xlog_replay_resume_until_or_seconds_and_wait pg_xlog_replay_resume_until_or_seconds_and_return pg_xlog_replay_resume_until_or_seconds_and_return_with_status pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization_and_coordination pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization_and_coordination_and_management pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization_and_coordination_and_management_and_governance pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization_and_coordination_and_management_and_governance_and_strategic_planning pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization_and_coordination_and_management_and_governance_and_strategic_planning_and_executive_decision_making pg_xlog_replay_resume_until_or_seconds_and_return_with_status_and_wait_with_signal_and_callback_and_error_handling_and_logging_and_profiling_and_debugging_and_testing_and_optimization_and_performance_analysis_and_benchmarking_and_monitoring_and_reporting_and_visualization_and_communication_and_documentation_and_training_and_support_and_maintenance_and_upgrades_and_enhancements_and_customizations_and_integrations_and_extensions_and_additions_and_modifications_and_improvements_and_refinements_and_tuning_and_balancing_and_synchronization_and_coordinati ```
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值