Template:SQWareProduction sqwpg RestoreDatabase.ksh help: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
No edit summary |
||
(21 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
Sourcing sqwpg_Global.lib | Sourcing sqwpg_Global.lib v2025.06 SQWareProduction for PostgreSQL (dbSQWare) ... | ||
Usage: sqwpg_RestoreDatabase.ksh [[-h]] -I instance -DT <DatabaseTarget> [[+ options]] | Usage: sqwpg_RestoreDatabase.ksh [[-h]] -I instance -DT <DatabaseTarget> [[+ options]] | ||
Line 7: | Line 7: | ||
sqwpg_RestoreDatabase.ksh restore $lvsqw_CopyType | sqwpg_RestoreDatabase.ksh restore $lvsqw_CopyType | ||
SUPPORT | SUPPORT | ||
PostgreSQL supported versions: 9.0 <= v <= | PostgreSQL supported versions: 9.0 <= v <= 17 | ||
PARAMETERS | PARAMETERS | ||
Line 13: | Line 13: | ||
-DT DatabaseTarget : Target database. | -DT DatabaseTarget : Target database. | ||
OPTIONS | OPTIONS | ||
-h | -h : Display the full usage. | ||
-s : Display samples of usage. | -s : Display samples of usage. | ||
-F file : Dump file to restore (default take the latest). | -F file : Dump file to restore (by default take the latest). | ||
-DS DatabaseSource : Source database (by default same than -DT). | -DS DatabaseSource : Source database (by default same than -DT). | ||
-DD date_dump : Dump date to restore (default take the latest). | -DD date_dump : Dump date to restore (by default take the latest). | ||
-RD directory : Directory holding dump file (default /pgbackup/$PG_SID). | -RD directory : Directory holding dump file (by default /pgbackup/$PG_SID). | ||
-Drop : Drop database before load (by default, Enable). | -Drop : Drop database before load (by default, Enable). | ||
-NoMail : Deactivate sendmail on error | -NoMail : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error). | ||
-NoDrop : Do not drop database before load, drop all objects instead (by default, Enable). | -NoDrop : Do not drop database before load, drop all objects instead (by default, Enable). | ||
-Create : Create database before load with instance default character set (by default, Enable). | -Create : Create database before load with instance default character set (by default, Enable). | ||
-Verbose : Add --echo-queries option to psql cmd when restore. | -Verbose : Add --echo-queries option to psql cmd when restore. | ||
-NoCreate : No create database before load, must exists (by default, Enable). | -NoCreate : No create database before load, must exists (by default, Enable). | ||
-AddMail email | -AddMail email : Email address to add at 'demo-sqwarebox@dbsqware.com'. | ||
-SendReport : Send execution log report. | -SendReport : Send execution log report. | ||
-Locale | -Locale locale : Force Locale for help display (fr,en). | ||
-FRT | -FRT code : Force return code value on error. | ||
-Exec : Restore (default, display generated commands). | -Exec : Restore (by default, display generated commands). | ||
</pre> | </pre> |
Latest revision as of 18:53, 1 July 2025
Sourcing sqwpg_Global.lib v2025.06 SQWareProduction for PostgreSQL (dbSQWare) ... Usage: sqwpg_RestoreDatabase.ksh [[-h]] -I instance -DT <DatabaseTarget> [[+ options]] DESCRIPTION sqwpg_RestoreDatabase.ksh restore $lvsqw_CopyType SUPPORT PostgreSQL supported versions: 9.0 <= v <= 17 PARAMETERS -I instance : Target instance to restore. -DT DatabaseTarget : Target database. OPTIONS -h : Display the full usage. -s : Display samples of usage. -F file : Dump file to restore (by default take the latest). -DS DatabaseSource : Source database (by default same than -DT). -DD date_dump : Dump date to restore (by default take the latest). -RD directory : Directory holding dump file (by default /pgbackup/$PG_SID). -Drop : Drop database before load (by default, Enable). -NoMail : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error). -NoDrop : Do not drop database before load, drop all objects instead (by default, Enable). -Create : Create database before load with instance default character set (by default, Enable). -Verbose : Add --echo-queries option to psql cmd when restore. -NoCreate : No create database before load, must exists (by default, Enable). -AddMail email : Email address to add at 'demo-sqwarebox@dbsqware.com'. -SendReport : Send execution log report. -Locale locale : Force Locale for help display (fr,en). -FRT code : Force return code value on error. -Exec : Restore (by default, display generated commands).