I am currently running 8.1.5, but I'm willing to upgrade to whatever
version, use a patched exe, etc. Just let me know what I need to do.
On Tue, 28 Nov 2006 23:39:00 +0100, "Thomas H." <[EMAIL PROTECTED]> said:
> > Perhaps this should be #ifdef WIN32, although there's probably no harm
> > in doi
Perhaps this should be #ifdef WIN32, although there's probably no harm
in doing it on Unixen too. Can someone test this idea?
if magnus/dave could provide me a patched rc1 exe, i could run it in our
semi-productive environment for some tests.
- thomas
---(end of
Yes - processmon always shows the files being locked by postgres.exe
processes. My database is being used as a data warehouse, so about all
I am doing is bulk insert/updates. I have a job that runs every 5
minutes and loads data into the database.
I typically load between 10,000 and 100,000 r
"Jeremy Haile" <[EMAIL PROTECTED]> writes:
> Here's a few seconds of the log output (this has been going on for 10
> mins as of this e-mail being sent):
> 2006-11-28 16:16:10 LOG: could not fsync segment 0 of relation
> 1663/16404/30267: Permission denied
> 2006-11-28 16:16:10 ERROR: storage sync
I forgot to mention - this problem is occurring on multiple Windows
machines. One of them is running Windows XP Professional. The other is
running Windows Server 2003. I have disabled indexing, virus scanning,
and all non-essential services on both of them. The problem continues
to show up eve
I forgot to mention - this problem is occurring on multiple Windows
machines. One of them is running Windows XP Professional. The other is
running Windows Server 2003. I have disabled indexing, virus scanning,
and all non-essential services on both of them. The problem continues
to show up even
OK - after uninstalling the virus scanner (McAfee), I still get the same
disk access errors.
Here's a few seconds of the log output (this has been going on for 10
mins as of this e-mail being sent):
2006-11-28 16:16:10 LOG: could not fsync segment 0 of relation
1663/16404/30267: Permission denied
I'm continuing to have file-access related errors with 8.1.5 on Windows.
(see my previous post here http://tinyurl.com/yfqhnm)
Today I'm having a new problem, which results in the following log
output:
2006-11-28 12:15:45 LOG: could not rename temporary statistics file
"global/pgstat.tmp" to "gl
Santhinesh Kumar wrote:
>
> The following bug has been logged online:
>
> Bug reference: 2792
> Logged by: Santhinesh Kumar
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 7.1.3
> Operating system: Fedora - 4
> Description:not able to install postgress
> Deta
The following bug has been logged online:
Bug reference: 2791
Logged by: Raman Dabhade
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Win XP
Description:Error while commiting
Details:
ERROR: SPI_execute_plan failed executing query "commi
The following bug has been logged online:
Bug reference: 2792
Logged by: Santhinesh Kumar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.1.3
Operating system: Fedora - 4
Description:not able to install postgress
Details:
I tried to install postgress of versi
Tom,
Thank you for your input. I found a way to check for it by counting the
return from a count. Thanks again for your help.
PAT
From: Tom Lane <[EMAIL PROTECTED]>
To: "Patrick Hayes" <
On 11/28/06, Tom Lane <[EMAIL PROTECTED]> wrote:
The syntax is space-separated integers; where did you get the idea to
use commas?
I donno... I just tried and it worked. But silently ignoring invalid
input...!!???
Potential bug's symptoms:
http://www.postgresql.org/docs/current/static/bug-re
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> In the first INSERT statement, the array elements are separated by a
> comma and a space; in the second one, the ones that are separated by just a
> comma, do not get inserted!
The syntax is space-separated integers; where did you get the idea to
u
regarding pg_dump: where there some changes from b3 to rc1 that would
explain the resulting rc1 pg_dump output (-c) being half as big as with
b3?
No...
regards, tom lane
well, it was 300mb before rc1, and now its only 188mb. inbetween i did a
vacuum full on one table. that shoulnd't affect
The following bug has been logged online:
Bug reference: 2790
Logged by: Gurjeet Singh
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2beta3
Operating system: Windows
Description:constructor for int2vector seems to be buggy
Details:
I couldn't find any docum
Michael Simms wrote:
The following bug has been logged online:
Bug reference: 2784
Logged by: Michael Simms
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Linux kernel 2.6.12
Description:Performance serious degrades over a period of a mo
Gilberto Xavier wrote:
The following bug has been logged online:
Bug reference: 2786
Logged by: Gilberto Xavier
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux and Windows
Description:PGADMIN 1.6
Details:
Where was set the backup a
18 matches
Mail list logo