Postgres Pro
Downloads
Home   >   mailing lists

Problems recovering sequences from a backup done with pg_dump - Mailing list pgsql-admin

From David Sáez Palacios
Subject Problems recovering sequences from a backup done with pg_dump
Date
Msg-id 73eeb6bd0504060418ef760cc@mail.gmail.com
Whole thread Raw
Responses Re: Problems recovering sequences from a backup done with pg_dump
List pgsql-admin
Tree view
Hi all,

    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. Any help will be welcome!

            Thanks in advance,

                                                David Saez Palacios.

pgsql-admin by date:

Previous
From: "Fernando Andreacci"
Date:
Subject: conection erro
Next
From: "Abdul Shakoor"
Date:
Subject: PostgreSQL 8.0 installation on Windows XP installation