X-Original-To: pgsql-es-ayuda-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D02B29DCBE1 for ; Tue, 29 Nov 2005 17:33:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28897-05 for ; Tue, 29 Nov 2005 17:33:21 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by postgresql.org (Postfix) with ESMTP id E7A059DCBDF for ; Tue, 29 Nov 2005 17:33:17 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i34so1870455wra for ; Tue, 29 Nov 2005 13:33:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=FzX1+xxUM/Dc4k0zyecsQkIwFh8WmbMEBEMxcJU7eVPcpQ7juw/zxERM0MnJw8Gfd47byZrJVcRGI/kgcUg+Pv+UkxcDT5DBmDzEmEeeALIbsaXC5bJfohMMxlTN3PeG62jCtJoEY7/a+sLCBPmoO+qU7y6wWekDVqrL0hz3z2Y= Received: by 10.65.11.13 with SMTP id o13mr4104599qbi; Tue, 29 Nov 2005 13:33:17 -0800 (PST) Received: by 10.65.180.14 with HTTP; Tue, 29 Nov 2005 13:33:17 -0800 (PST) Message-ID: Date: Tue, 29 Nov 2005 16:33:17 -0500 From: Jaime Casanova To: Andrea Subject: Re: [ADMIN] Fatal : IDENT authentication Cc: pgsql-es-ayuda In-Reply-To: <000a01c5f521$c0bcc610$ca01a8c0@DBA> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <438CC473.9030409@unimedijui.com.br> <000a01c5f521$c0bcc610$ca01a8c0@DBA> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.02 required=5 tests=[AWL=0.020] X-Spam-Score: 0.02 X-Spam-Level: X-Archive-Number: 200511/870 X-Sequence-Number: 12756 On 11/29/05, Andrea wrote: > !Hola LISTA! > Andrea te redireccione a la lista en espa=F1ol pgsql-es-ayuda@postgresql.org, la lista a la que escribistes es en ingles y aunque algunos te entendamos no debes escribir a esa lista en espa=F1ol: > La duda =E9s : > > Yo he hecho un pg_dump de una base de datos llamada CHT > ex: pg_dump cht > cht.backup > > despu=E9s hice un psql (restore) en otro servidor en una base con el mism= o > nombre > ex: psql cht < cht.backup > > Y tengo la mensage: > FATAL: IDENT authentication failed for user "cht_admin" > > Mi pg_hba.conf esta definido asi: > LOCAL all all all trust > para la linea con local solo 3 parametros se usan, asi que tu pg_hba.conf deberia verse asi: LOCAL all all trust > Mi postgresql 7.3.4 est=E1 en linux fedora > > > Atentamente, > > Andr=E9a > -- > Esta mensagem foi verificada pelo sistema de antiv=EDrus e > acredita-se estar livre de perigo. > Internal Virus Database is out-of-date. > Checked by AVG Anti-Virus. > Version: 7.0.300 / Virus Database: 265.6.5 - Release Date: 26/12/2004 > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)