PostgreSQL management tool phpPgAdmin Getting Started Guide

1. Install phpPgAdmin
Decompress the downloaded package

Run the following command for tar.gz:

Copy codeThe Code is as follows: gunzip phpPgAdmin-* .tar.gz
Tar-xvf phpPgAdmin-*. tar

Run the following command for tar.bz2:

Copy codeThe Code is as follows: bunzip2 phpPgAdmin-* .tar.bz2
Tar-xvf phpPgAdmin-*. tar

Run the following command for. zip:

Copy codeThe Code is as follows: unzip phpPgAdmin-*. zip

2. Configure phpPgAdmin

Edit the phpPgAdmin/conf/config. inc. php file

If you mess up the configuration file, you can use the config. inc. php-dist file to restore it.

3. Create a reports database

If you want to enable reports (a useful feature), go to the 'SQL' subdirectory to view the reports-pgsql. SQL script.
It provides guidance on how to create a reports database.

Iv. Dump Functions

If you are running PHP in safe mode, in order to make the database dump work properly,
You must include the 'safe _ mode_allowed_env_vars' command in php. ini in the PGPASSWORD and PGUSER environment variables,
You also need to include the directory where the pg_dump binary file is located in the 'safe _ mode_exec_dir 'command.
For example:

postgresql  ui
Copy codeThe Code is as follows: safe_mode_allowed_env_vars = PHP _, PG
Safe_mode_exec_dir =/usr/bin

Generally, you do not want all programs in/usr/bin to be executed,
Therefore, you may need to copy pg_dump and pg_dumpall to a separate directory.

Similarly, if you want phpPgAdmin to support dump,
You also need to ensure that pg_dump and pg_dumpall can be executed by processes running PHP.

Finally, if you run phpPgAdmin in safe mode,
Import, export, and transaction processing that require long running may exit due to timeout.

V. PostgreSQL statistics collector

If you have enabled the PostgreSQL statistics program (statistics collector ),
PhpPgAdmin displays the performance and usage statistics of tables and indexes.
To enable this function, You Need To uncomment the following lines in the postgresql. conf file:
Copy codeThe Code is as follows:
Stats_start_collector = true
Stats_command_string = true
Stats_block_level = true
Stats_row_level = true

pgbouncer in postgresql
Vi. cookies

To be able to use phpPgAdmin in a browser normally, you must enable the cookies function of the browser.

VII. Important-security-related

PostgreSQL does not require a password to log on by default, postgresql synchronous_commit
We strongly recommend that you configure the md5 password for the local link in pg_cmd.conf,
Set a password for the default Super User.

phppgadmin postgresql 11

Because a large number of installed phpPgAdmin instances do not set a password for the local connection,
We provide a configuration option named 'extra _ login_security ', which defaults to TRUE.
This means you cannot use the 'root', 'admin', 'pgsql', or 'ipvs' user or empty password to log on.

postgresql tutorial pdf

You can set 'extra _ login_security 'to fasle only after you have made sufficient security settings for the database,
In this way, you can use the administrator password to log on as an administrator.

postgresql varchar or text

8. Tips

When display_errors = On is set in php. ini and error_reporting contains errors other than ERROR,

postgresql update inner join
PhpPgAdmin often cannot be used smoothly, probably because the encoding does not strictly abide by the encoding style that PHP developers expect.
If some problems occur, try display_errors = Off to solve some annoying problems.