Hi Group!
I am trying to work & connect php wirh PGSQL on Red Hat ES 3.
I got some Important path like:
/usr/share/pgsql/contrib
/usr/include/pgsql
/usr/bin

But I don't know how to start/stop pgsql server, Insert data from
client pgsql , view database files, admin database & configuration
file.

please help me
Thanks in advance

jatrojoomla <jatrojoomla (AT) gmail (DOT) com> wrote:
It is not possible and feasible to post a tutorial here.

I suggest that you start by reading the documentation:

http://www.postgresql.org/docs/8.1/static/index.html
for PostgreSQL

http://www.php.net/manual/en/
for PHP

http://www.php.net/manual/en/ref.pgsql.php
the PostgreSQL functions of PHP

For database administration, either use the psql command line interface
(described in the documentation), the 'fat client' admin GUI tool
pgAdminIII (http://www.pgadmin.org/) or the PHP web application
phpPgAdmin (http://phppgadmin.sourceforge.net/).

Yours,
Laurenz Albe

Laurenz Albe wrote:


apache & php is working but how to start & stop pgsql server on Red Hat
linux ES

jatrojoomla <jatrojoomla (AT) gmail (DOT) com> wrote:
http://www.postgresql.org/docs/8.1/s...ter-start.html

It is right in the documentation I pointed you to.

Now, if you want me to tell you the exact command line string that you
need to type to do it on your machine, I'll have to disappoint you. That
depends a lot on how you installed and configured PostgreSQL.

Maybe there is a startup script in /etc/rc.d/init.d that starts
PostgreSQL at system boot; if yes, you can also use this to start the
server.

Keep in mind that you need to create a database cluster before you can
start the server on it.

Read the Server Administration section of the manual:
http://www.postgresql.org/docs/8.1/static/admin.html
I mean it.

Yours,
Laurenz Albe

Laurenz Albe wrote:



THANKS SIR, TODAY I INSTALL REDHAT ES, THEN DOWNLOAD PHP/APACHE/PGSQL
SOURCE CODE THEN FROM MANUAL FIRST I CONFIGURE & INSTALL PGSQL THEN
APACHE & THEN PHP, ALL WORKING.

I AM VERY HAPPY!!!

BUT NOW MY PROBLEM IS
I AM NOT ABLE TO WORK WITH
PHPPgADMIN --
IT SHOWING MESSAGE LIKE:
You don't have permission to access /phpPgAdmin/ on this server.

I PUT LOGIN DETAILS ON
.conf file
BUT STILL IT'S SHOWES THE SAME PROBLEM
?????

jatrojoomla <jatrojoomla (AT) gmail (DOT) com> wrote:
Erm, I am neither a nobleman nor your military superior.
No need to call me 'sir'.

.... your problem is that you got the shift key stuck on your keyboard.

Shouting won't get you anywhere.

This is not a database problem, but a problem of your http server
configuration.

I am sorry, and it may seem annoying to you, but please read the Apache
documentation to solve your problem.

All this is so difficult because you have many many different programs
involved: a database, a web server, the php plugin.

If you have problems configuring Apache, you'll be served better in an
Apache newsgroup.

Yours,
Laurenz Albe