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

On 31.08.2012 16:29, 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.

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

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

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...

Thanks

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

Ok, I will try that.

Thanks to all for the information.

Best Regards

José Santos