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 61A8C9DC9A4 for ; Sun, 12 Mar 2006 03:56:57 -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 55156-01 for ; Sun, 12 Mar 2006 03:56:57 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web34805.mail.mud.yahoo.com (web34805.mail.mud.yahoo.com [209.191.68.169]) by postgresql.org (Postfix) with SMTP id 4E0CC9DC9C7 for ; Sun, 12 Mar 2006 03:56:54 -0400 (AST) Received: (qmail 59027 invoked by uid 60001); 12 Mar 2006 07:56:55 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=eFEmg0IdkXQnp2c3gHtTuXh+pUW8C5nKFTj808Re2RtYEbqiJDnWqVgXoDjD7+2CMyHbJgSt+hkIVPcI+eo9M9Sfj/6jBbr0AsPf2QysosDQXwWeIRUYJ+jBbafyLBMrS9kHT0WlcKkMUqUokMvvDtl5tyrpTUFdc1M7QVqm32s= ; Message-ID: <20060312075655.59025.qmail@web34805.mail.mud.yahoo.com> Received: from [202.47.247.116] by web34805.mail.mud.yahoo.com via HTTP; Sat, 11 Mar 2006 23:56:55 PST Date: Sat, 11 Mar 2006 23:56:55 -0800 (PST) From: Sothorn Rordkongthee Subject: Problem with pg_dump To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.358 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.358 X-Spam-Level: * X-Archive-Number: 200603/103 X-Sequence-Number: 20860 Problem with pg_dump on PostgreSQL 8.05. How to solve this problem. Thank you. $ pg_dump dbname > 080349.sql pg_dump: socket not open pg_dump: SQL command to dump the contents of table "t_visit_service" failed: PQendcopy() failed. pg_dump: Error message from server: socket not open pg_dump: The command was: COPY public.t_visit_service (t_visit_service_id, t_visit_id, t_patient_id, assign_date_time, visit_service_staff_doctor, f_visit_service_status_id, b_service_point_id, visit_service_treatment_date_time, visit_service_finish_date_time) TO stdout; __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com