差分

このページの2つのバージョン間の差分を表示します。

この比較画面へのリンク

両方とも前のリビジョン前のリビジョン
次のリビジョン
前のリビジョン
study:database:postgresql:backup [2010/05/17 11:39] bananastudy:database:postgresql:backup [2010/07/02 07:26] (現在) banana
行 8: 行 8:
 eccube_db_user -F c -b -v -f "D:\backup\c_action.backup" -t c_action eccube_db_test eccube_db_user -F c -b -v -f "D:\backup\c_action.backup" -t c_action eccube_db_test
 </code> </code>
 +ここで、オプションの意味を次に示す。
 +^option^詳細^備考^
 +|-p| –port=PORT| database server port number|
 +|-i| –ignore-version| proceed even when server version mismatches|
 +|-h| –host=HOSTNAME| database server host or socket directory|
 +|-U| –username=NAME| connect as specified database user|
 +|-W| –password| force password prompt (should happen automatically)|
 +|-d| –dbname=NAME |connect to database name|
 +|-v| –verbose| verbose mode|
 +|-F| –format=[c/t/p] |output file format (custom, tar, plain text)|
 +|-c| –clean| clean (drop) schema prior to create|
 +|-b| –blobs| include large objects in dump|
 +|-v| –verbose| verbose mode|
 +|-f| –file=FILENAME| output file name|
 +|-t| -table=TABLENAME | target table name|
  
 ===== Restore data with pg_restore ===== ===== Restore data with pg_restore =====
行 15: 行 30:
 eccube_db_user -d eccube_db -v "D:\backup\c_action.backup" eccube_db_user -d eccube_db -v "D:\backup\c_action.backup"
 </code> </code>
 +ここで、オプションの意味を次に示す。
 +^option^詳細^備考^
 +|-p| –port=PORT| database server port number|
 +|-i| –ignore-version| proceed even when server version mismatches|
 +|-h| –host=HOSTNAME| database server host or socket directory|
 +|-U| –username=NAME| connect as specified database user|
 +|-W| –password| force password prompt (should happen automatically)|
 +|-d| –dbname=NAME| connect to database name|
 +|-v| –verbose| verbose mode|
 +
 ===== reference ===== ===== reference =====
   - [[http://www.postgresql.jp/document/pg831doc/html/app-pgdump.html|pg_dump Manual]]   - [[http://www.postgresql.jp/document/pg831doc/html/app-pgdump.html|pg_dump Manual]]

QR Code
QR Code study:database:postgresql:backup (generated for current page)