Postgres SQL configuration

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

amitabhandari1

Hi,

What's the default superuser username/password for postgres after a new installation in alfresco.
I am not able to create any database.Through PGadmin I came to know only SYSTEM user has  privilege to create database.What is the password for system user.

Thanks

linuxyeti

Hi

This is an easy solution.

In the PGDATA directory, by default on RHEL, /var/lib/pgsql/9.x/data (Where x is the minor version.

Edit the following file

pg_hba.conf

amend the line for local accordingly :-

local   all             all                                     trust

Restart or reload postgres

Log into postgres using psql -U postgres

At the prompt type

ALTER USER postgres PASSWORD 'newpassword';

exit out of postgres \q

You can reset the pg_hba.conf , if you prefer.

Now the postgres superuser user (postgres) has the password of newpassword

Cheers

Tony