Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

psql restore from tar

-c to clean the database
-U to force a user
-d to select the database
-v verbose mode, don't know why
"$$" the location of the files to import in tmp to get around permission issues
-W to force asking for the password to the user (postgres)
Source by serverfault.com #
 
PREVIOUS NEXT
Tagged: #psql #restore #tar
ADD COMMENT
Topic
Name
5+7 =