Ad Widget

Collapse

Postgres problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • azady_part
    Junior Member
    • Oct 2011
    • 9

    #1

    Postgres problem

    hi all

    postgres database grow up and my partition of hard disk is full.

    I want to change postgres default path to another hard partition on server.

    my question is how can I do that and after change path, history of items that collected by zabbix will removed or still In databases and I can use them (such as use for graph and etc) ?

    sorry for bad English

    tnx
  • kloczek
    Senior Member
    • Jun 2006
    • 1771

    #2
    Look on sticky topic of this forum:
    http://uk.linkedin.com/pub/tomasz-k%...zko/6/940/430/
    https://kloczek.wordpress.com/
    zapish - Zabbix API SHell binding https://github.com/kloczek/zapish
    My zabbix templates https://github.com/kloczek/zabbix-templates

    Comment

    • azady_part
      Junior Member
      • Oct 2011
      • 9

      #3
      thanks kloczek, but those Thread was not my solution I want to change default path of postgres db with 350 G data(all data are important)

      Comment

      • Colttt
        Senior Member
        Zabbix Certified Specialist
        • Mar 2009
        • 878

        #4
        create a new partition, stop postgreSQL, copy all files from /var/lib/postgresql/9.3/main to you new parttion set this path in you /etc/postgresql/9.3/main/postgresql.conf
        edit you /etc/fstab to mount you new partition at boot time..
        start postgresql and cross fingers
        Debian-User

        Sorry for my bad english

        Comment

        Working...