Christine Penner writes:
> This is the start of the log file after I tried to restore the database again:
> 2009-04-27 18:19:12 PDT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
> 2009-04-27 18:19:20 PDT LOG: loaded library
> "$libdir/plugins/plugin_debugger.dll"
> 2009-04-27 18:
On Tue, Apr 28, 2009 at 1:44 PM, Christine Penner
wrote:
> Scott:
>>
>> I'm really starting to wonder about your hardware and / or OS. Are
>> you running any anti-virus software (if so turn it off and / or
>> uninstall it)? Have you tested your machine with something like
>> memtest86+?
>
> All
I looked at the log files. The log file for one crash I had looks
like it got to loading data in one of the larger tables. Finished
inserting a record and stopped. It did complain about the fact that
the tables already existed but seemed to continue and loaded about 49
tables before it quit.
On Tue, Apr 28, 2009 at 11:56 AM, Christine Penner
wrote:
> 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 int
Christine Penner wrote:
> 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.
The PostgreSQL logs should have more info regarding the crash.
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 load
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
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
