差分
このページの2つのバージョン間の差分を表示します。
| 両方とも前のリビジョン前のリビジョン次のリビジョン | 前のリビジョン | ||
| study:database:postgresql:backup [2010/05/17 15:36] – banana | study:database:postgresql:backup [2010/07/02 07:26] (現在) – banana | ||
|---|---|---|---|
| 行 17: | 行 17: | ||
| |-d| –dbname=NAME |connect to database name| | |-d| –dbname=NAME |connect to database name| | ||
| |-v| –verbose| verbose mode| | |-v| –verbose| verbose mode| | ||
| - | |-F| –format=c|t|p |output file format (custom, tar, plain text)| | + | |-F| –format=[c/t/p] |output file format (custom, tar, plain text)| |
| |-c| –clean| clean (drop) schema prior to create| | |-c| –clean| clean (drop) schema prior to create| | ||
| |-b| –blobs| include large objects in dump| | |-b| –blobs| include large objects in dump| | ||
| |-v| –verbose| verbose mode| | |-v| –verbose| verbose mode| | ||
| |-f| –file=FILENAME| output file name| | |-f| –file=FILENAME| output file name| | ||
| + | |-t| -table=TABLENAME | target table name| | ||
| ===== Restore data with pg_restore ===== | ===== Restore data with pg_restore ===== | ||
| 行 29: | 行 30: | ||
| eccube_db_user -d eccube_db -v " | eccube_db_user -d eccube_db -v " | ||
| </ | </ | ||
| + | ここで、オプションの意味を次に示す。 | ||
| + | ^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:// | - [[http:// | ||
