`
wwbutton
  • 浏览: 41682 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

Auto Backup PostgreSQL DataBase

阅读更多
# 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 官方原版

    postgresql database version 11 win 64 zip

    postgresql database version 11 win 64 zip

    postgresql-database_rev6.json

    postgresql-database_rev6.json

    postgresql sample database

    postgresql sample database 示例数据库

    postgresql_backup.bat

    如果在windows上安装了postgresql,可以通过点击bat文件运行,一键备份数据库,可以跳过创建文件夹、输入密码等过程。

    PostgreSQL 10 Administration Cookbook 1st

    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. ...

    Beginning PostgreSQL on the Cloud-Apress(2018).pdf

    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 ...

    PostgreSQL 9.0 High Performance

    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...

    database-js-postgres:PostgreSQLDatabase-js包装器

    数据库js postgres PostgreSQLDatabase-js包装器关于Database-js-postgres是Brian Carlson的包的包装。 它旨在与包一起使用。 但是,它也可以在独立模式下使用。 这样做的唯一原因是使用 。用法独立var postgres = ...

    Building a Spatial Database in PostgreSQL

    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 ...

    postgresql-backup:自动化PostgreSQL备份和还原

    入门将gem添加到您的Rails项目中: gem 'postgresql-backup' 转到终端并使用捆绑程序更新您的宝石: bundle install现在,您的项目已经有两个新的rake任务: backup和restore 。配置如果打算使用本地文件系统存储...

    dbExpress driver for PostgreSQL v3.2.3

    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

    MicroOLAP Database Designer for PostgreSQL

    PostgreSQL Database Modeler-开源

    PostgreSQL Database Modeler或简称pgModeler是CASE工具的一个开源项目,用于为PostgreSQL建模,该模型将使用实体关系图的经典建模概念与仅PostgreSQL实现的特定功能合并在一起。 pgModeler将用户创建的模型转换为...

    PostgreSQL.for.Data.Architects.1783288604

    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_DB_BackUp.cmd

    PostgreSQL 数据库 自动 备份 脚本 batch 定时任务 。

    Learning PostgreSQL 10

    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 ...

    PostgreSQL 9 Administration Cookbook

    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

    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 ...

Global site tag (gtag.js) - Google Analytics