Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B159D9FB1E7 for ; Sat, 10 Feb 2007 02:55:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 33672-06 for ; Sat, 10 Feb 2007 02:55:06 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id E4B0C9FB1DF for ; Sat, 10 Feb 2007 02:55:05 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so875811ugf for ; Fri, 09 Feb 2007 22:55:04 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=KfUUchCzDKpDyT1WA60cUk0qJH44iuHUYwCQLThlyAbs3RjPuvUYP6y1oysemcRaGQG8R2n0jEBaepyh282NNWqDNZDN/NB+fIPGUOfiVkk9ug1X1G68xTCaoeI35KCFZRLZlUY6pksXpkas8kRZhxKI/L7o+V27SDantFHi/Jo= Received: by 10.78.185.7 with SMTP id i7mr5222697huf.1171090504541; Fri, 09 Feb 2007 22:55:04 -0800 (PST) Received: by 10.78.139.16 with HTTP; Fri, 9 Feb 2007 22:55:04 -0800 (PST) Message-ID: Date: Sat, 10 Feb 2007 01:55:04 -0500 From: "Jaime Casanova" To: "Daniel Medina" Subject: Re: tabla pg_user Ayuda...... Cc: pgsql-es-ayuda@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <1171056020.7776.27.camel@dmedina.redcorp.computec.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45D496E7.6040502@renova.com.pe> <1171056020.7776.27.camel@dmedina.redcorp.computec.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/141 X-Sequence-Number: 24606 On 2/9/07, Daniel Medina wrote: > Por algun motivo desconocido en la tabla pg_user esta dos veces > registrado en usuario "postgres", por esto no me deja realizar backups > con el comando pg_dump, como hago para eliminar uno de los dos registros > teniendo en cuenta que los datos son identicos y que es el usuario admin > del sistema > > y porque paso esto > > Saludos > por favor, podrias mostrar el resultado de este query? set enable_indexscan to off ; SELECT xmin, xmax, cmin, cmax, ctid, oid FROM pg_user WHERE usename = 'postgres'; que version de postgres es esta? ejecutas vacuum o vacuum full regularmente? -- Atentamente, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook