Redhat Postgres 6.3
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
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:
Show quoted text
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.logAlthough 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