?
Solved

POSTGRESQL on Solaris 10 database credentials

Posted on 2010-08-13
2
Medium Priority
?
848 Views
Last Modified: 2013-12-27
Hey guys,
               Ive been trying to install follow Sun's official guide of ''How to Configure and Run POSTGRESQL on Solaris 10'', found as one of the Solaris 10 How To Guides. There is a part that asks me to create a user called ''postgres'' and assign it to the ''postgres'' group with the use of the following commands
--------------------------------------
# groupadd postgres
#useradd -c 'PostgreSQL User' -d /export/home/postgres -g postgres -m -s /bin/bash postgres
--------------------------------------
Im actually trying to install Numara Footprints 9 which uses postgresql. Somewhere in the installation, foorprints asks me to supply the postgres username and password..trouble is, I dont know the password. I have tried 'postgres' as the password but it fails. However, I have been able to connect to the database and execute sql commands under the user 'postgres'. When I switch to user 'postgres' they dont ask for the password. It just goes.

There are three possibilities:
1)I want to believe that the user ''postgres'' may have already existed since the solaris 10 installation already comes with Postgresql preloaded. But I cant figure out, or change the password, since I dont know the old one. In addition, in the SMC, I can't see the 'postgres' user listed. However, I can switch user to 'postgres' in the terminal. If i try to change the password of postgres, they ask me for the password..and i dont have that.

2)In my sleepiness, I added the wrong password when I typed the command above.

3)The password is actually null/blank. However, Footprints asks that a password must be entered to connect to the database, I cant leave the password field blank during installation.

Can anyone figure out or suggest what can I do next? Many thanks!
0
Comment
Question by:kajun989
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Expert Comment

by:gsosna
ID: 33434989
kajun989, do you have root access to this machine? If yes, try changing the password for the postgres user when you're logged in as root.
$ passwd postgres
if you're root, then you don't have to enter the current password for any user.
0
 
LVL 12

Accepted Solution

by:
cminear earned 1000 total points
ID: 33437192
gsosna's comment would set the Unix password for the 'postgres' user.  However I believe Footprints is expecting the _database_ password for the 'postgres' user.  You set the database password using either ALTER USER within 'psql' (see http://www.postgresql.org/docs/8.1/interactive/sql-alteruser.html).

The reason you can connect to the database without a password is because by default connections using the local Unix sockets do not require a password; they are trusted.  Read about the 'pg_hba.conf' here: http://www.postgresql.org/docs/8.1/interactive/client-authentication.html#AUTH-PG-HBA-CONF
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you do backups in the Solaris Operating System, the file system must be inactive. Otherwise, the output may be inconsistent. A file system is inactive when it's unmounted or it's write-locked by the operating system. Although the fssnap utility…
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month8 days, 22 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question