Re: Restore Crashes Postgres
От | Christine Penner |
---|---|
Тема | Re: Restore Crashes Postgres |
Дата | |
Msg-id | 19740414223344.5B0F2B21341A04D8@priv-edtnaa06.telusplanet.net обсуждение исходный текст |
Ответ на | Re: Restore Crashes Postgres (Allan Kamau <allank@sanbi.ac.za>) |
Ответы |
Re: Restore Crashes Postgres
(Alvaro Herrera <alvherre@commandprompt.com>)
Re: Restore Crashes Postgres (Scott Marlowe <scott.marlowe@gmail.com>) |
Список | pgsql-general |
The crashes I get are the windows, this program has encountered a problem and must close, error. At that point I can't do anything with Postgres. I can't restart the service. I have to restart windows. Usually we are restoring into an already loaded database but we have gotten the crashes loading into a new (empty) database. I don't think its parent child issues. The only constraints we have are for the primary key's. Also, I'm told it doesn't matter but I always make sure I don't have the database open when I create a backup. I'm wondering if there is a better way to do a backup and restore. I'm really worried that we are going to have a client need a backup and not be able to load it. Before we release it to clients we will be using a command line to do the backup and restore but I'm pretty sure it's the same thing as running it through pgAdmin. Christine At 09:47 AM 28/04/2009, you wrote: >You may want to zero in on the problem by performing database dumps >(using pg_dump and the various options accordingly) then restore on >the failing installation using the psql command. > >Maybe (I am guessing here, you haven't elaborated on "crashes") you >may be issuing insert statements (in the pgAdmin generated file) on >previously populated tables. Or perhaps you are inserting (or >updating) dependent (child) tables without populating the parent >table while having the referential integrity constraints present. >pg_dump has an elegant way of avoiding such pitfalls. > > >Allan. > >On Tue, Apr 28, 2009 at 5:43 PM, Christine Penner ><christine@ingenioussoftware.com> wrote: > > We are in the process of converting our application to use > Postgres. We have > > about 5 computers in the office. We frequently create a database on one > > computer and then transfer it to the other computers as needed. We are > > currently doing this all through pgAdmin. > > > > We backup a data base using the default (Compress) format. We select the > > Insert Commands option. > > We use restore on the other computers to load the database. We > select the no > > owner option. > > > > Quite often this works fine but we have had a lot of crashes. Sometimes we > > are unable to load a database. Sometimes we load over an existing database > > but not always. Doesn't seem to make a difference. > > > > The big problem with the crashes is the only way to be able to use Postgres > > at that point is to restart the whole computer. > > > > We are all using 8.3.4 on Windows XP > > > > Christine Penner > > Ingenious Software > > 250-352-9495 > > christine@ingenioussoftware.com > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > > >
В списке pgsql-general по дате отправления: