Bitnami phpPgAdmin

NOTE: Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and Mac OS X) or by clicking the shortcut in the Start Menu under "Start -> Bitnami APPNAME Stack -> Application console" (Windows). Learn more.

phpPgAdmin is an easy to use management tool for PostgreSQL that allows you to create and drop databases, create, drop and modify tables, delete, edit and add fields, execute SQL statements, manage keys on fields, manage privileges and export data in various formats through a web-based interface.

How to access phpPgAdmin?

You should be able to access phpPgAdmin directly, by browsing to http://127.0.0.1:8080/phppgadmin (Linux or Mac OS X) or http://127.0.0.1/phppgadmin (Windows).

The username is postgres for phpPgAdmin, and the password is the one specified by you during the installation process.

How to change the phpPgAdmin password?

The phpPgAdmin credentials are the same as those used to access the PostgreSQL database. To modify the password, refer to this page.

How to modify the allowed limit for uploaded files?

Modify the following option in the installdir/apps/phppgadmin/conf/httpd-app.conf file to increase the allowed size for uploads:

<IfModule php5_module>                                                                    
    php_value upload_max_filesize 80M 
    php_value post_max_size 80M 
</IfModule>

If you are using PHP-FPM, modify the settings in the installdir/apps/phppgadmin/conf/php-fpm/php-settings.conf file

php_value[upload_max_filesize]=80M
php_value[post_max_size]=80M

How to modify the execution time?

This parameter sets the timeout for Apache to run a script.

  • Modify it in the php.ini file.

     max_execution_time = 120     ; Maximum execution time of each script, in seconds
    
  • Modify the ExecTimeLimit value in the installdir/apps/phppgadmin/htdocs/config.inc.php file:

     $cfg['ExecTimeLimit'] = 120;
    

To set this execution timeout to be unlimited (apply this value only if really necessary), set the time limit to 0 in both cases.

Troubleshooting

Timeout error when importing zipped database

If you try to import a zipped database, you might see a timeout error because phpPgAdmin takes too long to execute the script. To fix this:

  • Set the ExecTimeLimit setting to 0 (infinite) as described here.

  • Try to import the file again.

Remember to change the ExecTimeLimit setting back to its original value once the import process ends.

NOTE: When running the commands shown on this page, replace the installdir placeholder with the full installation directory for your Bitnami stack.
nativeInstaller

Bitnami Documentation