Installing Postgresql - HOWTO

[cPanelDavidG]

The last time I have installed postgres in a cpanel server was about 1 year ago. It gives me little problems with the WHM's pg_hba.conf autoconfig but I could find my own config with no problems.

Now I'm trying to install it in a new server and I noticed the same problem that Luke brought to this tread. Postgres is running, i can create new db users via cpanel intarface but I can't create new databases. It shows no error, but the database is not created.

In the Cpanel logs I found this:

ERROR: role "user" does not exist

Where "user" is the domain user.

UPDATE1:

I created a new account for tests and the error did not happen in this new account.
I'll try to reedit the old accounts limits and features to see if it works.

UPDATE2:
Editing account limits did not work.
When new accounts are created the error log shows "ERROR: role "user" already exists". Is there a way to update the old users or I'm missing some configuration that makes cpanel create the user's role before creating the database?

Just to eliminate any ambiguity on my part, you followed all the steps of the PostgreSQL installation mentioned on the OP of this thread (which is now also available at Installing PostgreSQL on your cPanel/WHM Server), including the Install Config and Change Password steps, and you are still encountering these issues?

[plague]

Hello,

Yes David, I followed step-by-step like 3 times to make sure I was not forgetting anything. In every try I found the same error.

I'm about to open a ticket. I just posted this data here to give more info about Luke's post and what i've already did.

[cPanelDavidG]

Hello,

Yes David, I followed step-by-step like 3 times to make sure I was not forgetting anything. In every try I found the same error.

I'm about to open a ticket. I just posted this data here to give more info about Luke's post and what i've already did.

I recommend contacting our technical analysts since that would be the swiftest way for us to determine why this isn't functioning. You can contact them at http://tickets.cpanel.net/submit

If you can PM me your ticket number once you submit the ticket so I can follow-up internally, that would be greatly appreciated.

[plague]

Hi

Sorry, I forgot to paste you the ticket ID. Jamyn, from cPanel support, replied with the solution:

Jamyn says:
August 26th, 2009 at 07:38 PM


Hi,

Sure, no problem. I think this will fix it. Ex:

# cd /var/cpanel/users && for x in *; do su -c "createuser -S -D -R $x" postgres; done

I believe the PostGres auth data was not updated during the install, so the (existing) users don't have permissions yet. I'm certain this is fixed in an upcoming build, but meanwhile sometimes it's necessary to re-apply PostGres permissions to existing users on PG install/reinstall. Thanks!

--
Jamyn Shanley, Analyst
cPanel of Texas, Inc.

[Kisty]

Hello.
I'm trying to install it the version 7.3.x or later.

It informs me to that if my Postgresql is an old version, I need to dump my databases to a file and restore them. May I know how to dump them to a file and restore afterwards?

I don't think Postgresql is installed on our server.

[Oldiesmann]

pg_dumpall > pg.out

Then when you want to import them again

psql -f db.out postgres

PostgreSQL is installed on your server or it wouldn't be prompting you to backup your databases first.

[cookiesunshinex]

I have installed PostGresSQL as per these instructions previously, but nobody on the server is using it.

I would like to uninstall it.

Does anyone have any simple instructions of how to do so, or maybe just at least prevent it from starting when the server starts.

[garrettp]

Hi

Sorry, I forgot to paste you the ticket ID. Jamyn, from cPanel support, replied with the solution:

Would just like to confirm that this bug is still present in 11.25 RELEASE. RUnning the loop given by cPanel fixes the issue with cPanel not creating PGSQL databases (no error) and the 'ERROR: role "user" doesn't exist' message in the error_log.

# cd /var/cpanel/users && for x in *; do su -c "createuser -S -D -R $x" postgres; done

[EWD]

Anyone know how to get the installer to install the latest version 8.3 instead of 7.4?

Thank you!

[khiltd]

Anyone know how to get the installer to install the latest version 8.3 instead of 7.4?

Thank you!

It's a whole lot more effort than it's worth. Installing it yourself behind cPanel's back will literally take minutes, and then you just need to make sure that it stays running--if you're on RedHat, ntsysv will do all that work for you.

[sirdopes]

I ran /scripts/installpostgres which installed 8.1.18. The cpanel icon is not showing for postgres and if you access the url manually, it shows "PostgreSQL version is not sufficient. Version . is not supported." I followed the instructions that I found on other sites, updated the /var/lib/pgsql/data/pg_hba.conf. I also ran the loop to create the roles for the users. Any ideas on what could be wrong?

http://1.1.1.1:2082/frontend/x3/psql/index.html

The error log shows the following information when I refresh the postgres page.

[2010-04-27 19:17:52 -0500] warn [postgres::updateprivs] Encountered error in postgres::updateprivs: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::listdbs] Encountered error in postgres::listdbs: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::number_of_dbs] Encountered error in postgres::number_of_dbs: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::number_of_users] Encountered error in postgres::number_of_users: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::listusers] Encountered error in postgres::listusers: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

[cPanelDon]

I ran /scripts/installpostgres which installed 8.1.18. The cpanel icon is not showing for postgres and if you access the url manually, it shows "PostgreSQL version is not sufficient. Version . is not supported." I followed the instructions that I found on other sites, updated the /var/lib/pgsql/data/pg_hba.conf. I also ran the loop to create the roles for the users. Any ideas on what could be wrong?

http://1.1.1.1:2082/frontend/x3/psql/index.html

The error log shows the following information when I refresh the postgres page.

[2010-04-27 19:17:52 -0500] warn [postgres::updateprivs] Encountered error in postgres::updateprivs: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::listdbs] Encountered error in postgres::listdbs: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::number_of_dbs] Encountered error in postgres::number_of_dbs: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::number_of_users] Encountered error in postgres::number_of_users: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Cpanel::AdminBin::adminrun(postgres) set error in context postgres
Cpanel::AdminBin::adminrun(postgres) set error in context postgres
[2010-04-27 19:17:52 -0500] warn [postgres::listusers] Encountered error in postgres::listusers: Error from postgres wrapper: PostgreSQL version is not sufficient. Version . is not supported.

Please verify the PostgreSQL installation integrity by performing all steps outlined in the following documentation:

• Installing PostgreSQL on your cPanel/WHM Server

[sirdopes]

Yes, I have followed all of the steps outlined on that page.

[cPanelDon]

Please verify the PostgreSQL installation integrity by performing all steps outlined in the following documentation:

• Installing PostgreSQL on your cPanel/WHM Server

Yes, I have followed all of the steps outlined on that page.

In that case, please escalate the issue via a support request so that we may assist with investigation to determine what potentially unknown circumstances may be involved that triggered the described difficulty. When available, please let me know your ticket ID number so that I may follow-up internally. Thank you!

[erick_paper]

Hi. Cpanel installation is nice and easy, but it installs some crappy archaic version of PG, while PG has made many strides towards being an enterprise class, and FAST database. What's up? Is there any easy way to install PG 8.4?