RE: [cobalt-developers] postgresql on raq4

["Josh Trefethen" <jtnewsletters@xxxxxxxxxxxxxxx>]

Sherwin,

Thanks for your help so far...couple of questions for you:

I Installed postgres in /home/opt, and the install went
perfectly. We were able to create the database and get
it up and running, but now I can't connect to it via
psql. My pg_hba_.conf file has an entry that looks
like this:

local   all   127.0.0.1   255.255.255.255 password

but when I try to connect via psql then I get this
error:

psql: No pg_hba.conf entry for host localhost, user
postgres, database template1

It seems that it's trying to connect to the Colbalt's
database and not my own new one. Any ideas? Oh and
when i connect with

psql -h 127.0.0.1 template1

I get
psql: PQconnectPoll() -- connect() failed: Connection
refused
        Is the postmaster running (with -i) at
'127.0.0.1'
        and accepting connections on TCP/IP port
'5432'?

the postgresql.conf file does have tcpip enabled so
I'm really at a loss here, besides psql is trying to
connect to the old postgresql server.

Oh and I am using the psql binary that was created in
the install, i.e. /opt/bin/psql.

Any ideas?

Thanks in advance!

--Josh


-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Sherwin T.
Ang
Sent: Tuesday, September 03, 2002 7:34 PM
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-developers] postgresql on raq4


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

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers