Thread: Postgresql Error ask for password

On 08/31/2012 07:29 AM, José Pedro Santos wrote:
> Dear all,
>
> Im trying to install one application in my Linux but when I try to use
> the expression SU postgresql it ask for password, what is the password?
> I try my root password but dont work.

More information is needed.

What variety of Linux are you using and what version?

How did you install Postgres?:
 From source
Using package manager
Using one click installer.



>
> Thanks for your time
>
> Ciao
> Jose Santos


--
Adrian Klaver
adrian.klaver@gmail.com

Dear all,

Im trying to install one application in my Linux but when I try to use the expression SU postgresql it ask for password, what is the password? I try my root password but dont work.

Sorry, you are a bit terse on the context of this.

Basically, there might not be a "true" password for user postgresql (if your installation is even using that user id, most use "postgres" or "pgsql")
If you are in the process of installing some application and that requests you to enter "su postgresql", than likely this procedure is expecting
you being root. Then su will succeed (if user is known at all - see above). Nevertheless, most distributions of Linux would prefer you to
do a variant of "sudo" and avoid "su" completely. So, if you are running all this as a different user (and not happen to be "postgresql" user already),
become root and proceed with "su" as told.

However, may be you step back and try to make sense out of what you are supposed to do identify (and overcome) those inaccuracies, that seem
to exists with your instructions.

Or are you just poking around based on experience that do not perfectly fit with the current environment?


The symptoms you depict match a variety of causes (and problems),
thus it really is difficult to give proper advice....

Rainer

Thanks for your time

Ciao
Jose Santos

Pedro Santos wrote:
> Im trying to install one application in my Linux but when I try to use the expression SU postgresql it
> ask for password, what is the password? I try my root password but dont work.

It may be that you never set that password.

Try "grep postgresql /etc/shadow" as root user.
If the second field is "!!", there is no password set.

You can either become root first, then you need no password
for "su postgresql", or you have to set a password.

You can change the password as user root with
"passwd postgresql".

Yours,
Laurenz Albe

On 08/31/2012 08:03 AM, José Pedro Santos wrote:
> I install the FGS distribution of MapServer, after, the plugin Postgres
> - Server. When I go to root and put in bash SU also ask for password...


Here is an answer from the FGS mailing list:

http://lists.maptools.org/pipermail/foss-gis-suite/2010-February/000893.html

For future reference the mailing list is:

http://lists.maptools.org/mailman/listinfo/foss-gis-suite/

>
> Thanks
>
>


--
Adrian Klaver
adrian.klaver@gmail.com