Re: Welcome to the pgsql-bugs list!

After looking closer at the log file I found something interesting:

2009-04-27 17:38:38 PDT ERROR: column "f_township" of relation
"fire_report" does not exist at character 3584. Almost every insert
got an error about a duplicate primary key. That shouldn't happen
because all these records were in a Postgres database without any duplicates.

This backup included the table creating aswell. How can it not have a
column in the table. Am I wrong to assume that when I restore over an
existing database it will delete things first? It looks like it doesn't.

I'm going to guess that's the problem. I know we have had at least
one crash loading an empty database but I will have to look at that
when it happens again.

How are backups and restore's usually done? I'm guessing not through
pgAdmin. Also is there away to tell it to drop a table before it
tries to create it?

Christine

At 09:08 AM 22/04/2009, you wrote:
>Content-Type: text/plain; charset="us-ascii"
>Content-Disposition: inline
>Content-Transfer-Encoding: binary
>Content-Description: Welcome to the pgsql-bugs list!
>Content-Language: en
>
>Welcome to the pgsql-bugs mailing list!
>Your password at postgresql.org is
>
>Y83ezg
>
>To leave this mailing list, send the following command in the body
>of a message to majordomo(at)postgresql(dot)org:
>
>approve Y83ezg unsubscribe pgsql-bugs christine(at)ingenioussoftware(dot)com
>
>This command will work even if your address changes. For that reason,
>among others, it is important that you keep a copy of this message.
>
>To post a message to the mailing list, send it to
> pgsql-bugs(at)postgresql(dot)org
>
>If you need help or have questions about the mailing list, please
>contact the people who manage the list by sending a message to
> pgsql-bugs-owner(at)postgresql(dot)org
>
>You can manage your subscription by visiting the following WWW location:
>
><http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org/christine%40ingenioussoftware.com>
>
>
>Content-Type: text/plain; charset="ISO-8859-1"
>Content-Disposition: inline
>Content-Transfer-Encoding: binary
>Content-Description: List Information
>Content-Language: en
>
> Put the text of the welcome message here.