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

Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Gregory Maxwell <greg(at)z(dot)ml(dot)org>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible
Date: 1999-05-30 23:40:55
Message-ID: 199905302340.TAA14305@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
> 
> AHH! The pgsql v6.3 backend has begun crashing horribly on me since I've
> added a few more database backed webpages (with messages like 'backend
> cache invalidation...').. I figured that upgrading to 6.4.2 would solve my
> problems.. But I can't upgrade! Things I've tried:
> 
> * Using old pg_dumpall -z > file and psql -e template1 < file (after
>   install and initdb)
> * Using the pg_dumpall from the new version.
> * Using pg_upgrade 
> * Rereading the docs dozens of times
> * having a friend try it.
> * all of the above with both 6.4.2 and 6.5beta
> 
> Every time I start loading, it chokes up on the dump output and falls into
> a constant stream of parse errors and messages like "PQsendQuery() --
> query is too long.  Maximum length is 8191"
> 
> Argh!!! I've got websites constantly crashing and coustomers ready to
> revolt, what can I do???

You are running psql -e.  You need to find out where in the dump file it
is failing.  Send us the area where it is crashing, or send me
personally(not mailing list) the most of the psql output and I can
figure it out.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-general by date

Next:From: Chris BitmeadDate: 1999-05-30 23:51:03
Subject: Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible
Previous:From: Gregory MaxwellDate: 1999-05-30 22:50:31
Subject: Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible

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