Why am I getting an ERROR while using WITH statement in psql cli?psql: FATAL: Ident authentication failed for user “postgres”Drop PostgreSQL database through command lineHow to do an update + join in PostgreSQL?Run a PostgreSQL .sql file using command line arguments“use database_name” command in PostgreSQLPostgres could not connect to serverpsql: FATAL: role “postgres” does not existpsql: FATAL: database “<user>” does not existGetting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails`pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)
Threading data on TimeSeries
Does PC weight have a mechanical effect?
Approach sick days in feedback meeting
Leveling up and Getting Items!
For Saintsbury, which English novelists constituted the "great quartet of the mid-eighteenth century"?
How do credit card companies know what type of business I'm paying for?
How to remove multiple elements from Set/Map AND knowing which ones were removed?
Is it possible to install Firefox on Ubuntu with no desktop enviroment?
Will users know a CardView is clickable
How to address players struggling with simple controls?
Arcane Tradition and Cost Efficiency: Learn spells on level-up, or learn them from scrolls/spellbooks?
What did the 8086 (and 8088) do upon encountering an illegal instruction?
Does WiFi affect the quality of images downloaded from the internet?
How many possible starting positions are uniquely solvable for a nonogram puzzle?
Does anyone recognize these rockets, and their location?
How long would it take for sucrose to undergo hydrolysis in boiling water?
Bullying by school - Submitted PhD thesis but not allowed to proceed to viva until change to new supervisor
Can an escape pod land on Earth from orbit and not be immediately detected?
Fastest path on a snakes and ladders board
Can Dive Down protect a creature against Pacifism?
What is the difference between state-based effects and effects on the stack?
Someone who is granted access to information but not expected to read it
How did Avada Kedavra get its name?
Was the Lonely Mountain, where Smaug lived, a volcano?
Why am I getting an ERROR while using WITH statement in psql cli?
psql: FATAL: Ident authentication failed for user “postgres”Drop PostgreSQL database through command lineHow to do an update + join in PostgreSQL?Run a PostgreSQL .sql file using command line arguments“use database_name” command in PostgreSQLPostgres could not connect to serverpsql: FATAL: role “postgres” does not existpsql: FATAL: database “<user>” does not existGetting error: Peer authentication failed for user “postgres”, when trying to get pgsql working with rails`pg_tblspc` missing after installation of latest version of OS X (Yosemite or El Capitan)
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I'm trying to create a new user to user and database using postgresql.
sudo su postgres -c "psql -c "CREATE USER $db_user WITH PASSWORD '$db_pass'""
ERROR: syntax error at or near "with"
LINE 1: CREATE USER with PASSWORD ''
linux postgresql
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
add a comment |
I'm trying to create a new user to user and database using postgresql.
sudo su postgres -c "psql -c "CREATE USER $db_user WITH PASSWORD '$db_pass'""
ERROR: syntax error at or near "with"
LINE 1: CREATE USER with PASSWORD ''
linux postgresql
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
add a comment |
I'm trying to create a new user to user and database using postgresql.
sudo su postgres -c "psql -c "CREATE USER $db_user WITH PASSWORD '$db_pass'""
ERROR: syntax error at or near "with"
LINE 1: CREATE USER with PASSWORD ''
linux postgresql
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
I'm trying to create a new user to user and database using postgresql.
sudo su postgres -c "psql -c "CREATE USER $db_user WITH PASSWORD '$db_pass'""
ERROR: syntax error at or near "with"
LINE 1: CREATE USER with PASSWORD ''
linux postgresql
linux postgresql
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
edited Mar 25 at 6:34
a_horse_with_no_name
317k49482589
317k49482589
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
asked Mar 25 at 2:46
Sujay ReddySujay Reddy
62
62
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
In Postgres, CREATE USER command does not use WITH keyword when assigning password.
sudo su postgres -c "psql -c "CREATE USER $db_user PASSWORD '$db_pass'""
Or you can use createuser command to create the user.
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55330645%2fwhy-am-i-getting-an-error-while-using-with-statement-in-psql-cli%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In Postgres, CREATE USER command does not use WITH keyword when assigning password.
sudo su postgres -c "psql -c "CREATE USER $db_user PASSWORD '$db_pass'""
Or you can use createuser command to create the user.
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
add a comment |
In Postgres, CREATE USER command does not use WITH keyword when assigning password.
sudo su postgres -c "psql -c "CREATE USER $db_user PASSWORD '$db_pass'""
Or you can use createuser command to create the user.
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
add a comment |
In Postgres, CREATE USER command does not use WITH keyword when assigning password.
sudo su postgres -c "psql -c "CREATE USER $db_user PASSWORD '$db_pass'""
Or you can use createuser command to create the user.
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
In Postgres, CREATE USER command does not use WITH keyword when assigning password.
sudo su postgres -c "psql -c "CREATE USER $db_user PASSWORD '$db_pass'""
Or you can use createuser command to create the user.
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
answered Mar 25 at 6:18
C.C. HsuC.C. Hsu
511
511
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55330645%2fwhy-am-i-getting-an-error-while-using-with-statement-in-psql-cli%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
