Re: [cobalt-developers] postgresql on raq4

["Sherwin T. Ang" <sherwin@xxxxxxxxxx>]

Hello Josh,

I also suggest not to mess with the preinstalled postgresql in your Raq, it
is being used by the cobalt administration interface and some other
functions.

What I did was to compile my own copy of Postgresql, 7.2.2 which also
includes several security and bug fixes so I suggest you install this
version.

Try to remember the following:

1. Install Postgresql in a much larger partition, Cobalt's Postgresql data
files are in /var/lib/pgsql/data which is too small if you are going to use
Postgresql in development or production.  I install mine at
/home/local/pgsql and data directory is at /home/local/pgsql/data
2. Compile your Postgresql with a different port number, this can be done
using --with-pgport=9999 just make sure that the port number your be using
is free, and doesn't belong to the reserved ports for superuser.
3. When doing an initdb, either cd to the /home/local/pgsql/bin directory or
put the absolute path like /home/local/pgsql/bin/initdb -W -D
/home/local/pgsql/data
-W will prompt for a password for the postgres superuser.

The hardest part is administering or using postgresql from the command line,
coz it might confuse with psql to use, it's either I cd to the directory
first and use ./psql or I use a remote administration tool such as pgadmin
or phppgadmin.

Hope that helps.

Respectfully yours,

Sherwin T. Ang
Systems Administrator
Internet Manila
http://www.i-manila.com.ph

Tridel Technologies Inc.
7F Hanston Building Emerald Avenue
Ortigas Center Pasig City 1605
Metro Manila Philippines

(632) 634.5140 Local 1009


----- Original Message -----
From: "jt" <jtnewsletters@xxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Wednesday, September 04, 2002 12:26 AM
Subject: [cobalt-developers] postgresql on raq4


> Hello,
>
> I just got a raq4 and haven't had a lot of experience with it yet, but I
am
> having difficulty figuring out how to use the pre-installed postgresql Db.
>
> Any ideas?  I have heard from some that you shouldn't use it, that it will
> void your warranty, etc. etc.  Is ti possible to use it?  Can I install
> another instance of postgresql on the raq to use for other apps?
>
> Any help will be greatly appreciated!!!
>
> Thanks,
>
> Josh
>
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers