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 的備份還原 | 豬窩
We absolutely love your blog and find almost all of your post's to be
just what I'm looking for. Does one offer guest writers to write content for you?
I wouldn't mind composing a post or elaborating on a lot of the subjects you write with regards
to here. Again, awesome weblog!
PostgreSql 的備份還原 | 豬窩
I love looking through an article that will make men and women think.
Also, many thanks for allowing me to comment!
PostgreSql 的備份還原 | 豬窩
A necessary part of getting comps is letting the pit boss
know visitor to your site the market. Bulls v Brumbies Live Streams Rugby Game video Online on Computer's desktop.
The pfogram is called Satllite TV for Laptop or desktop.
PostgreSql 的備份還原 | 豬窩
You need to take part in a contest for one of the highest quality
blogs on the net. I am going to recommend this web site!
PostgreSql 的備份還原 | 豬窩
Keep a brave face on since they can be around your wife girlfriend.
Instead of using complicated lists of numbers label the folder more
exclusively for example, "Appliances-Refrigerator".