Solutions to common phpPgAdmin errors and Problems

I. Installation Error
Q: I have installed phpPgAdmin, but when I try to use it,
I got an error saying that the php I installed does not support correct database compilation.

A: This information indicates that your PHP does not compile PostgreSQL support. The correct configuration option is '-- with-pgsql '.
Read the PHP manual carefully to learn more about how to compile PHP.

PostgreSQL supports dynamic extension modules that can be compiled into PHP,
Therefore, if you are using a pre-compiled PHP version (RPM package in Linux or binary files in Windows ),
Maybe you only need to do one thing:

Edit the php. ini file and uncomment the following two lines:
(Windows is usually located in the C: \ WINDOWS or C: \ WINNT directory, and Linux is usually located in/etc/php. ini)

; Extension = php_pgsql.dll; Windows
; Extension = pgsql. so; Linux

Change it:

Extension = php_pgsql.dll; Windows
Extension = pgsql. so; Linux

On the Red Hat or Fedora-based Linux release,
The PHP extension is automatically configured in the/etc/php. d/pgsql. ini file,
You only need to install the php-pgsql package.

Q: When Using phpPgAdmin on Windows, I get the following warning:

"Warning: session_start () [function. session-start]:
Open (/tmp \ sess_5a401ef1e67fb7a176a95236108fe348, O_RDWR) failed"

A: You need to modify your PHP. INI file (usually in the c: \ windows Directory) and

Session. save_path = "/tmp"

Change

Session. save_path = "c: \ windows \ temp"

Make sure that the c: \ windows \ temp directory exists.
2. logon Error
Q: I always get a "Login failed". Are you sure you have used the correct user name and password!

A: Check the PostgreSQL log. It will tell you the exact cause of Logon failure.
Edit the pg_mirror.conf file in the "data" Directory of PostgreSQL,
Make sure that you have the correct permissions to access the database server.

If you install phpPgAdmin on a machine different from the PostgreSQL server,
Another possible cause is that PostgreSQL does not enable TCP/IP sockets at startup.
To enable it, edit the postgresql. conf file and set the following lines

# Tcpip_socket = false

Change

Tcpip_socket = true

Then restart PostgreSQL.
[Translator's note] From version 8.0, the original virtual_host and tcpip_socket configuration commands have been replaced by listen_addresses.
For more information about the listen_addresses command, see PostgreSQL.

Q: Some users will get the "Login disallowed for security" error message.

A: By default, phpPgAdmin prohibits empty passwords or specific users (pgsql, S, root, administrator) from logging in.
Before changing the default behavior (set $ conf ['extra _ login_security '] In the config. inc. php file to false,
First, read the client authentication section in the PostgreSQL documentation carefully,
It also fully understands how to modify PostgreSQL's pg_mirror.conf configuration file to enable password protection for local connections.

Q: I can use any password to log on!

A: PostgreSQL runs in "trust mode" by default ". This means that the password is not checked for the local connection.
We strongly recommend that you modify the pg_cmd.conf file and change the login type to 'md5 '.
Note: Once you change the 'local' login type to 'md5', you may need to enter the password when starting PostgreSQL.
To avoid this, you can use a. pgpass file. For more information, see the libpq section of the PostgreSQL documentation.
3. Other errors
Q: When I input non-ASCII data to the database through a form, it is inserted in hexadecimal or hexadecimal format.

A: You have not used the correct encoding to create A database.
This problem occurs when you attempt to input umlaut to a SQL _ASCII database ),
Or enter the SJIS character into the EUC-JP database.

Q: When I drop and recreate a table with the same name, it fails.

A: The simplest method is to use PostgreSQL 7.3 or A later version.

Q: When I browse a table, the links 'edit 'and 'delete (delete)' are not displayed.

A: phpPgAdmin uses the following values as the unique row identifier in sequence.

1. Primary Key
2. Unique index (not partial index or expression index)
3. OID column (continuous scan is required to update, unless you have created an index on the OID column)

In addition, any NULL value in the unique index will make that row uneditable. Similarly, because the OID in the same table may be repeated,
PhpPgAdmin will confirm whether the modified row is the same after changing the row; otherwise, it will roll back.
Iv. Dump Problems
Q: How to enable the database dump function?

A: You need to configure the config. inc. php file to specify the locations of pg_dump and pg_dumpall.
In this way, the Database Export function will be displayed.

Q: I want to use pg_dump on Windows. Where can I download pg_dump.exe?

A: You need to install PostgreSQL 8.0 for Windows or A later version.
You can go to the http://www.postgresql.org/ftp/win32/ to download.
After installation, you can set the pg_dump and pg_dumpall locations in config. inc. php.

Q: Why can't I reload the dumped SQL script in the SQL window?

A: The following restrictions apply to SQL script execution:

* Only the uploaded SQL script can contain the COPY command, and PHP 4.2 and later versions must be used.

* The 'psql' command, such as '\ Connect', does not work at all.

* Multi-line SQL statements do not work, for example:

Create table example (
A INTEGER
);

* The database and user cannot be switched during script execution.

We plan to reduce these restrictions in future versions, but there is no way to limit PostgreSQL itself,
Therefore, we recommend that you use the 'psql' tool to restore the complete SQL dump results.

V. Other problems

Q: What does the 'value (Value) 'or 'Expression (Expression)' box mean when a row is inserted?

A: Select 'expression' to indicate that you can use functions, operators, and field names,
At the same time, you must use quotation marks to define the string value correctly.
If 'value' is selected, no matter what you enter, it will be inserted into the database as is.

Q: Why is no information displayed on the 'info (Info) 'page of the table?

A: The 'info' page displays the Foreign keys from other tables to this table and statistics from PostgreSQL.
The status statistics program is not enabled by default. To enable it, view the stats _ * option in the postgresql. conf file.
Set all these options to 'true' and restart PostgreSQL.

Q: Why can't I download the query result data in the SQL window?

A: You need to select the 'paginate results' option to allow download.

Q: What should I do if I want to help develop phpPgAdmin?

A: We are very willing to receive your help! Read the DEVELOPERS and TRANSLATORS files.