Re: Restore Crashes Postgres
От | Allan Kamau |
---|---|
Тема | Re: Restore Crashes Postgres |
Дата | |
Msg-id | 49F73320.3030804@sanbi.ac.za обсуждение исходный текст |
Ответ на | Restore Crashes Postgres (Christine Penner <christine@ingenioussoftware.com>) |
Ответы |
Re: Restore Crashes Postgres
|
Список | pgsql-general |
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 по дате отправления: