From andrea@compesa.com.br Tue Nov 29 21:17:50 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AB5399DCCCF for ; Tue, 29 Nov 2005 17:17:50 -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 26669-08 for ; Tue, 29 Nov 2005 17:17:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ADONIS.compesa.com.br (unknown [200.167.199.194]) by postgresql.org (Postfix) with ESMTP id D79AE9DCCC5 for ; Tue, 29 Nov 2005 17:17:45 -0400 (AST) Received: from [192.168.1.202] (unknown [192.168.1.202]) by ADONIS.compesa.com.br (Postfix) with ESMTP id 4D1DD171D52 for ; Tue, 29 Nov 2005 17:20:33 -0500 (EST) Received: from 127.0.0.1 (AVG SMTP 7.0.300 [265.6.5]); Tue, 29 Nov 2005 18:16:16 -0200 Message-ID: <000a01c5f521$c0bcc610$ca01a8c0@DBA> From: "Andrea" To: References: <438CC473.9030409@unimedijui.com.br> Date: Tue, 29 Nov 2005 18:16:16 -0200 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=======AVGMAIL-438CB71041D7=======" X-Compesa-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-Compesa-MailScanner-OpenProtect: Found to be clean X-MailScanner-OpenProtect-MCPCheck: X-MailScanner-OpenProtect-From: andrea@compesa.com.br Subject: Fatal : IDENT authentication X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=-0.000, HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/331 X-Sequence-Number: 19704 --=======AVGMAIL-438CB71041D7======= Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C5F510.FD2CCA20" ------=_NextPart_000_0007_01C5F510.FD2CCA20 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !Hola LISTA! 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 mismo = 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 Mi postgresql 7.3.4 est=E1 en linux fedora=20 Atentamente, Andr=E9a=20 --=20 Esta mensagem foi verificada pelo sistema de antiv=EDrus e acredita-se estar livre de perigo. ------=_NextPart_000_0007_01C5F510.FD2CCA20 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
!Hola LISTA!
 
La duda =E9s :
 
Yo he hecho un pg_dump de una base de dato= s llamada=20 CHT
ex:   pg_dump cht >=20 cht.backup
 
despu=E9s hice un psql (restore) en otro s= ervidor en=20 una base con el mismo nombre
ex:  psql cht < cht.backup<= /DIV>
 
Y tengo la mensage:
FATAL: IDENT authenticatio= n failed=20 for user "cht_admin"
 
Mi pg_hba.conf esta definido asi:
LOCAL all all all trust
 
Mi postgresql 7.3.4 est=E1 en linux fedora= =20
 
 
Atentamente,
 
Andr=E9a

--
Esta mensagem foi verificada pelo sistema de antiv=EDrus e=20
acredita-se estar livre de perigo. ------=_NextPart_000_0007_01C5F510.FD2CCA20-- --=======AVGMAIL-438CB71041D7======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" 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 --=======AVGMAIL-438CB71041D7=======-- From systemguards@gmail.com Tue Nov 29 21:33:20 2005 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 ;)