Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Postgre phpbb3 install problem

[sachadmin]

Hello,

One of our domain is getting problem while installing Postgress phpbb3.

I got the following error while creating it on my phpbb3 installation.

"The database you have selected was not created in UNICODE or UTF8 encoding. Try installing with a database in UNICODE or UTF8 encoding."

When we try to login using "psql -U postgres -W" it doesn't work.

Please let us know what should we do to fix this issue.

Thank You

[mwatkins]

Create your database with a UTF8 encoding, either from the command line:

man createdb

Or from psql / via a sql script:

http://www.postgresql.org/docs/8.2/s...edatabase.html

[sachadmin]

Hello,

Thank you for your reply but

First we are not able to login by

"psql -U postgres -W"

we get "psql: FATAL: IDENT authentication failed for user "postgres""

this message

~ Sachin

[mwatkins]

Your login issue could be a number of things; perhaps you should speak to your provider if checking the following gets you no where.

1. Are you sure you have the right id/password? Error message suggests not.

2. Are you sure the Postgresql user on your system is named "postgres"? On my systems (FreeBSD) by default it is "pgsql". Check /etc/passwd and see.

A permitted user (a Postgresql 'superuser') on my systems can issue:

% psql -U pgsql postgres

And access using that ID. If you've not created roles for the user id you are logging in as, you'll need to do that.

3. man createuser

Your ID must at least have createdb privileges.

If you have root access to the box, use that to create a role for your application to use.