I know its been a long time I have not write anything. because I have not learn or done any new things. I dont want to write regular meaningless blogs here. anyway today I tried to restore a pg_dump out file to another postgresql server.
that pg_restore looks nice but in first try it started print lines of the file that was strange. at the end I learned that if we give the name of the database it will restore data to there. otherwise it works like scanner for a dump file.
here is the command: pg_restore -d dbName backupFileName
after that it does not print anything to stdout just starts restoring the data. if anyone knows how to show which table is being restored in that time that would be nice. because now I am cleaning some useless data with pgadmin manually.
Subscribe to:
Post Comments (Atom)
odd string diff
https://leetcode.com/problems/odd-string-difference/ Beats 19.92% of users with Java class Solution { public String oddString ( S...
-
bu durum sessionun uzun ömürlü olmasını istediğinizde yapacağınız bişeydir ki Session["eblek"]="gobalak"; dediğimizde ve...
-
at the end of any product there will be a reporting interfaces for counts. let say you build a advertisement site which gives people to publ...
-
in java web application you can easily set 400 and 500 error pages via web.xml like this <error-page> <error-code>50...
No comments:
Post a Comment