Josh
I found my problem. The dump file that I was using had records that had
been inserted a different way --- when I did another dump from the
production database -- which I verified started at 1 & incremented to the
644714974 -- then restored from that file (which is what I had thought was
being used to begin with) -- the restore worked fine -- the id started at 1
& incremented just as it was in the production database.
Sorry for any confusion -- but I learned much about serials & sequences
throught this exercise.
Thanks for your help!
Pam
-----Original Message-----
From: Josh Berkus [mailto:josh@agliodbs.com]
Sent: Friday, October 04, 2002 6:42 PM
To: Pam Wampler; pgsql-novice@postgresql.org
Subject: Re: [NOVICE] pg_dump & restore question regarding creating with
seri al
Pam,
> 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?
--
-Josh Berkus
Aglio Database Solutions
San Francisco