Re: pg_dump & restore question regarding creating with s

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