Hi Ben,
This is off-topic for this list which is specifically for issues with
the pgAdmin application. Please try somewhere like
pgsql-general@postgresql.org.
Regards, Dave.
> -----Original Message-----
> From: Ben Ramsey [mailto:ben@eureka-interactive.com]
> Sent: 06 March 2003 20:49
> To: pgadmin-support@postgresql.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@eureka-interactive.com
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>