Re: Welcome to the pgsql-bugs list!
От | Joshua D. Drake |
---|---|
Тема | Re: Welcome to the pgsql-bugs list! |
Дата | |
Msg-id | 1240949386.25579.14.camel@jd-laptop.pragmaticzealot.org обсуждение исходный текст |
Ответ на | Re: Welcome to the pgsql-bugs list! (Christine Penner <christine@ingenioussoftware.com>) |
Ответы |
Re: Welcome to the pgsql-bugs list!
(Raymond O'Donnell <rod@iol.ie>)
|
Список | pgsql-general |
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@postgresql.org: > > > >approve Y83ezg unsubscribe pgsql-bugs christine@ingenioussoftware.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@postgresql.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@postgresql.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@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
В списке pgsql-general по дате отправления: