Re: Restore Crashes Postgres

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(at)ingenioussoftware(dot)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(at)ingenioussoftware(dot)com
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
> >
>