X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9180F475A4B for ; Sun, 30 Mar 2003 05:22:33 -0500 (EST) Received: from embon.lipi.go.id (unknown [202.152.3.117]) by postgresql.org (Postfix) with ESMTP id 80A934758E6 for ; Sun, 30 Mar 2003 05:22:31 -0500 (EST) Received: from kulo-bd.lipi.go.id (kulo-bd.lipi.go.id [192.168.243.10]) by embon.lipi.go.id (8.11.6/8.11.6) with SMTP id h2UBK9220910 for ; Sun, 30 Mar 2003 18:20:11 +0700 Received: FROM informatika.lipi.go.id BY kulo-bd.lipi.go.id ; Sun Mar 30 17:33:20 2003 +0700 Received: (qmail 30413 invoked by uid 399); 30 Mar 2003 10:16:53 -0000 Received: from unknown (HELO bukittinggi) (167.205.240.166) by 0 with SMTP; 30 Mar 2003 10:16:53 -0000 Message-ID: <025501c2f6a7$1ab78000$a6f0cda7@informatika.lipi.go.id> From: "Devi Munandar" To: Subject: pg_dump restore problem Date: Sun, 30 Mar 2003 17:28:28 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/488 X-Sequence-Number: 8128 Hi admin i have problem with user authentification I've made a dump from PostgreSQL 7.2.2 under linux 8.0 with the command: pg_dump -a -b -Fc -f bakstore -o -v store and running success, and then i try to restore with the command: pg_restore -a -d store -Fc -o -v bakstrore and running unsuccess because i've got message: pg_restore:[archiver (db)] could not reconnect to database : FATAL 1 : IDENT authentification failed for user "phpuser" my post pg_hba.conf ***************** TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT host all 127.0.0.1 255.255.255.255 trust host store 167.205.240.166 255.255.255.0 trust host all 127.0.0.1 255.255.255.255 ident phpuser my post pg_ident.conf ****************** MAP IDENT PGUSERNAME phpuser phpuser postgres NB: i make 'store' database pass through phpPgAdmin2.4.2 with username:"phpuser" and password:"" Best Regards, --devi munandar