Backup for databases test

[wallacekos]

hi all, im testing server in local host.
need make a backup fpr databases for put in VPS machine...

any ideia for this?

tank you.

 

[yokohiro]

hi all, im testing server in local host.
need make a backup fpr databases for put in VPS machine...

any ideia for this?

tank you.

01 - "use postgres" in the console...

02 - making files backup from database

pg_dump ffaccount > ffaccount.bak
pg_dump ffdb1 > ffdb1.bak
pg_dump ffmember > ffmember.bak

ps: after make backup, look root folder, contain your files database backup.

03 - restaure database files backup

createdb -T template0 ffaccount
psql ffaccount < ffaccount.bak

createdb -T template0 ffdb1
psql ffdb1 < ffdb1.bak

createdb -T template0 ffmember
psql ffmember < ffmember.bak

if u have any this database, need delete then before restaure files.

enjoy

 

[wallacekos]

01 - "use postgres" in the console...

02 - making files backup from database

pg_dump ffaccount > ffaccount.bak
pg_dump ffdb1 > ffdb1.bak
pg_dump ffmember > ffmember.bak

ps: after make backup, look root folder, contain your files database backup.

03 - restaure database files backup

createdb -T template0 ffaccount
psql ffaccount < ffaccount.bak

createdb -T template0 ffdb1
psql ffdb1 < ffdb1.bak

createdb -T template0 ffmember
psql ffmember < ffmember.bak

if u have any this database, need delete then before restaure files.

enjoy

very very tank you yokohiro, work fine.