Jump to content

Changing Host in PHPpgAdmin


Roelandje

Recommended Posts

Hello everyone,

 

In my PHPpgAdmin, i have a server connected to my localhost.

 

Server           Host Port                 Username         Actions

PostgreSQL localhost 5432 greendeal_admin         Log out

 

Now, i want to change the 'Host'. I want to change from localhost to the server im using now.

 

Does anybody know how i go about doing that?

Thanks in advance

 

Roeland

Link to comment
Share on other sites

hi ,

Add your distant PostgreSQL server into the config file for PhpPgAdmin. This file is  etc/phppgadmin/config.inc.php .

<?php

 

        /**

        * Central phpPgAdmin configuration.  As a user you may modify the

        * settings here for your particular configuration.

        *

        * $Id: config.inc.php-dist,v 1.44 2005/09/07 08:09:21 chriskl Exp $

        */

 

        // Display name for the server on the login screen

        $conf['servers'][0]['desc'] = 'My-distant-server';

 

        // Hostname or IP address for server.  Use '' for UNIX domain socket.

        // use 'localhost' for TCP/IP connection on this computer

        $conf['servers'][0]['host'] = 'mydistantserver.mydomain';

 

        // Database port on server (5432 is the PostgreSQL default)

        $conf['servers'][0]['port'] = 5432;

 

        // Change the default database only if you cannot connect to template1

        $conf['servers'][0]['defaultdb'] = 'template1';

 

        // Specify the path to the database dump utilities for this server.

        // You can set these to '' if no dumper is available.

        $conf['servers'][0]['pg_dump_path'] = '';

        $conf['servers'][0]['pg_dumpall_path'] = '';

 

        // Slony (www.slony.info) support?

        $conf['servers'][0]['slony_support'] = false;

        // Specify the path to the Slony SQL scripts (where slony1_base.sql is located, etc.)

        // No trailing slash.

        $conf['servers'][0]['slony_sql'] = '/usr/share/postgresql';

 

        // Default language. Eg: 'english', 'polish', etc.  See lang/ directory

        // for all possibilities. If you specify 'auto' (the default) it will use

        // your browser preference.

        $conf['default_lang'] = 'auto';

 

        // If extra login security is true, then logins via phpPgAdmin with no

        // password or certain usernames (pgsql, postgres, root, administrator)

        // will be denied. Only set this false once you have read the FAQ and

        // understand how to change PostgreSQL's pg_hba.conf to enable

        // passworded local connections.

        $conf['extra_login_security'] = true;

 

        // Only show owned databases?

        // Note: This will simply hide other databases in the list - this does

        // not in any way prevent your users from seeing other database by

        // other means. (eg. Run 'SELECT * FROM pg_database' in the SQL area.)

        $conf['owned_only'] = true;

 

        // Display comments on objects?  Comments are a good way of documenting

        // a database, but they do take up space in the interface.

        $conf['show_comments'] = true;

 

        // Display "advanced" objects?  Setting this to true will show types,

        // operators conversions, languages and casts in phpPgAdmin.  These

        // objects are rarely administered and can clutter the interface.

        $conf['show_advanced'] = false;

 

        // Display "system" objects?

        $conf['show_system'] = false;

 

        // Display reports feature?  For this feature to work, you must

        // install the reports database as explained in the INSTALL file.

        $conf['show_reports'] = true;

 

        // Only show owned reports?

        // Note: This does not prevent people from accessing other reports by

        // other means.

        $conf['owned_reports_only'] = true;

 

        // Minimum length users can set their password to.

        $conf['min_password_length'] = 1;

 

        // Width of the left frame in pixels (object browser)

        $conf['left_width'] = 200;

 

        // Which look & feel theme to use

        $conf['theme'] = 'default';

 

        // Show OIDs when browsing tables?

        $conf['show_oids'] = false;

 

        // Max rows to show on a page when browsing record sets

        $conf['max_rows'] = 30;

 

        // Max chars of each field to display by default in browse mode

        $conf['max_chars'] = 50;

 

        // Send XHTML headers?  Unless debugging, it's best to leave this off

        $conf['use_xhtml'] = false;

 

        // Base URL for PostgreSQL documentation.

        // '%s', if present, will be replaced with the PostgreSQL version

        // (7, 7.1, 7.2, 7.3, 7.4, or 8.0)

        $conf['help_base'] = 'http://www.postgresql.org/docs/%s/interactive/';

 

        /*****************************************

        * Don't modify anything below this line *

        *****************************************/

 

        $conf['version'] = 15;

 

?>

 

that will help to add extra server to the current setup of phppgadmin.

 

--Peter

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.