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.
There was already a
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
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
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
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 postmaster
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
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:
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
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-1001
-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 databases
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.
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
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
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
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
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
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
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 it
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
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 are
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
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
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:
Bruce
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 statement
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
25 matches
Mail list logo
