# vi /usr/localpgsql/bin/pg_bakjedi.sh
#!/bin/sh
nowtime=`/bin/date +%Y%m%d%H`
#echo $nowtime
/usr/local/pgsql/bin/pg_dump -U postgres -CD jedidb > /usr/local/pgsql/bak/jedidb$nowtime.bak
# chmod a+x /usr/localpgsql/bin/pg_bakjedi.sh
# export EDITOR=vi
# crontab -e
10 01 * * * /usr/local/pgsql/bin/pg_bakjedi.sh
分享到:
相关推荐
postgresql database 官方原版
postgresql database version 11 win 64 zip
postgresql-database_rev6.json
postgresql sample database 示例数据库
如果在windows上安装了postgresql,可以通过点击bat文件运行,一键备份数据库,可以跳过创建文件夹、输入密码等过程。
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. ...
to address the process of deploying a PostgreSQL database on the cloud, we include a detailed architecture of PostgreSQL in one of the chapters. The architecture of PostgreSQL should help you ...
Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance. Discover the techniques used to scale successful database installations. Avoid...
数据库js postgres PostgreSQLDatabase-js包装器关于Database-js-postgres是Brian Carlson的包的包装。 它旨在与包一起使用。 但是,它也可以在独立模式下使用。 这样做的唯一原因是使用 。用法独立var postgres = ...
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 ...
入门将gem添加到您的Rails项目中: gem 'postgresql-backup' 转到终端并使用捆绑程序更新您的宝石: bundle install现在,您的项目已经有两个新的rake任务: backup和restore 。配置如果打算使用本地文件系统存储...
dbExpress is a database-independent layer that defines common interface to provide fast access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms....
MicroOLAP Database Designer for PostgreSQL
连接字符串的格式为:jdbc:postgresql://localhost:5432/database_name,其中,localhost 是服务器的地址,5432 是 PostgreSQL 数据库的默认端口号,database_name 是数据库的名称。 知识点:Matlab 的数据库操作 ...
PostgreSQL Database Modeler或简称pgModeler是CASE工具的一个开源项目,用于为PostgreSQL建模,该模型将使用实体关系图的经典建模概念与仅PostgreSQL实现的特定功能合并在一起。 pgModeler将用户创建的模型转换为...
Discover how to design, develop, and maintain your database application effectively with PostgreSQL About This Book Understand how to utilize the most frequently used PostgreSQL ecosystem-related ...
navicat 连接PostgreSQL报错:ERROR: SSL connection is required by the database system
PostgreSQL 数据库 自动 备份 脚本 batch 定时任务 。