Configuring phpPgAdmin 1

[newbiepg]

I am using redhat 7.3 and would like to use phpPgAdmin.

I am using it as root and one normal user.

Can some someone tell me what I have to change in the configuration file (and anything else).

These are all the things I have done so far

I opened the /var/lib/pgsql/data/pg_hba.conf file. I uncommented the two lines that allows access for localhost.

Then I went to the command line as root , type d
1)su postgres
2)psql databasename
3)grant all privileges on tablename to apache

The php -postgresql connection was working, I was able to select and insert into a table that I had created.

 

[Leland123]

Hi Newbiepg,

Download phpPgAdmin and install it in your web directory tree. If your using RedHat 7.3, you might place all the phpPgAdmin files a directory like:

/var/

http://www/html/phpPgAdmin

You must edit the config.inc.php file. Below is how I have mine setup. You will want to enter the info into
config.inc.php based on how you have Postgres setup.

$cfgServers[1]{'local'] = false'
$cfgServers[1]['host'] = 'localhost';
$cfgServers[1]['post'] = '5432';
$cfgServers[1][adv_auth'] = true;

$cfgServers[1]['user'] ='postgres'
$cfgServers[1]['password'] ='PG_PassWd'
$cfgServer[1]['only_db'] = ''

Then point your browser to:

http://localhost/phpPgAdmin/index.php

or, you could provide a link to index.php within
your html web pages.

That about all their is to it, given that you apache web
server is set up to run php. In 7.3 I think it is.
Leland F. Jackson, CPA
Software - Master (TM)

https://www.smvfp.com

Nothing Runs Like the Fox