ImmediateInterruptOK, and check for interrupts if needed.
> + */
> + ImmediateInterruptOK = save_ImmediateInterruptOK;
> + if (save_ImmediateInterruptOK)
> + CHECK_FOR_INTERRUPTS();
> }
> else
>
.244
idle
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:
&g
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
>
erverLoop () at postmaster.c:1027
#10 0x081023fb in PostmasterMain (argc=1, argv=0x822e000) at
postmaster.c:788
#11 0x080e0a07 in main (argc=1, argv=0xb8d4) at main.c:210
#12 0x401e7177 in __libc_start_main (main=0x80e0828 , argc=1,
ubp_av=0xb8d4, init=0x806aeec <_init>, fini=0x8
erver 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),
se: portal "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
or the help,
L.
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
to handle this situation?
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
-
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
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
for crypto that can be installed.
Is it part of another package (OpenSSL is installed) or can I get it from
somewhere?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
--
Lif
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
u 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
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?
>
nd it runs 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
---
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
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
e wrong, I love postgresql.
L.
On Wed, 18 Sep 2002, Bruno Wolff III wrote:
> On Wed, Sep 18, 2002 at 13:09:07 -0700,
> Laurette Cisneros <[EMAIL PROTECTED]> wrote:
> >
> > Aren't aggregates smart enough to use an index on the column? This takes 8
> > minute
EXPLAIN
Aren't aggregates smart enough to use an index on the column? This takes 8
minutes to run! I can't see that I should have to build a functional index
(is it possible for an aggregate?) to get this to run faster?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBu
:
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,
--
How do you change the owner of an existing database?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Where's mybus?
---(end of broadcast)---
TIP 6: Have you searched our
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 '/tmp/tst.
anks again,
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
>
t, 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 file
> (in $PGDATA/base/yourdb/core) and send us a gdb stack trace ...
> also,
v=0xb83c) at main.c:175
#26 0x400fae5e in __libc_start_main (main=0x80dcc40 ,
argc=4, ubp_av=0xb83c, init=0x807dec0 <_init>,
fini=0x81aeb7c <_fini>, rtld_fini=0x4000d3c4 <_dl_fini>,
stack_end=0xb834) at ../sysdeps/generic/libc-start.c:129
On Sat, 21 Jul 2001
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
27 matches
Mail list logo
