Re: Problems recovering sequences from a backup done with pg_dump

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: David Sáez Palacios <david(dot)test(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems recovering sequences from a backup done with pg_dump
Date: 2005-04-11 02:44:17
Message-ID: 20050411024417.GA16234@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Apr 06, 2005 at 10:18:34AM -0100, David Sáez Palacios wrote:
>
> I've done a dump from a PostgreSQL 7.4.5 using pg_dump and it worked find.
> The problem comes when I restore the backup and all the sequences values are
> 1. I can fix the problem manually giving the sequeces their appropiate value
> but I wonder wether is a way to force pg_dump to store this information.

I just did some simple tests with 7.4.7 and sequence values were
restored. What commands are you running? Could you provide a
complete test case that demonstrates the problem?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Theo Galanakis 2005-04-11 03:19:26 Pg_autovacuum script.
Previous Message John DeSoi 2005-04-11 02:44:12 Re: PostgreSQL 8.0 installation on Windows XP installation