ImmediateInterruptOK, and check for interrupts if needed.
+ */
+ ImmediateInterruptOK = save_ImmediateInterruptOK;
+ if (save_ImmediateInterruptOK)
+ CHECK_FOR_INTERRUPTS();
}
else
{
--
Laurette Cisneros, L.D.
The Database
InterruptPending: $1 = 65537
proc_exit_inprogress: $2 = 0
ProcDiePending: $3 = 1
ImmediateInterruptOK: $4 = 0
InterruptHoldoffCount: $5 = 0
CritSectionCount: $6 = 0
Thank again,
Laurette
On Thu, 13 Feb 2003, Tom Lane wrote:
Laurette Cisneros [EMAIL PROTECTED] writes:
Ok, it reproduced today
pgsql_008d8738 not
found
Thanks,
--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
--
No man is wise enough by himself
-- Titus Maccius Plautus
(254 Bc - 184 BC), Miles Gloriosus
in regards to
soloton transactions?
Thanks,
--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
--
No man is wise enough by himself
-- Titus Maccius Plautus
(254 Bc - 184 BC), Miles Gloriosus
is that one or more backend processes isn't exiting in a timely
fashion after receiving SIGTERM. It would be useful to see what these
backends are doing. Can you attach to each one with gdb and get a stack
trace?
regards, tom lane
--
Laurette Cisneros, L.D
Sure, next time it happens. I'm back up again.
On Thu, 13 Feb 2003, Tom Lane wrote:
Laurette Cisneros [EMAIL PROTECTED] writes:
Ok, it reproduced today on my development server.
Boy, it sure looks like everything's just sitting idle waiting for
client input, and hasn't noticed your
.
On Wed, 12 Feb 2003, Tom Lane wrote:
Laurette Cisneros [EMAIL PROTECTED] writes:
When I do a shutdown:
$pgpath/bin/pg_ctl -D $datadir -m fast stop
the server will not completely shutdown.
Hm. -m fast tells the postmaster to send SIGTERM to all the existing
backends, and then quit when
,
--
Laurette Cisneros, L.D.
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
--
No man is wise enough by himself
-- Titus Maccius Plautus
(254 Bc - 184 BC), Miles Gloriosus
---(end of broadcast
find if there was any corruption in the data
for those tables? Will vacuum find this out? Is there some other tool
that can be used to hunt down corruption? This is to double check if any
harm was done by the out of space event.
Thanks,
--
Laurette Cisneros, L.D.
The Database Group
(510) 420
Ah, yes, of course. This was not included on the 8.0 distribution CDs I
have...but I found it on Suse ftp site. All is well now.
Thanks for the help!
L.
On Sun, 12 Jan 2003, Peter Eisentraut wrote:
Laurette Cisneros writes:
On Suse 8.0, I'm trying to compile postgresql 7.3.1
for help,
Laurette
On Wed, 16 Oct 2002, Bruce Momjian wrote:
See FAQ item on sizing.
---
Laurette Cisneros wrote:
Is there an easy way to do file size estimates for the data storage for the
each table, each database
Ok, color me silly. I've found pg_statistic and with a few joins and the
FAQ, I have the information I'm looking for. Nix this last email.
Thanks,
L.
On Thu, 17 Oct 2002, Laurette Cisneros wrote:
Yes, indeed. Somewhat helpful. But, doesn't tell me how to find out what
the maximum size
Is there an easy way to do file size estimates for the data storage for the
each table, each database and the whole system if the size of each row per
table is known (but of course includes text fields)?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information
The client needs to run on windows.
On Wed, 25 Sep 2002, Jean-Luc Lachance wrote:
Why not use telnet???
Laurette Cisneros wrote:
I don't suppose anyone has this compiled for win2000 already as I don't
have MSVC++ available?
L.
On Sat, 21 Sep 2002, Peter Eisentraut wrote
I don't suppose anyone has this compiled for win2000 already as I don't
have MSVC++ available?
L.
On Sat, 21 Sep 2002, Peter Eisentraut wrote:
Laurette Cisneros writes:
Is there a command line client to run sql against a postgresql server (on a
linux box elsewhere) available for windows
dog slow!
I can't compile psql because I don't have MS C++.
Any other ideas on what I can do or how to speed up any of these?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
---
NextBus say
Is there a command line client to run sql against a postgresql server (on a
linux box elsewhere) available for windows?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
---
Riders prefer to arrive
for:
pg_aggregate - aggowner
pg_class - relowner
pg_operator - oprowner
pg_proc - proowner
pg_type - typowner
in each database.
YET, I still have problems as my java program fails with an error:
pg_aclcheck: invalid user id 111
Is there something else I am missing?
Thanks for the help,
--
Laurette
Hi all,
My c is rusty and you are all pros!...so...
I want to write a server routine that will return a string so that when SELECT
retstr() from tbl; is executed this string is returned.
What's the best way to do this?
i.e.
create:
CREATE FUNCTION retstr() RETURNS char???
AS
,
Laurette
On Tue, 24 Jul 2001, Tom Lane wrote:
Laurette Cisneros [EMAIL PROTECTED] writes:
Here's the stack track from the core file:
#1 0x4013c445 in fprintf (stream=0x0,
format=0x4001966f nbpointdist\n) at fprintf.c:32
Sure looks like you're trying to write on a non-open file (stream=0
=0x81aeb7c _fini, rtld_fini=0x4000d3c4 _dl_fini,
stack_end=0xb834) at ../sysdeps/generic/libc-start.c:129
On Sat, 21 Jul 2001, Tom Lane wrote:
Laurette Cisneros [EMAIL PROTECTED] writes:
Any idea what status 139 indicates?
SIGSEGV core dump, on most systems. Look for the backend core
:
Laurette Cisneros [EMAIL PROTECTED] writes:
Any idea what status 139 indicates?
SIGSEGV core dump, on most systems. Look for the backend core file
(in $PGDATA/base/yourdb/core) and send us a gdb stack trace ...
also, it would help to know what PG version you are running, on
what platform
status 139 indicates?
Thanks,
--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
23 matches
Mail list logo