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(at)agliodbs(dot)com]
Sent: Friday, October 04, 2002 6:42 PM
To: Pam Wampler; pgsql-novice(at)postgresql(dot)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