From: | adrian(dot)kitchingman(at)dse(dot)vic(dot)gov(dot)au |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | postgresql-9.0 Windows service stops after database transaction |
Date: | 2010-09-24 04:39:48 |
Message-ID: | OFCB8A9345.AE48C426-ONCA2577A8.000E5F43-CA2577A8.00199E0D@nre.vic.gov.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi all
I've have a strange problem with my Windows postgresql-9.0 service
stopping after any transaction which manipulates tables in any database
(Deleting records, Inserting records, bulk importing via \copy, etc). This
problem occurs regardless whether I'm accessing the database server via
pgAdmin III on a client machine or the server itself as well as through
the command prompt. The end result it that I have to constantly restart
the postgresql service after any transactions. Sometime there is a slight
delay allowing a couple of transactions but the service is always
eventually stopped.
The problem appears to have started when I changed permissions on my
machine to allow the user 'postgres' access to the C drive following the
instructions in the last post of this thread:
http://www.jitterbit.com/PhpBB/viewtopic.php?f=5&t=869
The specs of postres environment are:
Windows XP SP3
PostgreSQL 9.0.0, compiled by Visual C++ build 1500, 32-bit
pgAdmin III 1.12.0 (Sep17 2010, rev: REL-1_12_0)
PostGIS 2.0SVN
Hope someone can shed some light on this issue.
Cheers
Adrian
Notice:
This email and any attachments may contain information that is personal,
confidential, legally privileged and/or copyright.No part of it should be reproduced,
adapted or communicated without the prior written consent of the copyright owner.
It is the responsibility of the recipient to check for and remove viruses.
If you have received this email in error, please notify the sender by return email, delete
it from your system and destroy any copies. You are not authorised to use, communicate or rely on the information
contained in this email.
Please consider the environment before printing this email.
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2010-09-24 07:05:00 | Re: postgresql-9.0 Windows service stops after database transaction |
Previous Message | Kevin Grittner | 2010-09-23 22:50:21 | Re: locking issue on simple selects? |