Wednesday, July 4, 2007

Postgre SQL backup

Pro posgres.

stolknulsa s tem chto mne nado bylo sdelat backup bazy dannyx i soxranit ego.
ideja mne krajne ne ponravilas, t.k. utilitku dla backupa predlagalos pisat na php

otkryl manual po posgreSql
v papke kuda ustanovlen postgres (obychno /usr/local/pgsql ) v podpapke bin est mnozjestvo krasivyx utilitok

naprimer:

-- vse primery ispolnajutsa iz papki /usr/local/pgsql/bin i rabotajut s bazoj, nazyvajuschejsa dbname

./createdb dbname
sozdaet bazu

./dropdb dbname
udalaet

./pg_dump dbname > /home/postgres/mybackup
sozdaet dump bazy (dannye o tablicax i ix soderzjimom v vide SQL kommand)
i zapisyvaet ego v fail /home/postgres/mybackup

./psql dbname < /home/postgres/mybackup
vosstanavlivaet bazu iz fajla

0 comments:

Post a Comment