• Upgrade to postgresql 9.5


       

    Add postgresql apt repo.. according to your distribution (utopic, trusty, jessie, wheezy and etc):

       

    deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main 9.5

       

    Install postgresql 9.5

    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

    apt-get update

    apt-get install postgresql-9.5

       

       

    Upgrade db files.

       

    Pg9.3 to pg9.5, run the following command

       

    sudo -H -u postgres

    /usr/lib/postgresql/9.5/bin/pg_upgrade -b /usr/lib/postgresql/9.3/bin/

    -B /usr/lib/postgresql/9.5/bin/

    -d /var/lib/postgresql/9.3/main

    -D /var/lib/postgresql/9.5/main

    -o ' -c config_file=/etc/postgresql/9.3/main/postgresql.conf'

    -O ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf'

       

       

       

    Pg9.1 to pg9.5, run the following command

       

    sudo -H -u postgres

    /usr/lib/postgresql/9.5/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin/

    -B /usr/lib/postgresql/9.5/bin/

    -d /var/lib/postgresql/9.1/main

    -D /var/lib/postgresql/9.5/main

    -o ' -c config_file=/etc/postgresql/9.1/main/postgresql.conf'

    -O ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf'

       

       

       

       

       

    转载注明原作者 /by Jeffery
  • 相关阅读:
    混淆
    【虚拟DOM】√
    fn
    notebook
    sourceMappingURL
    十进制转换为十六进制
    关于this和super的区别
    类中访问级别
    Java中字符串解析
    IWorkspace操作
  • 原文地址:https://www.cnblogs.com/odoouse/p/5122249.html
Copyright © 2020-2023  润新知