Skip site navigation (1) Skip section navigation (2)

Re: pg_dump & restore question regarding creating with seri al

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com>,pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_dump & restore question regarding creating with seri al
Date: 2002-10-04 22:42:24
Message-ID: 200210041542.25009.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

pgsql-novice by date

Next:From: Giles LeanDate: 2002-10-05 00:09:23
Subject: Re: PostgresQL applications using libpq
Previous:From: Pam WamplerDate: 2002-10-04 20:50:48
Subject: pg_dump & restore question regarding creating with serial

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group