Re: Redhat Postgres 6.3

Hello,

I have managed to solve the problems below without too much difficulty. My
problem is
not related to .libpq usage. I have tried to compile some of the programmes
given in the
chapter 17 tutorials on your page and have had a lot of problems with
library parse errords
related to int uint settings. I have tried your example pages on
PostgresSQL Programmer's Guide
and have found that the they will not even compile.

Although I am trying to make use of the librariies with RH 5.1 Linux on
/usr/include/pgsql/
libpq-fe.h and /usr/include/pgsql/libpq/pqcomm.h, have found that they do
not seem to work.
Is there anyone who may suggest a good download site for this, or is theior
a good tech line for
help in thius area ?

Looking forward to your reply,

Richard Wang
Cambridge
Home User

Mr Richard Wang wrote:

> Hi,
>
> I'm a newie to postgres. I have read most of the web pages on your site
> for this RDMS
> but am particularly intrigued at how it can possibly work. Noted is
> that your instructions
> are for a download version of postgres 95 from your site. What I have
> dlone is stuck to
> the ready install 6.3 version from Linux. Set a user account pgsql and
> changed group and
> file permissions recursively for pgsql or 777.
>
> On initdb --pgdata=/var/lib/pgsql
>
> the databse fires up. Problem is that defies the postgres command, whcih
> should come first with
> postmaster ? Postgres command is ignored when attempted, hence I initdb
> and this only
> works once. Postmater is set by
>
> #nohup postmaster > regress.log 2>&1&
> withthe same for server.log
>
> Although the files are created, it does not seem to work as permission
> is denied.
> I cannot visualise where these permissions are blocking,. As I have
> looked in
> Red Hat 5.1 support and errata and found nothing, I am wondering would
> anyone
> here have the exact details on how to set the database on postgres v6.3
> on RH 5.1 Linux.
>
> I have looked through usr/doc docs and they are al psql help sheets and
> have little
> related on how to set, createdb along withinitab.
>
> Is there a proper book on this ?
>
> Can anyone help with exact instruction sets.
>
> Richard Wang
> Cambridge