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 的備份還原 | 豬窩
Howdy! I could have sworn I've visited this web site before but after
looking at many of the articles I realized it's new to me.
Anyhow, I'm certainly pleased I discovered it and I'll be book-marking it and checking back frequently!
PostgreSql 的備份還原 | 豬窩
This post is in fact a fastidious one it helps new the web users, who are wishing in favor of blogging.
PostgreSql 的備份還原 | 豬窩
hey there and thank you for your information – I've
definitely picked up something new from right here.
I did however expertise a few technical points using
this website, since I experienced to reload the website
lots of times previous to I could get it to load correctly.
I had been wondering if your hosting is OK? Not that I'm complaining, but slow loading instances times will sometimes affect your
placement in google and can damage your high-quality score if advertising and marketing with Adwords.
Anyway I am adding this RSS to my email and can look out for much more of your respective intriguing content.
Make sure you update this again soon.
PostgreSql 的備份還原 | 豬窩
A person essentially help to make seriously posts I'd state.
That is the very first time I frequented your website page and thus far?
I amazed with the analysis you made to make this particular put up amazing.
Wonderful task!
PostgreSql 的備份還原 | 豬窩
Have you ever thought about publishing an ebook or guest authoring on other sites?
I have a blog based upon on the same ideas you discuss and
would love to have you share some stories/information. I
know my audience would appreciate your work. If you are even remotely interested,
feel free to shoot me an e-mail.