Installing Postgresql - HOWTO

[saadahmed007]

Installed postgresql works fine but i canot find the option to delete the database..

[vqubbes]

Hai.. yes i got it

[IRCBrasil]

Should I first compile apache with Postgresql and after /scripts/installpostgres? or first /scripts/installpostgres ? or there are no order necessary ?

thanks

[rocketlot]

I,ve been following the instruction for install postgres. Can u help my how-to uninstall it? I use WHM on FREE-BSD based.
Thanks.

cPanel requires Postgresql 7.3.x or later. 7.2.x will not work.

===========================================
Step 1
===========================================
Upgrade to cPanel 7.4.0 build 45 or later
===========================================

===========================================
Step 1a (If you do not have 7.2.x or earlier installed skip this step)
===========================================
Login to a root shell via ssh or the console.

If you have Postgres 7.2.x installed, backup your databases using pg_dumpall or some other method.

Move the postgres data directory somewhere else. ie

mv /var/lib/pgsql /var/lib/pgsql.old
===========================================


===========================================
Step 2
===========================================
Login to a root shell via ssh or the console and run

/scripts/installpostgres
===========================================

===========================================
Step 2a (skip this step if you are not upgrading from postgres 7.2 or earlier
===========================================
Restore your sql dump created with pg_dumpall or by some other method using psql or some other method
===========================================


===========================================
Step 3
===========================================
Login to Web Host Manager and choose "Postgres Config" under Server Setup.

Set a postgres password to anything of your choosing. You should avoid using any non-alpha numeric charaters as these cause problems.
===========================================


===========================================
Step 4
===========================================
Use the "Postgres Config" option in WHM to install a postgres pg_hba.conf file. You can skip this step if you would like to setup your pg_hba.conf file manually. cPanel should work fine with md5 passwords or plaintext passwords
===========================================


===========================================
Step 5
===========================================
Login to cPanel and click on Postgres .. Enjoy!
===========================================

cPanel.net Support Ticket Number:

[esserdk]

thank you SO much for this guide!

Eskild Schroll-Fleischer

[Shannon17]

i get this in my cpbackup

Grabbing PostgreSQL databases............
psql: FATAL: Password authentication failed for user "postgres"
psql: FATAL: Password authentication failed for user "postgres"
Done
Grabbing PostgreSQL privileges...psql: FATAL: Password authentication failed for user "postgres"
psql: FATAL: Password authentication failed for user "postgres"
Done

can someone help me?

[albatroz]

I got Postgresql installed and also run the Config part at WHM.
However I don´t see Postgresql options at Cpanel, only MySQL.
Anyway Cpanel reports an installed Postgresql version in the
info box.

[hikaro]

Just installed through WHM, but cant add databases or users through Cpanel. Just says database added, no user found... and still, no database is added. Runnin latest current.

Hi,
so anyone fix this problem?

[hikaro]

problem fixed

[tecservers]

Hi

i have serius problem whit postgresql, when i create a datebase(postgresql) in cpanel dont show any datebase, or i try add user for adduser to any datebase in prosgresql again dont show any,

In WHM when i make a posgresql config say this message

Install Postgres Config
Setting up Postgres Config...You are running an old unsupported postgresql version.
cPanel only supports postgres 7.3.x or better.

but in th pass dot show this message,

# psql --version
psql: symbol lookup error: psql: undefined symbol: get_progname

I need erase any version of posgresql and clean any installation and then reinstall posgresql whit build apache in whm,

I try this in WHM Build APACHE

-----------------
This script will install Postgres 7.3.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.3.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.3.x style setup. Do not do this if
you have databases that you wish to keep!

Are you sure you wish to proceed?
Fetching Obsoletes list for channel: rhel-i386-es-4...

Fetching Obsoletes list for channel: rhel-i386-es-4-extras...

Fetching rpm headers...

Name Version Rel
----------------------------------------------------------


The following packages you requested were not found:
rh-postgresql
rh-postgresql-devel
rh-postgresql-libs
rh-postgresql-server

The following packages you requested are already updated:
postgresql
postgresql-devel
postgresql-libs
postgresql-server
Stopping postgresql service: [ OK ]
Starting postgresql service: [ OK ]
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!

----- But dont work -----

and i try this option in shell

# /scripts/installpostgres
This script will install Postgres 7.3.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.3.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.3.x style setup. Do not do this if
you have databases that you wish to keep!

Are you sure you wish to proceed? y

Fetching Obsoletes list for channel: rhel-i386-es-4...

Fetching Obsoletes list for channel: rhel-i386-es-4-extras...

Fetching rpm headers...

Name Version Rel
----------------------------------------------------------


The following packages you requested were not found:
rh-postgresql
rh-postgresql-devel
rh-postgresql-libs
rh-postgresql-server

The following packages you requested are already updated:
postgresql
postgresql-devel
postgresql-libs
postgresql-server
Stopping postgresql service: [ OK ]
postmaster: no process killed
psql --version
postmaster: no process killed
Starting postgresql service: [ OK ]
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
# psql --version
psql: symbol lookup error: psql: undefined symbol: get_progname

-------------

and i try this

]# rpm -Uhv postgresql*.rpm
warning: postgresql-8.2.4-1PGDG.i686.rpm: V3 DSA signature: NOKEY, key ID 20579f11
error: Failed dependencies:
libpq.so.3 is needed by (installed) postgresql-python-7.4.17-1.RHEL4.1.i386
libpq.so.3 is needed by (installed) libdbi-dbd-pgsql-0.6.5-10.RHEL4.1.i386

[galuh82]

its working .. thanks a lot ..

[erick_paper]

I have tested on few server with cpanel and PostgreSQL 8.1.0, seem to work fine, Made draft howto how to do it,if i am missing something please feel free to add comments to the article

you can find the article at

http://kb.linuxnetworkcare.com/node/21

hope that helps someone

This article is okay for people who are installing postgresql for the first time. But it's a stupid idea for people who want to *upgrade* to 8.3.3 at the time of this writing. It advocates uninstalling postgresql entirely and then entirely installing it again. All settings and shortcuts you may have will be gone -- as we know Pg is a bit difficult with md5 authentication and such in the hba.conf file. There HAS to be an easier way to upgrade? Anyone has managed an upgrade simply and successfully?

[Rooter]

its working .. thanks a lot ..

This article is okay for people who are installing postgresql for the first time. But it's a stupid idea for people who want to *upgrade* to 8.3.3 at the time of this writing. It advocates uninstalling postgresql entirely and then entirely installing it again. All settings and shortcuts you may have will be gone -- as we know Pg is a bit difficult with md5 authentication and such in the hba.conf file. There HAS to be an easier way to upgrade? Anyone has managed an upgrade simply and successfully?

In any case, way to revive a year-old thread!

[erick_paper]

Galuh82's stuff may be working because he installed a fresh copy. Or it may be working because he has simple settings.

Some of us have full blown DB functionality such as functions, rules, triggers. It's a huge pain to backup and reinstall from scratch, especially with the opaque Cpanel things going on in the middle between Apache and PG. On that instruction page, read the comments.

Anyway, do you suggest I start a new thread? Would that help? Thanks for taking the time to help.

[jlucho]

I have cpanel 11 .23.2

installed posgresql with : /scripts/installpostgres

after , recompiled apache con /scripts/easyapache (with support for pgsql )

So far, everything is fine

Commando : psql --version
Show version : psql (PostgreSQL) 8.1.11

in WHM , options "SQL Services" , show this opcion "Postgres Config" , show 2 options :
- "Postgres Config Install"
- "Postgres Password"

So far, everything is fine

in Cpanel, to create a hosting account, and then go to create database for postgree This usually creates (with user y pass)

So far, everything is fine

when trying to use "phpPgAdmin" I have problems here, show this error :

"Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option."

How can I fix this?

Thank for you help