Howto: Installing PostgreSQL w/ phpPgAdmin

**JakePoz** · 12-25-2004, 09:42 AM

I have succesfuly installed PostgreSQL 7.4.6 and phpPgAdmin on my hosting account with no problems.

1. Start up an SSH session, and change directories into /home/(username)

Code:

cd /home/&#40;username

2. Download the PostgreSQL package

Code:

ftp&#58;//ftp3.us.postgresql.org/pub/postgresql/latest/postgresql-7.4.6.tar.gz

3. Extract the archive

Code:

untarzip postgresql-7.4.6.tar.gz

4. Change into the new directory

Code:

cd postgresql-7.4.6

5. (If you haven't already install the GNU compilation utilities in Site Manager)

6. Run the config script

Code:

./configure --prefix=/home/&#40;username&#41;

7. Compile

Code:

make

8. Install

Code:

make install

9. Now create your data directory

Code:

mkdir pgsql
mkdir pgsql/data

10. Set up the database system

Code:

/home/&#40;username&#41;/bin/initdb -D /home/&#40;username&#41;/pgsql/data
/home/&#40;username&#41;/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&amp;1 &amp;
/home/&#40;username&#41;/bin/createdb test
/home/&#40;username&#41;/bin/psql test

PostgreSQL is now running! Now we just need to install phpPgAdmin

1. Change into your default web directory

Code:

cd /var/www/html

2. Download the phppgAdmin files

Code:

wget http&#58;//voxel.dl.sourceforge.net/sourceforge/phppgadmin/phpPgAdmin-3.5.1.tar.gz

3. Extract them

Code:

untarzip phpPgAdmin-3.5.1.tar.gz

4. Rename the folder

Code:

mv phpPgAdmin-3.5.1 phpPgAdmin

You can now log into phpPgAdmin at http://www.yourdomain.com/phpPgAdmin Your username and password are the same as the ones you use everywhere else.[/code]

**JakePoz** · 12-25-2004, 10:15 AM

I forgot to mention how you start/stop/restart the server.

To stop the server

Code:

/home/&#40;username&#41;/bin/pg_ctl stop -D /home/&#40;username&#41;/pgsql/data

To start the server

Code:

/home/&#40;username&#41;/bin/pg_ctl start -D /home/&#40;username&#41;/pgsql/data

To restart the server

Code:

/home/&#40;username&#41;/bin/pg_ctl restart -D /home/&#40;username&#41;/pgsql/data

**wildjokerdesign** · 12-25-2004, 10:54 AM

Thanks for posting JakePoz! Sounds as if it was pretty painless.

**<mark />** · 12-29-2004, 01:12 AM

Anyone else getting errors when they run make? Specifically I get this error:

Gen_fmgrtab.sh: sort: command not found
Gen_fmgrtab.sh failed

and then it exits. Any suggestions?

**jalal** · 12-29-2004, 02:38 AM

The 'sort' command is not installed on Westhost. I guess JakePoz had it from somewhere.
It's in the wh-utils package from my site if you don't find it elsewhere.
ftp.gnomedia.com

**<mark />** · 12-30-2004, 01:23 AM

I got it working. Thanks for your help.

P.S.

Code:

/home/&#40;username&#41;/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&amp;1 &amp;

didn't work for me--I got errors.

Code:

/home/&#40;username&#41;/bin/pg_ctl -D /home/&#40;username&#41;/pgsql/data -l logfile start

seemed to work, however.

**JakePoz** · 12-31-2004, 05:07 PM

I am glad you got it working, not sure why that first command didn't work though.

**Tom Howard** · 01-10-2005, 04:18 PM

First of all, thanks again to JakePoz for this post!

I'm guessing that the average WH user doesn't have readline installed, so an alternative step 6:

Code:

./configure --prefix=/home/&#40;username&#41; --without-readline

A minor addition (for clarity) to step 8:

Code:

cd /home/&#40;username&#41;/
mkdir pgsql
mkdir pgsql/data

**jbsarma** · 08-16-2005, 03:00 AM

I have succesfully installed postgresql with phpPgAdmin. But I needed to add PL/pgSQL (a procedural language) in my database for wich I need to run 'createlang' command. But I get the response 'command not found'. I beleive this is due to the VPS not having sh-utils installed or may be other similar utility. I need PL/pgSQL to be able to install mysourcematrix CMS.

Does anybody come across with this issue and know how to resolve it. The Westhost technical suppot cannot do it (they will only do against fee which cost $80/per hour and 1 hour payment is minimum).

**rcrodgers** · 02-25-2006, 05:50 PM

Having just set up my account with WestHost, I thought I would download and install the latest version of PostgreSQL. I should note that the basic instructions in this thread are good, but you can also get away with doing just ./configure && make && make install.

BUT! You should also be aware that at least with WestHost's New Year's Special VPS system, PostgreSQL 8.0.3 apparently is already installed! I found that out after getting 8.1.3 installed, and struggling to get initdb working. So if you're going to use a version other than 8.0.3, you will need to use the complete path to your PostgreSQL binaries!

Just passing along a tip...
Raymond

Thread: Howto: Installing PostgreSQL w/ phpPgAdmin

Thread Tools

Search Thread

Display

Howto: Installing PostgreSQL w/ phpPgAdmin

Starting and Stopping the server

createlang: 'command not found'

Installing PostgreSQL 8.1.3 (Feb 25, 2006)

Similar Threads

HowTo Guide: Installing Subversion

HowTo Tutorial: Using and Installing SSH

PHP 5.2 and PostgreSQL

Howto guide: Installing Mailman

Upgrade SpamAssassin using CPAN?

Posting Permissions