Postgresql import user from linuxHow do I install pgcrypto in PostgreSQL 8.4?Created user can access all...
Does grappling negate Mirror Image?
Is this part of the description of the Archfey warlock's Misty Escape feature redundant?
What fields between the rationals and the reals allow a good notion of 2D distance?
What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?
What (the heck) is a Super Worm Equinox Moon?
Change the color of a single dot in `ddot` symbol
What is the English pronunciation of "pain au chocolat"?
How much theory knowledge is actually used while playing?
Taxes on Dividends in a Roth IRA
"It doesn't matter" or "it won't matter"?
Non-trope happy ending?
15% tax on $7.5k earnings. Is that right?
Make a Bowl of Alphabet Soup
Which was the first story featuring espers?
When were female captains banned from Starfleet?
Is there a nicer/politer/more positive alternative for "negates"?
What is Cash Advance APR?
Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?
How to preserve electronics (computers, iPads and phones) for hundreds of years
How to get directions in deep space?
Why do ¬, ∀ and ∃ have the same precedence?
What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?
What does "Scientists rise up against statistical significance" mean? (Comment in Nature)
Delete multiple columns using awk or sed
Postgresql import user from linux
How do I install pgcrypto in PostgreSQL 8.4?Created user can access all databases in PostgreSQL without any grantsPostgreSQL user can not connect to server after changing passwordPostgreSQL newbie - how to create objects in a databaseChoosing A PostgreSQL Authentication Method For A Large CourseCreate new user without typing current user passwordPostgreSQL vagrant VM cannot create extensionPostgresql - Map a Linux user to loginMariaDB multiple auth modules for a user?Install Only Pgbench and Not PostgreSQL Server
I install postgresql 9.2 on a Ubuntu 12.10 machine
I tried to import linux's user to postgresql
but only way I can figure out is
CREATE USER Jack WITH PASSWORD '1234';
and do it 10 times (if there are 10 users)!!
Is there any faster way to do it?
postgresql authentication
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I install postgresql 9.2 on a Ubuntu 12.10 machine
I tried to import linux's user to postgresql
but only way I can figure out is
CREATE USER Jack WITH PASSWORD '1234';
and do it 10 times (if there are 10 users)!!
Is there any faster way to do it?
postgresql authentication
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
OS authentication?
– Vérace
Jun 4 '14 at 7:11
Just like users can use ubuntu's account to access postgresql database
– blueman010112
Jun 4 '14 at 7:21
Take a look here. You may also simply script 1..n users (all same password) and force a change on logging on see here
– Vérace
Jun 4 '14 at 8:16
Is there any way to force same password and username in ubuntu and postgres? I don't want make them to change their password again
– blueman010112
Jun 5 '14 at 1:36
1
But that's the whole point about OS authentication - the same process works for both.
– Vérace
Jun 5 '14 at 8:10
add a comment |
I install postgresql 9.2 on a Ubuntu 12.10 machine
I tried to import linux's user to postgresql
but only way I can figure out is
CREATE USER Jack WITH PASSWORD '1234';
and do it 10 times (if there are 10 users)!!
Is there any faster way to do it?
postgresql authentication
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
I install postgresql 9.2 on a Ubuntu 12.10 machine
I tried to import linux's user to postgresql
but only way I can figure out is
CREATE USER Jack WITH PASSWORD '1234';
and do it 10 times (if there are 10 users)!!
Is there any faster way to do it?
postgresql authentication
postgresql authentication
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
edited Jun 4 '14 at 7:14
Colin 't Hart
6,61682634
6,61682634
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
asked Jun 4 '14 at 5:54
blueman010112blueman010112
5216
5216
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
OS authentication?
– Vérace
Jun 4 '14 at 7:11
Just like users can use ubuntu's account to access postgresql database
– blueman010112
Jun 4 '14 at 7:21
Take a look here. You may also simply script 1..n users (all same password) and force a change on logging on see here
– Vérace
Jun 4 '14 at 8:16
Is there any way to force same password and username in ubuntu and postgres? I don't want make them to change their password again
– blueman010112
Jun 5 '14 at 1:36
1
But that's the whole point about OS authentication - the same process works for both.
– Vérace
Jun 5 '14 at 8:10
add a comment |
OS authentication?
– Vérace
Jun 4 '14 at 7:11
Just like users can use ubuntu's account to access postgresql database
– blueman010112
Jun 4 '14 at 7:21
Take a look here. You may also simply script 1..n users (all same password) and force a change on logging on see here
– Vérace
Jun 4 '14 at 8:16
Is there any way to force same password and username in ubuntu and postgres? I don't want make them to change their password again
– blueman010112
Jun 5 '14 at 1:36
1
But that's the whole point about OS authentication - the same process works for both.
– Vérace
Jun 5 '14 at 8:10
OS authentication?
– Vérace
Jun 4 '14 at 7:11
OS authentication?
– Vérace
Jun 4 '14 at 7:11
Just like users can use ubuntu's account to access postgresql database
– blueman010112
Jun 4 '14 at 7:21
Just like users can use ubuntu's account to access postgresql database
– blueman010112
Jun 4 '14 at 7:21
Take a look here. You may also simply script 1..n users (all same password) and force a change on logging on see here
– Vérace
Jun 4 '14 at 8:16
Take a look here. You may also simply script 1..n users (all same password) and force a change on logging on see here
– Vérace
Jun 4 '14 at 8:16
Is there any way to force same password and username in ubuntu and postgres? I don't want make them to change their password again
– blueman010112
Jun 5 '14 at 1:36
Is there any way to force same password and username in ubuntu and postgres? I don't want make them to change their password again
– blueman010112
Jun 5 '14 at 1:36
1
1
But that's the whole point about OS authentication - the same process works for both.
– Vérace
Jun 5 '14 at 8:10
But that's the whole point about OS authentication - the same process works for both.
– Vérace
Jun 5 '14 at 8:10
add a comment |
1 Answer
1
active
oldest
votes
Why don't you try doing it from webmin. If you install the PostgreSQL module, under the postgres users section there is an option Add a new PostgreSQL user when a Unix user is added.
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f66520%2fpostgresql-import-user-from-linux%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
Why don't you try doing it from webmin. If you install the PostgreSQL module, under the postgres users section there is an option Add a new PostgreSQL user when a Unix user is added.
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
add a comment |
Why don't you try doing it from webmin. If you install the PostgreSQL module, under the postgres users section there is an option Add a new PostgreSQL user when a Unix user is added.
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
add a comment |
Why don't you try doing it from webmin. If you install the PostgreSQL module, under the postgres users section there is an option Add a new PostgreSQL user when a Unix user is added.
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
Why don't you try doing it from webmin. If you install the PostgreSQL module, under the postgres users section there is an option Add a new PostgreSQL user when a Unix user is added.
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
answered May 24 '15 at 18:38
Fabrizio MazzoniFabrizio Mazzoni
1,16221225
1,16221225
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f66520%2fpostgresql-import-user-from-linux%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
OS authentication?
– Vérace
Jun 4 '14 at 7:11
Just like users can use ubuntu's account to access postgresql database
– blueman010112
Jun 4 '14 at 7:21
Take a look here. You may also simply script 1..n users (all same password) and force a change on logging on see here
– Vérace
Jun 4 '14 at 8:16
Is there any way to force same password and username in ubuntu and postgres? I don't want make them to change their password again
– blueman010112
Jun 5 '14 at 1:36
1
But that's the whole point about OS authentication - the same process works for both.
– Vérace
Jun 5 '14 at 8:10