On Friday, December 30, 2011 8:51:17 am Culley Harrelson wrote:
> This is just the first of many duplicate key errors that cause primary key
> creation statements to fail on other tables. I grepped for the key but it
> is hard to tell where the problem is with 888 matches.
>
> I will try pg_dump
This is just the first of many duplicate key errors that cause primary key
creation statements to fail on other tables. I grepped for the key but it
is hard to tell where the problem is with 888 matches.
I will try pg_dump --inserts. It is a 17G file with copy statements so...
this should be int
Hi!
> Are you sure there is just one record?
What happens if you grep the backup file for "653009"?
If you do have more than one such record, the quickest way out is to
manually clean it.
Bèrto
--
==
If Pac-Man had affected us as kids, we'd all be running around
On Friday, December 30, 2011 8:12:27 am Culley Harrelson wrote:
> There is not any data in the new database. I have dropped the database,
> created the database and then piped in the backup every time.
>
Well another fine theory shot in the :)
Questions:
1) Have you gone through the plain text
On 11-12-30 10:49 AM, Culley Harrelson wrote:
They are just your standard sql errors seen in the output of psql mydb
< backup.sql
ALTER TABLE
ERROR: could not create unique index "ht_user_pkey"
DETAIL: Key (user_id)=(653009) is duplicated.
There is a unique index on user_id in the 8..4.0
There is not any data in the new database. I have dropped the database,
created the database and then piped in the backup every time.
On Fri, Dec 30, 2011 at 8:06 AM, Adrian Klaver wrote:
> On Friday, December 30, 2011 7:49:31 am Culley Harrelson wrote:
> > They are just your standard sql error
On Friday, December 30, 2011 7:49:31 am Culley Harrelson wrote:
> They are just your standard sql errors seen in the output of psql mydb <
> backup.sql
>
>
> ALTER TABLE
> ERROR: could not create unique index "ht_user_pkey"
> DETAIL: Key (user_id)=(653009) is duplicated.
>
> There is a unique
They are just your standard sql errors seen in the output of psql mydb <
backup.sql
ALTER TABLE
ERROR: could not create unique index "ht_user_pkey"
DETAIL: Key (user_id)=(653009) is duplicated.
There is a unique index on user_id in the 8..4.0 system and, of course,
only one record for 653009.
On Friday, December 30, 2011 6:32:56 am Culley Harrelson wrote:
> Hello I am trying to migrate a database from 8.4.0 to 9.1.2 on a test
> server before updating the production server. When piping the dump file
> created with pg_dump in psql I am getting duplicate key errors and the
> primary keys
Hello I am trying to migrate a database from 8.4.0 to 9.1.2 on a test
server before updating the production server. When piping the dump file
created with pg_dump in psql I am getting duplicate key errors and the
primary keys on several large tables do not get created. I have read all
the migrati
10 matches
Mail list logo
