Wikia

coLinux

PostgreSQL

238pages on
this wiki
Talk0

Installing PostgreSQL on coLinux Edit

Getting PostgreSQL to run in coLinux is a lot easier than I thought. I will write below the full syntax I had to write to get PostgreSQL up and running.

Before you are ready to go you have to configure your coLinux and the linux on it. That includes configuring the network conneciton and the DNS lookup (meaning you can ping google.com). Best way to do it is to read GettingStartedLong and coLinuxNetworking.

I used the *Debian* distribution and as a Linux newbie I really don't know if it will work on any other. Here we go:

apt-get -y update
apt-get -y install gcc
apt-get -y install ftp
apt-get -y install make
apt-get -y install libedit-dev
apt-get -y install libperl-dev
apt-get -y install python-dev
apt-get -y install tcl8.3-dev
apt-get -y install tk8.3-dev
apt-get -y install zlib1g
apt-get -y install zlib1
apt-get -y install zlib1g-dev

ln -s /usr/bin/make /usr/bin/gmake

Now when you have FTP download a source of the latest PostgreSQL version, I downloaded the latest today, 7.4.2. Here's a link to the download page. After you download it, you're free to proceed:

gunzip postgresql-7.4.2.tar.gz
tar xf postgresql-7.4.2.tar

cd postgresql-7.4.2
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Now you should have a working PostgreSQL.

(added by Jurgen Defurne 2005-08-11) Wouldn't it have been easier to do

apt-get -y postgresql

since you are using Debian anyway ?

Gotchas Edit

Here are the problems that happened to me, they might not happen to you, or anybody at all:

  • plsql acts very strangely in coLinux after the postmaster is running. First time it ran perfectly but after that I just couldn't execute it at all, it kept complaining about memory allocation :(. It isn't a big problem however, since you'll be working mostly from Windows, using some kind of PostgreSQL gui. You can even run a native win32 psql from windows and connect from there to your coLinux PostgreSQL.
  • Don't just close the coLinux console box, *shutdown -h now* properly before you close your computer. If you do, PostgreSQL will refuse to go up next time and you'll have to shutdown Co Linux especially just to free PostgrSQL files.(added by MattNuzum 2004-06-01: You can probably delete /var/lib/pgsql/data/postmaster.pid and restart postgres just fine after an unclean shutdown.)

Resources Edit

PostgreSQL's homepage: http://www.postgresql.org

Win32 psql project: http://sourceforge.net/projects/psql/


MassTranslated on 25 Dec 2004.
MassTranslated on Sun Apr 23 17:36:41 UTC 2006

Around Wikia's network

Random Wiki