Re: [cobalt-developers] postgresql on raq4

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

hrmm,

looks like it's still using the binary from the original cobalt install.
Have you started the postgresql you install and with the -i option, like
/home/opt/pgsql/bin/postmaster -i -D /home/opt/pgsql/data &

you can check for a netstat or a ps ax | grep postmaster, you should see 2
postmaster process runinng here, one is yours and one is the cobalt's.  You
can optionally specify -p XXXX in your postmaster daemon where XXXX is the
port number of your postgresql install.

Well looks like you just need the -i in the postmaster

I hope that would solve your problem, Cheers!


----- Original Message -----
From: "Josh Trefethen" <jtnewsletters@xxxxxxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Thursday, September 05, 2002 10:46 AM
Subject: RE: [cobalt-developers] postgresql on raq4


> 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
>
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers