From: | Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com> |
---|---|
To: | josh(at)agliodbs(dot)com, Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: pg_dump & restore question regarding creating with s |
Date: | 2002-10-05 01:33:12 |
Message-ID: | 2E4528861499D41199D200A0C9B15BC001D50675@FRISTX |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Pearce | 2002-10-06 11:23:33 | psql |
Previous Message | Giles Lean | 2002-10-05 00:09:23 | Re: PostgresQL applications using libpq |