dbsa@dbsa-X406UA:~$ ssh root@172.16.9.118
Last login: Wed Jan 15 16:20:03 2020 from 172.17.10.237
[root@localhost ~]# cd /etc/phpPgAdmin/
[root@localhost phpPgAdmin]# ls
config.inc.php config.inc.php-dist
[r<?php
[root@localhost ~]# vi config.inc.php
/**
* Central phpPgAdmin configuration. As a user you may modify the
* settings here for your particular configuration.
*
* $Id: config.inc.php-dist,v 1.55 2008/02/18 21:10:31 xzilla Exp $
*/
// An example server. Create as many of these as you wish,
// indexed from zero upwards.
// Display name for the server on the login screen
$conf['servers'][0]['desc'] = '5432';
$conf['servers'][1]['desc'] = '5439';
$conf['servers'][2]['desc'] = '5433';
$conf['servers'][3]['desc'] = '5434';
$conf['servers'][4]['desc'] = '5435';
$conf['servers'][5]['desc'] = '5436';
$conf['servers'][6]['desc'] = '5332';
$conf['servers'][7]['desc'] = '5331';
$conf['servers'][8]['desc'] = '5532';
$conf['servers'][9]['desc'] = '5531';
$conf['servers'][10]['desc'] = '5533';
$conf['servers'][11]['desc'] = '5101';
$conf['servers'][12]['desc'] = '5102';
$conf['servers'][13]['desc'] = 'consign';
$conf['servers'][14]['desc'] = 'revenu';
// Hostname or IP address for server. Use '' for UNIX domain socket.
// use 'localhost' for TCP/IP connection on this computer
$conf['servers'][0]['host'] = 'localhost';
$conf['servers'][1]['host'] = 'localhost'
oot@localhost phpPgAdmin]#
Add Multiple Servers to phppgadmin
Example I run two PostgreSQL servers in my Ubuntu box and the easiest way to edit certain field is by using phppgadmin
so the easiest way to add another server to phppgadmin is by editing config.inc.php file inside /etc/phppgadmin/
as usual
$ sudo vim /etc/phppgamin/config.inc.php
take note that there exist other servers with index[0] so for the new server add new index[1]
example
//Display name for the server on login screen
$conf[‘servers’][0][‘desc’] = ‘PostgreSQL9.1’;
$conf[‘servers’][1][‘desc’] = ‘PostgreSQL8.4’; // new server
Thanks give your comments in the comments section
Tidak ada komentar:
Posting Komentar