Skip to content

Instantly share code, notes, and snippets.

@deanet
Created June 23, 2011 09:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save deanet/1042268 to your computer and use it in GitHub Desktop.
Save deanet/1042268 to your computer and use it in GitHub Desktop.
Installing Postgreesql on CPANEL
root@tera [~]# /scripts/installpostgres
This script will install PostgreSQL 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
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.netdna.com
* updates: mirror.raystedman.net
Excluding Packages in global exclude list
Finished
Setting up Install Process
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.
Package postgresql-libs-8.1.23-1.el5_6.1.i386 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package postgresql.i386 0:8.1.23-1.el5_6.1 set to be updated
---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated
---> Package postgresql-server.i386 0:8.1.23-1.el5_6.1 set to be updated
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
postgresql i386 8.1.23-1.el5_6.1 updates 2.9 M
postgresql-devel i386 8.1.23-1.el5_6.1 updates 1.2 M
postgresql-server i386 8.1.23-1.el5_6.1 updates 3.8 M
Transaction Summary
================================================================================
Install 3 Package(s)
Upgrade 0 Package(s)
Total download size: 7.9 M
Downloading Packages:
--------------------------------------------------------------------------------
Total 202 kB/s | 7.9 MB 00:39
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : postgresql 1/3
Installing : postgresql-devel 2/3
Installing : postgresql-server 3/3
Installed:
postgresql.i386 0:8.1.23-1.el5_6.1
postgresql-devel.i386 0:8.1.23-1.el5_6.1
postgresql-server.i386 0:8.1.23-1.el5_6.1
Complete!
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Installing Bundle::DBD::Pg
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
.........
You should now configure PostgreSQL from WHM!
root@tera [~]# :exit
-bash: :exit: command not found
root@tera [~]# exit
logout
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment