change postgres password during first start

[hregis]

Hi,

have you a script or procedure for change/defined the password of "postgres" (admin postgresql) during the first start of appliance ?

Thanks
Régis

 

[hregis]

hi, thanks for your response,
in fact it is the application that creates the user and the database should be just that I can change the password of postgres. I almost found it, I'll keep you informed.
Régis
www.dolibarr.org

 

[hregis]

hi,

i found this solution, had this in Makefile:

dab task postgres --version=8.4
install -m 0755 pgsql_setup ${BASEDIR}/tmp/pgsql_setup
install -m 0755 pgsql_passwd ${BASEDIR}/tmp/pgsql_pwd
dab task postgres --start
dab exec /tmp/pgsql_setup
rm -f ${BASEDIR}/tmp/pgsql_setup

the content of "pgsql_setup"

#!/bin/sh

# change postgres password
su - postgres -c "/tmp/pgsql_pwd"
rm -f /tmp/pgsql_pwd

the content of "pgsql_pwd"

#!/bin/bash

psql -c "ALTER USER postgres WITH PASSWORD 'password'" -d template1

same password for all templates, but my application create a new user/pwd with the new database.

its possible to use this function to create aleatory password with no specific caracters:

# Generate a random password
#  $1 = number of characters; defaults to 32
#  $2 = include special characters; 1 = yes, 0 = no; defaults to 1
function randpass() {
  [ "$2" == "0" ] && CHAR="[:alnum:]" || CHAR="[:graph:]"
    cat /dev/urandom | tr -cd "$CHAR" | head -c ${1:-32}
    echo
}

# create random password
PASSDBADMIN=`randpass 12 0`