[pgsql-jp: 35935] Re: phpPgAdminでログオン失敗

[Shuji Kono]

河野です。

On Mon, 05 Sep 2005 18:39:23 +0900
yum <qqqz9b69 ＠ green.ocn.ne.jp> wrote:
> まず第一にPostgreSQLは正常に起動されているでしょうか。
> ワタシは起動せずに接続できん！と1時間悩んだことがあります....

> 50602  ??  Ss     0:00.24 /usr/local/bin/postmaster -D /usr/local/pgsql/data (p
> 50603  ??  S      0:00.02 postmaster: stats buffer process    (postgres)
> 50605  ??  S      0:00.02 postmaster: stats collector process (postgres)

> $ su pgsql
> $ createdb testdb
> CREATE DATABASE
> $ createuser test
> Shall the new user be allowed to create databases? (y/n) n
> Shall the new user be allowed to create more new users? (y/n) n
> CREATE USER
> $ psql testdb
> Welcome to psql 7.4.7, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help on internal slash commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> testdb=# \l
>       List of databases
>    Name    | Owner | Encoding
> -----------+-------+----------
>  template0 | pgsql | EUC_JP
>  template1 | pgsql | EUC_JP
>  testdb    | pgsql | EUC_JP
> (3 rows)
> 
> testdb=# \du
>               List of database users
>  User name | User ID |         Attributes
> -----------+---------+----------------------------
>  pgsql     |       1 | superuser, create database
>  test      |     100 |
> (3 rows)
> 
> testdb=#

と、PostgreSQLは動いているようです。

> 第二にphpPgAdminの設定は適切に行っているでしょうか。

config.inc.phpの全パラメータは以下の通りです。

        $conf['servers'][0]['desc'] = 'myhostname';
        $conf['servers'][0]['host'] = '';
        $conf['servers'][0]['port'] = 5432;
        $conf['servers'][0]['defaultdb'] = 'template1';
        $conf['servers'][0]['pg_dump_path'] = '/usr/local/bin/pg_dump';
        $conf['servers'][0]['pg_dumpall_path'] = '/usr/local/bin/pg_dumpall';
        $conf['default_lang'] = 'english';
        $conf['extra_login_security'] = false;
        $conf['owned_only'] = false;
        $conf['show_comments'] = true;
        $conf['show_advanced'] = false;
        $conf['show_system'] = false;
        $conf['show_reports'] = true;
        $conf['owned_reports_only'] = false;
        $conf['min_password_length'] = 1;
        $conf['left_width'] = 200;
        $conf['theme'] = 'default';
        $conf['show_oids'] = false;
        $conf['max_rows'] = 30;
        $conf['max_chars'] = 50;
        $conf['use_xhtml'] = false;
        $conf['version'] = 13;

-- 
Shuji Kono <shuji.kono ＠ oriental.ac>