"Dave Page" <dpage@vale-housing.co.uk> writes:
> killed it this morning (after 6+ hours of runtime) and it reported:
> pg_regress: could not set database default locales
That would be here:
"$bindir/psql" -q -X $psql_options -c "\
alter database \"$dbname\" set lc_messages to 'C';
alter database \"$dbname\" set lc_monetary to 'C';
alter database \"$dbname\" set lc_numeric to 'C';
alter database \"$dbname\" set lc_time to 'C';" "$dbname"
if [ $? -ne 0 ]; then echo "$me: could not set database default locales" (exit 2); exit
fi
Could you gdb the attached backend and see what it's doing? Is it
actually consuming CPU, or just stuck?
regards, tom lane