[Courses] [Postgresql] Installing PostgreSQL and Assignments- Debian

[Liz Young]

On Sunday 25 November 2007 03:21:49 pm Michelle Murrain wrote:
> //**Assignment for the Week**//
>
>    * Install Postgresql on your platform of choice. If you have more
> than one available, install on as many as you'd like

My current workstation is running Sidux (Debian Sid), so I used "apt-get 
install postgresql-8.2", and during setup I noticed:
"Adding user postgres to group ssl-cert"
and
"Creating new cluster (configuration: /etc/postgresql/8.2/main, 
data: /var/lib/postgresql/8.2/main)..."
Debian sets up SSL and cluster management by default.  ? As usual, the 
README.Debian file explains both.

>    * Tell us all how it went? Any snags? Did you install it on a
> different platform (like BSD for instance?)

Just Debian, no snags. There were no problems creating the test db. 

>    * If you took the easy road (installing via a package manager)
> download and install the PG Beta (8.3) in /usr/local/src if you want to.

I downloaded postgresql-8.3beta3.tar.bz2, and unzipped it in ~/source.
Ran "apt-get build-dep postgresql-8.2" assuming the dependencies would be 
similar.  And then:
./configure; make; su; make install
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
Stopped 8.2 /etc/init.d/postresql-8.2 stop
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

That worked, the only difference I see is new TEXT SEARCH commands.
I stopped the db with kill -15.  Does anyone know what the correct way lacking 
a start/stop script?

Thanks,
-Liz