Re: Welcome to the pgsql-bugs list!

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

On Tue, 2009-04-28 at 12:59 -0700, Christine Penner wrote:
> After looking closer at the log file I found something interesting:

> 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.

No it will not delete things first. I think that would be a serious
design flaw if it did so.


> 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?

You can pass flags that will do various things such as that.. See:

http://www.postgresql.org/docs/8.3/static/app-pgdump.html
http://www.postgresql.org/docs/8.3/static/app-pgrestore.html

Sincerely,

Joshua D. Drake


> 
> 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.
> 
> 
-- 
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997