Some PostgreSQL commands like createdb, pg_restore, etc. works assuming the current user logged on the console (or system).<\/p>\n
This approach makes simple things;<\/p>\n
Unfortunately, many times, the current user doesn’t exist on the database, mainly when restoring legacy databases.
\nOn *Nix environment, it is used sudo command to become a postgres user.<\/p>\n
On Windows, better than trying to do this running runas<\/em> command is to create the Windows’ current user on the database. Note: the user must be created with privileges to create tables.<\/p>\n Follow the commands:<\/p>\n <\/p>\n <\/p>\n\n Your current user on Windows doesn’t let you perform a PostgreSQL’s command? Some PostgreSQL commands like createdb, pg_restore, etc. works assuming the current user logged on the console (or system). This approach makes simple things; Unfortunately, many times, the current user doesn’t exist on the database, mainly when restoring legacy databases. On *Nix environment, it … Read More “POSTGRESQL: RESTORING DATABASES WITH DIFFERENT USER FROM THE CURRENT WINDOWS USER”<\/span> »<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[17],"tags":[176,175,178,177],"class_list":["post-3264","post","type-post","status-publish","format-standard","hentry","category-database","tag-create-user","tag-postgresql","tag-restore-database","tag-windows"],"_links":{"self":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts\/3264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3264"}],"version-history":[{"count":3,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts\/3264\/revisions"}],"predecessor-version":[{"id":4156,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts\/3264\/revisions\/4156"}],"wp:attachment":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nThen, you first create the user then run the cmd.
\nIt is an easier approach.<\/p>\n
\npsql -Upostgres -W
\n\\password alsdias
\npass:postgres
\npsql -Upostgres -d getit < L:\\work\\dev\\devdb\\generic\\tests\\testone\\testone_pg\\dump\\pg_vmvd7b_getit_151213.dump<\/div>\n