Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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
> 

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group