# 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
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 ...
PostgreSQL 数据库 自动 备份 脚本 batch 定时任务 。
Leverage the power of PostgreSQL 10 to build powerful database and data warehousing applications. About This Book Be introduced to the concept of relational databases and PostgreSQL, one of the ...
Simon Riggs is one of the few Major Developers and Committers on the PostgreSQL database project, and is also CTO of 2ndQuadrant, providing 24x7 support and services to PostgreSQL users worldwide....
EMS PostgreSQL Manager is a powerful tool for PostgreSQL® Database Server administration and development. PostgreSQL Manager works with any PostgreSQL versions up to 8.0 and supports all of the ...