From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Ben Marklein <the_pharcyde(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump/pg_restore problems with 7.4.1 |
Date: | 2004-02-11 22:12:25 |
Message-ID: | 200402112212.i1BMCPl21989@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hope you got this fixed. We have never heard of similar problems with
upgrades --- other problems, yea, but not these. :-)
---------------------------------------------------------------------------
Ben Marklein wrote:
> I'm trying to migrate from 7.2 to 7.4.1 via
> pg_dump/pg_restore and have encountered a couple of
> problems:
>
> 1) Index creation on a table fails:
>
> db=# CREATE UNIQUE INDEX person_info_username_ix ON
> person_info USING btree (username);
> ERROR: could not create unique index
> DETAIL: Table contains duplicated values.
>
> Of course, this index existed in the 7.2 DB, so it
> seems odd that it should not be possible to recreate.
> Furthermore, a search for duplicate values fails:
>
> db=# select username, count(*) from person_info group
> by username having count(*) > 1;
> username | count
> ----------+-------
> (0 rows)
>
> Is this a known issue or possibly a bug?
>
> 2) While importing I get: "ERROR: invalid memory
> alloc request size 1073741824". I tracked this down
> to a line with some non-ASCII characters. The type of
> the new database is LATIN1, and these are valid LATIN1
> characters. I googled for the error message and found
> a bug report that sounds like the same problem:
>
> http://www.mail-archive.com/pgsql-bugs(at)postgresql(dot)org/msg07363.html
>
> Anyone know if this was confirmed as a bug, and
> whether it's being looked into? Thanks.
>
> Ben
>
>
> Ben
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-02-11 22:14:06 | Re: pg_dump/pg_restore problems with 7.4.1 |
Previous Message | Joe Lester | 2004-02-11 21:59:26 | No More Processes |