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 的備份還原 | 豬窩
Cbd oil that works 2020
I was wondering if you ever thought of changing the layout of your
website? Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content so people could
connect with it better. Youve got an awful lot of text for only
having one or two images. Maybe you could space it out better?
best cbd oil for pain http://tinyurl.com/cbd-oil-that-works-2020 cbd oil that works
2020 http://tinyurl.com/cbd-oil-that-works-2020
PostgreSql 的備份還原 | 豬窩
Hello there, You've done an incredible job. I'll definitely digg it and personally suggest to my
friends. I'm confident they will be benefited from this
site.
PostgreSql 的備份還原 | 豬窩
Hey there just wanted to give you a quick heads up.
The words in your content seem to be running off the screen in Safari.
I'm not sure if this is a formatting issue or something to do with
internet browser compatibility but I figured I'd post to
let you know. The layout look great though! Hope
you get the issue solved soon. Cheers
PostgreSql 的備份還原 | 豬窩
Excellent way of telling, and pleasant piece of writing to obtain data on the topic of my presentation focus, which i am going to present in school.
PostgreSql 的備份還原 | 豬窩
Hi there, I discovered your web site by the use of Google at the same time
as looking for a comparable subject, your website got here up, it appears to be like great.
I've bookmarked it in my google bookmarks.
Hi there, just turned into alert to your weblog thru Google, and located that it's truly informative.
I'm going to be careful for brussels. I'll appreciate when you proceed this in future.
Numerous people might be benefited from your
writing. Cheers!