PostgreSQL

来源:互联网 发布:81端口是什么服务 编辑:程序博客网 时间:2024/06/08 18:51

1.PostgreSQL安装

http://www.tuicool.com/articles/MVjMvmB

make[3]: *** [pg_dump] Error 1

http://francs3.blog.163.com/blog/static/40576727201341791459178/


configure: error: readline library notfound

http://www.linuxidc.com/Linux/2012-02/53982.htm


2.建表和加注释

http://blog.sina.com.cn/s/blog_8f553f510101d1va.html

修改用户密码

http://blog.csdn.net/xocoder/article/details/24479751

http://blog.csdn.net/shangzwz/article/details/8601700

http://blog.51yip.com/pgsql/1524.html


3.postgresql启动、状态查看、关闭

http://blog.csdn.net/silenceray/article/details/52448395


4.流复制、主备切换、ip漂移

http://blog.csdn.net/baiyinqiqi/article/details/47833811

http://blog.csdn.net/baiyinqiqi/article/details/47951687

http://itfish.net/article/61538.html

主备切换:http://blog.csdn.net/silenceray/article/details/54692908

archive_mode http://blog.csdn.net/guoxianqi2012/article/details/7341617


集群Fence理论和配置

http://blog.csdn.net/vmboys/article/details/51726388


fence配置问题

https://wenku.baidu.com/view/c7cc4507767f5acfa0c7cd21.html

https://wenku.baidu.com/view/212db2f7c8d376eeaeaa3127.html

http://www.linuxidc.com/Linux/2014-05/102023p2.htm


5.添加网卡

cp ifcfg-lo eno16777736:1 修改对应的ip地址

0 0