Restore Crashes Postgres

From: Christine Penner <christine(at)ingenioussoftware(dot)com>
To: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Restore Crashes Postgres
Date: 2009-04-28 15:43:41
Message-ID: 19740419022720.59EC3933380CB4BD@priv-edtnaa07.telusplanet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2009-04-28 16:47:28 Re: Restore Crashes Postgres
Previous Message Katz, Lawrence 2009-04-28 15:18:23 "ERROR: 42883: could not identify an ordering operator for type polygon"