Re: Problems with pg_dump

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Ben Ramsey" <ben(at)eureka-interactive(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Problems with pg_dump
Date: 2003-03-07 08:04:35
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259D24@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Ben,

This is off-topic for this list which is specifically for issues with
the pgAdmin application. Please try somewhere like
pgsql-general(at)postgresql(dot)org(dot)

Regards, Dave.

> -----Original Message-----
> From: Ben Ramsey [mailto:ben(at)eureka-interactive(dot)com]
> Sent: 06 March 2003 20:49
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Problems with pg_dump
>
>
> There are several databases I'm trying to dump, but I keep
> running into problems. Could someone please tell me what
> these error messages mean? (I'm using PostgreSQL 7.0.1).
>
> I'm trying to dump a database with the following command:
>
> pg_dump -d db1 > db1.out
>
> And I'm getting the following error:
>
> dumpClasses(): command failed. Explanation from backend:
> 'pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backedn terminated abnormally
> before or while processing the request.'.
>
> With a second database, running the same command, I get an
> entirely different error message:
>
> getTables(): SELECT failed. Explanation from backend:
> 'ERROR: aclitemout: bad ai_type: 39'.
>
> Still, with a third database, all works well and the database
> structure and INSERT statements are dumped to the file.
>
> I need to retrieve the data from these two databases ASAP for
> a client. If anyone knows the answer and can help, please do so.
>
> Thanks,
>
> Ben Ramsey
>
> Technical Director
> EUREKA! INTERACTIVE, INC.
>
> * Phone: (770) 642-0390
> * Fax: (770) 216-1702
> * Web: www.eureka-interactive.com
> * E-mail: ben(at)eureka-interactive(dot)com
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-03-07 08:09:32 Re: backing up and restoring a db using pgadmin II
Previous Message TJ Morgan 2003-03-07 04:21:33 backing up and restoring a db using pgadmin II