On Sun, 4 Sep 2016, Adrian Klaver wrote:
> But the message you sent me offlist showed the 9.5 instance running.
But now it's not running.
> How are you starting the instance?
As superuser poostgres: pg_ctl start -D /var/lib/pgsql/data &
After removing an orphaned postmaster.pid the above seemed to have started
postgres, but there's no postmaster process running.
> Are you sure that the password being asked for is not for the OS user you are
> using to run whatever start script you are using?
Thinking postmaster is running I tried this:
$ psql crm
Password:
FATAL: password authentication failed for user "rshepard"
DETAIL: User "rshepard" has no password assigned.
Connection matched pg_hba.conf line 80: "local all all
md5"
psql: FATAL: password authentication failed for user "rshepard"
The crm database is owned by me.
> I have never used it, but I am pretty sure that is not what -W means. It
> looks to me that it asks you to create a password at init for the database
> superuser(in this case postgres) and only that user when that user tries
> to use log into a database after the cluster is started.
From man initdb:
-W, --pwprompt
Makes initdb prompt for a password to give the database superuser.
If you don't plan on using password authentication, this is not
important. Otherwise you won't be able to use password
authentication until you have a password set up.
The superuser already exists in /etc/passwd.
> Do you remember what password you specified?
Yes. It's the same password I use for logging in as a user. If it's the
superuser password being requested, then that's the same as my user
password.
The Slackware rc.postgresql file for 9.5 has changed from 9.3 and earlier.
It's asking for passwords:
if [ ! -e $DATADIR/PG_VERSION ]; then
echo "You should initialize the PostgreSQL database
at location $DATADIR"
echo "e.g. su postgres -c \"initdb -D $DATADIR
--locale=en_US.UTF-8 -A md5 -W\""
exit 6
fi
Note the '-W' at the end. But, I ran initdb from the command line as user
postgres.
Rich