Hi everybody, can anyone tell me if there's a way to retrieve the select
instruction executed from the catalogs, or maybe via some structure in a
trigger?
The reason is that i have some selects constructed on-the-fly (just part of
it) and i want to save that in a table in order to know what are
Can you just use the SQL logging and read that file afterwords?
/djb
- Original Message -
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, November 07, 2003 14:59
Subject: Re: [GENERAL] [ADMIN] [HACKERS] retrieve s
How can I do from postgresql.conf?
From: Bruce Momjian <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
CC: Edwin Quijada <[EMAIL PROTECTED]>,[EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: [GENERAL] Recovery Data Cant Be!!!
Date: Fri, 7 Nov 2003 16:31:43 -0500 (EST)
Tom Lane wrote:
> Bru
OKi
how can I do that from postgresql.conf?
*---*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-
Hi all,
I have two databases set up, one for development and one forproduction. They are almost identical. I noticed that a query wastaking about 6.7 seconds to execute on the development database, butonly .08 seconds on the production database. The only difference wasthere was another key for
If the table doesn't have to be 100% accurate, you could always timestamp
the rows and have connected clients update their row, while old rows get
reaped periodicaly.
On Fri, 7 Nov 2003, Boris Popov wrote:
> I do want them to be visible to everybody. This is a sessions pool,
> where sessions ar
Sure you can, and in fact that's the only place that will work for
Edwin's problem. He hasn't *got* a psql session, because postmaster
startup is failing
Please, How can I do that
*---*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*
Hello Dennis,
Friday, November 7, 2003, 1:29:32 PM, you wrote:
DG> Boris Popov wrote:
>>Hello pgsql-general,
>>
>>I'm trying to implement a table with rows that are automatically
>>deleted when the session that inserted them disconnects, sort of like
>>our own alternative to pg_stat_activity. Is
Hello pgsql-general,
I'm trying to implement a table with rows that are automatically
deleted when the session that inserted them disconnects, sort of like
our own alternative to pg_stat_activity. Is it possible and what
approach should I be trying to achieve such a thing?
Thanks!
--
-Boris
-
On Fri, 2003-11-07 at 19:11, Mark Harrison wrote:
> I have indexed two columns in a table. Can somebody explain to me why
> the first query below uses an Index Scan while the second uses a Seq
> Scan?
The first expects to find a single row, the second expects to find 17000
rows, a significant por
I have indexed two columns in a table. Can somebody explain to me why
the first query below uses an Index Scan while the second uses a Seq
Scan?
Many TIA!
Mark
planb=# \d abcs
Table "public.abcs"
Column | Type | Modifiers
-
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Oh, I never realized it would work with damage that severe.
I'm not sure it will, but it's his best shot.
Actually, I think there is a TODO item here. In most cases where
a page is being touched during WAL replay, we have a complete image of
the page s
You're likely looking for pgfsck:
http://svana.org/kleptog/pgsql/pgfsck.html
Strong medicine, please backup your $PGDATA directory before playing
there, as you might wind up breaking things.
What's the exact error message in your logs when the database won't start
up?
The problem you're see
Hello,
Can you please help me in understanding how constants are stored in
postgresql. How is the datum data structure used for the same.
Thanks
Shalu
---(end of broadcast)---
TIP 8: explain analyze is your friend
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Edwin Quijada wrote:
>> Where set zero_damaged_pages ??
> You can't set it from postgresql.conf.
Sure you can, and in fact that's the only place that will work for
Edwin's problem. He hasn't *got* a psql session, because postmaster
startup is failing.
> -Original Message-
> From: Thomas LeBlanc [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2003 8:58 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Visio Like Tool
>
>
> Is there a tool for designing databases(ERD to data Design)
> and being able
> to generate scripts or d
Edwin Quijada wrote:
>
> Where set zero_damaged_pages ??
You can't set it from postgresql.conf. It has to be set in your psql
session:
SET zero_damaged_pages = true;
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-100
This is the way to do that?
./pgfsck -D /usr/local/pgsql/data -da union_seguros >
/var/lib/pgsql/bak_union
What is the correct setting to never do that?
What is a solid storage subsystem?
fsync=false ?
write cache enabled?
Can you explain me this?
Postgres
I use IDE disk
*---
I am trying running up using
pg_ctl -D /data/dir -l logfile
This is the last 100 lines from log
The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.
LOG: databas
Where set zero_damaged_pages ??
*---*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Edwin Quijada wrote:
> >> Where set zero_damaged_pages ??
>
> > You can't set it from postgresql.conf.
>
> Sure you can, and in fact that's the only place that will work for
> Edwin's problem. He hasn't *got* a psql session, because
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Here is my logic. I am having trouble getting the big picture on this:
Th big picture is that it doesn't work very well to assume that indexes
only need to handle same-datatype comparisons. I think we are
ultimately going to have to address that issue
Hi!!!
This is my log after break down::
There is a app to fix the database.
The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.
LOG: database system was interrupt
Hi all,
This is not so much a question specific to PostgreSQL, but rather a
general "application of theory" type of problem!
I did post this on comp.databases.theory but received no replies there.
If anyone here is interested and this is a suitable forum in the
PostgreSQL hierarchy, that w
> Quoting [EMAIL PROTECTED]:
>
>> Is there any kind of mechanism in pg 7.3 for doing something like
>> what I would describe as a "login trigger" procedure to run
>> when a user connects to the database?
>>
>
> Berend,
>
> I've got something like that setup on an e-communities site I built.
> Ther
25 matches
Mail list logo
