dbTalk Databases Forums  

Problem with changins user

comp.databases.postgresql comp.databases.postgresql


Discuss Problem with changins user in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Obserwator
 
Posts: n/a

Default Problem with changins user - 12-25-2008 , 05:28 PM






Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash

but when I try to switch on him by:

su jonash

The info appears:
Unknown ID: jonash

Where is the problem?

Best regards!



Reply With Quote
  #2  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM






Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #3  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #4  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #5  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #6  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #7  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #8  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #9  
Old   
Roland Walter
 
Posts: n/a

Default Re: Problem with changins user - 12-25-2008 , 10:48 PM



Obserwator wrote:

Quote:
Hello!

I'm new in this group and I would like to solve one problem.

I've just installed on my Debian machine PostgreSQL from source files.
Everything was compiled correctly etc. Now when I'm logged in as
Postgres user i create a new one:

createuser jonash
This creates only a database user, not a system user.

That means, jonash is a user you might use to connect to the database, but
not to log into your system.

Quote:
but when I try to switch on him by:

su jonash


Where is the problem?

The problem is, 'createuser' creates database accounts. You must use
'adduser' for the system user.

Regards,

Roland.

--
Dipl.-Phys. Roland Walter
mailto: roland (dot) walter (dot) rwa (at) gmx (dot) net



Reply With Quote
  #10  
Old   
Obserwator
 
Posts: n/a

Default Re: Problem with changins user - 12-26-2008 , 04:05 AM



Quote:
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?




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.