> my original pg_dump has records with the id from 1 to 644714794.
> my "replica" database started at 4064868 (where did that number come from?
I'm not sure either. Questions:
1. Are you dumping just the database schema, or the schema and the data?
2. How were records inserted into the table originally? That is, is it
possible that many/all of the records were inserted without using the
sequence as their id, but getting their ID numbers from some external source?
Aglio Database Solutions
In response to
pgsql-novice by date
|Next:||From: Giles Lean||Date: 2002-10-05 00:09:23|
|Subject: Re: PostgresQL applications using libpq |
|Previous:||From: Pam Wampler||Date: 2002-10-04 20:50:48|
|Subject: pg_dump & restore question regarding creating with serial|