Installing Postgresql - HOWTO

[Wave3]

Has anybody upgraded to PostgreSQL 8.0 yet?

I have some what successfully got PostgreSQL 8.0.1 working with cPanel 10 but it still will not assign a user to a database.

every time my server is restarted

Have you checked to see if PostgreSQL service started with the server?

[hendricknet]

Have you checked to see if PostgreSQL service started with the server?

Yes, sites that have existing databases still function, just no joy in cpanel itself to add users/db. Anyone have ideas? I'd hate to have to reinstall postgres AGAIN.

I've stepped through the install script and didn't see anything that stood out to me, but I'm no code monkey.

[NoP]

Hi,
I've installed Postgre's in my server as you said, but the estranged is that the icon to Postgre isn't appearing at my CPanel. Please, do you know what could be happening?

Thanks =)

********
Found the erros, thanks =D

[maxihost2]

Expanding on an earlier post by casey, this is what I just had to do to make PostGres work properly:

(9.9.9)

Stage 1 -

install postgres using the CPanel script, and update PHP through WHM to include pg support if needed

Goto the postgres config, set the password

At this point it was installed in CPanel, but I could not add users or dbs when logged in as users, this is what I did to make it work:

1. service postgresql stop
2. rm -rf /var/lib/pgsql/data
3. su - postgres
4. initdb
5. manually start pg with one of the ways initdb tells you, doesn't matter which

at this point the postgresql password is blank, so:

6. psql template1

then at the prompt:

ALTER USER postgres with password 'password' ;

remember the quotes, and use exactly the same password as you put into the postgres password set thing in WHM earlier

7. check /var/lib/pgsql/data/postgresql.conf - make sure that tcpip_socket=true and port=5432 are uncommented
8. In WHM postgresql config, remake the config file, but don't reset the password
9. At this point it was working for me, so I restarted the postgres service via WHM, which worked fine.

the above worked for 10.2.0-S83

[emericklaw]

I am getting the following when trying to install postgresql:

# /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
Gathering header information file(s) from server(s)
Server: Fedora Core 2 - i386 - Base
Server: Fedora Linux 2 - i386 - core
Server: Dag RPM Repository for Fedora Core
Server: Fedora Linux 2 - i386 - freshrpms
Server: Livna.org Fedora Compatible Packages (stable)
Server: Fedora Core 2 NewRPMS.sunsite.dk
Server: Fedora Linux 2 - i386 - updates
Server: Fedora Core 2 - i386 - Released Updates
Finding updated packages
Downloading needed headers
Resolving dependencies
error reading information on service postgresql: No such file or directory
error reading information on service postgresql: No such file or directory
postgresql: unrecognized service
postmaster: no process killed
postmaster: no process killed
postgresql: unrecognized service
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!
#

Any ideas, I have tried quite a few times and I get the same output.

[casey]

I am getting the following when trying to install postgresql:



Any ideas, I have tried quite a few times and I get the same output.

Did you try the method quoted in the post right above yours?

[emericklaw]

Yes I did but the cpanel install script does not complete, i actually missed out a line...

Downloading needed headers
Resolving dependencies
.......Unable to satisfy dependencies
Package gnokii-smsd needs gnokii = 0:0.6.1-0.lvn.4.2, this is not available.
error reading information on service postgresql: No such file or directory

Why would postgresql need gnokii (software to use nokia phone in linux)??

[webhostexpert]

Can anyone explain why I cant get newer rpms then 7.3.10 on my server?

I have tried everything even deleted the old one and reinstalled and it keeps grabbing the old 7.3.10 when 8.0 is out now.

will version 8 run on redhat es 3.0?

[chirpy]

RHE provides only v7.3.10 postgresql rpms, so that's what cPanel will install. If you want a newer version for some reason, then you're going to have to break your RHE support and install from source. Don't forget to exclude all the postgresql rpms from up2date otherwise RHE will downgrade it next time RedHat fix a bug in it.

[typhon]

RHE provides only v7.3.10 postgresql rpms, so that's what cPanel will install. If you want a newer version for some reason, then you're going to have to break your RHE support and install from source. Don't forget to exclude all the postgresql rpms from up2date otherwise RHE will downgrade it next time RedHat fix a bug in it.

the only problem is that cpanel doesn't recognize that it is installed no matter what you do when you build it from source... unless that is I am missing something.
My process was this: install postgres from source, use script: installpostgres, build apache + php.

[zaryab]

this is the way to use my card ofmy network
# /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
Gathering header information file(s) from server(s)
Server: Fedora Core 2 - i386 - Base
Server: Fedora Linux 2 - i386 - core
Server: Dag RPM Repository for Fedora Core
Server: Fedora Linux 2 - i386 - freshrpms
Server: Livna.org Fedora Compatible Packages (stable)
Server: Fedora Core 2 NewRPMS.sunsite.dk
Server: Fedora Linux 2 - i386 - updates
Server: Fedora Core 2 - i386 - Released Updates
Finding updated packages
Downloading needed headers
Resolving dependencies
error reading information on service postgresql: No such file or directory
error reading information on service postgresql: No such file or directory
postgresql: unrecognized service
postmaster: no process killed
postmaster: no process killed
postgresql: unrecognized service
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!
#

[darkelder]

Are postgresql 8 works with cpanel?

Somebody installed it?

There are any issues?

[BLazeD]

I cancelled my cpanel server because of this. Any 8.xxx is incompatible AFAIK. Pretty stupid really.

[cpanelnick]

Are postgresql 8 works with cpanel?

Somebody installed it?

There are any issues?

Postgres 8 will eventually be supported, but there are a few more problems to work out.

[erick_paper]

Hi,

Is there a way to install PostgreSQL 8.1 RC? The "/scripts/installpostgres" is still working with 7.3.0?! I would like to install PostgreSQL as root account and then have it available in Cpanel of all my domains. Would sincerely appreciate any tips or pointers, thanks.

EP