 | |
Problem with changins user
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: Problem with changins user -
12-29-2008
, 01:56 AM
|
The problem is, 'createuser' creates database accounts. You must use 'adduser' for the system user. Well, I know about that a that's why I've also create a system user. But even I've the system user "jonash" when I try: postgres:$ su jonash Password: and second later it appears: Password: incorrect password Why?  |
Now, before you hit that reply button, please stop, think and read:
Do you want a database user or an operating system user?
These two things are entirely different, there is no connection.
There is no sense in "also creating a system user", as you say above.
Do you want to connect to the database, create objects there and manipulate
them? Then you need a database user.
Forget about commands like "su" and "passwd", they are for OS users.
You will have to use a database client program to connect to the database,
for example "psql" which is already installed on your machine.
Consult the documentation for details.
Yours,
Laurenz Albe
#32
| |||
| |||
|
|
The problem is, 'createuser' creates database accounts. You must use 'adduser' for the system user. Well, I know about that a that's why I've also create a system user. But even I've the system user "jonash" when I try: postgres:$ su jonash Password: and second later it appears: Password: incorrect password Why? |
Now, before you hit that reply button, please stop, think and read:
Do you want a database user or an operating system user?
These two things are entirely different, there is no connection.
There is no sense in "also creating a system user", as you say above.
Do you want to connect to the database, create objects there and manipulate
them? Then you need a database user.
Forget about commands like "su" and "passwd", they are for OS users.
You will have to use a database client program to connect to the database,
for example "psql" which is already installed on your machine.
Consult the documentation for details.
Yours,
Laurenz Albe
#33
| |||
| |||
|
|
The problem is, 'createuser' creates database accounts. You must use 'adduser' for the system user. Well, I know about that a that's why I've also create a system user. But even I've the system user "jonash" when I try: postgres:$ su jonash Password: and second later it appears: Password: incorrect password Why? |
Now, before you hit that reply button, please stop, think and read:
Do you want a database user or an operating system user?
These two things are entirely different, there is no connection.
There is no sense in "also creating a system user", as you say above.
Do you want to connect to the database, create objects there and manipulate
them? Then you need a database user.
Forget about commands like "su" and "passwd", they are for OS users.
You will have to use a database client program to connect to the database,
for example "psql" which is already installed on your machine.
Consult the documentation for details.
Yours,
Laurenz Albe
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.