PostgreSql 的備份還原
用 pgAdmin III 的備份還原一直無法成功,我是從另一台的備份檔拿到另一台還原,可是一直失敗,真不知那台備份是如何做的,有空應該研究一下
在網上找到一個方法,雖然是最基本的,但是可以成功,方法如下:
備份:
pg_dump -U[使用者] -c [DB名稱] > xxx.sql
還原:
1. dropdb -U[使用者] [DB]; //刪除舊資料庫
2. createdb -U[使用者] [DB]; //建資料庫
3 .psql -U[使用者] [DB] < xxx.sql //匯入資料
這樣就成功了,雖然是最基本的 sql 備分,可是竟然是最好用的
迴響
PostgreSql 的備份還原 | 豬窩
Hurrah, that's what I was exploring for, what a data!
present here at this blog, thanks admin of this website.
PostgreSql 的備份還原 | 豬窩
Really when someone doesn't know after that its up to other people that they will assist, so here it occurs.
PostgreSql 的備份還原 | 豬窩
For the true supporter infortmation of latestt football news is an exciting matter.
Positive figures show the amount you wwould win for geting
a $100 spot. The bers are broadly considered inside bets and outside bets.
PostgreSql 的備份還原 | 豬窩
This blog was... how do I say it? Relevant!! Finally I've found
something which helped me. Many thanks!
PostgreSql 的備份還原 | 豬窩
Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something.
I think that you could do with some pics to drive the message home a little bit, but other than that, this is magnificent blog.
An excellent read. I'll certainly be back.