Postgres SQL configuration

amitabhandari1 — Thu, 20 Nov 2014 06:33:37 GMT

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

Re: Postgres SQL configuration

linuxyeti — Fri, 21 Nov 2014 07:48:49 GMT

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

topic Postgres SQL configuration in Alfresco Archive

Postgres SQL configuration

Re: Postgres SQL configuration