Hm i have no idea how to rewrite 'OR' conditions with subqueries as joins
(exept using 'UNION' as writen end of my message)
Are you sure it is possible?
WHERE
(parent_id IN (SELECT tt.id FROM el_comment as tt WHERE tt.user_id=112 AND
tt.status=1))
OR
(text_id IN (SELECT el_text.id FROM el_text WH
Could you please keep this inline. Is there some reason the community
should not be able to read about debug logic? I asked this question
last week, no reply. Now, Mr. Dan is asking the same.
'What is the logic being followed here by ctid verification? You collect
from the original db the loc
Hey Tom,
I've finished some vacuums on the table with the following results. I'll
continue to run a couple more of these vacuums, but if you don't see another
post from me in the next couple of hours, you can assume that they continue
to look clean as well.
Thanks again for any clues on thi
\l and \l+ show only the database name, owner and description.select * from pg_database does not have date info, either.I would like to know when each of my databases were created.Thanks,Jessica
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business.
> \l and \l+ show only the database name, owner and description.
> select * from pg_database does not have date info, either.
>
> I would like to know when each of my databases were created.
The only solution I can think of is querying
select oid, datname from pg_database;
and then look up the
I don't
believe it's stored in the database. The closer you can get is to check the
date/timestamp of PG_VERSION file or possibly any file that may have an earlier
date/timestamp, under your database base subdirectory
($PGDATA/base/your_database_oid/). For instance, for a database with OID
It didn't seem to work I just checked one $PGDATA/base directory, they all have today's time stamp (9/20/06) around 6:00 am this morning, that was when my daily database dump cron job was running... thanks anyway Chris Mair <[EMAIL PROTECTED]> wrote: > \l and \l+ show only the database na
Thanks, but I still can't get the database creation date% cat PG_VERSION8.116% ls -lt PG*-rw--- 1 postgres users 4 Jun 22 10:34 PG_VERSIONThis date was the date that the Postgres server was upgraded to 8.1 and the timestamp of this file is same under each of all database directo
> It didn't seem to work
>
> I just checked one $PGDATA/base directory, they all have today's time
> stamp (9/20/06) around 6:00 am this morning, that was when my daily
> database dump cron job was running...
You can check the PG_VERSION file under each database's directory as
Husam said..
> Thanks, but I still can't get the database creation date
>
>
> % cat PG_VERSION
> 8.1
>
> 16% ls -lt PG*
> -rw---1 postgres users 4 Jun 22 10:34 PG_VERSION
>
> This date was the date that the Postgres server was upgraded to 8.1
> and the timestamp of this file is same un
Is there a way to get diagnostics on current connections to the database? Specifically I am looking for:1. How many current connections are there?2. Who is connected (user name, database and from what IP address)?
3. When was the last time the connection was used?4. When was the connection establi
Query the
pg_stat_activity.
For more
detailed stats activities, you may query the pg_stat_* and pg_statio_*
system views.
http://www.postgresql.org/docs/8.0/static/monitoring.html
--
Husam
http://firstdba.googlepages.com
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Be
Make that:
http://www.postgresql.org/docs/8.1/static/monitoring.html
8.1 docs rather.. :)
--
Husam
http://firstdba.googlepages.com
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tomeh,
HusamSent: Wednesday, September 20, 2006 11:22 AMTo: Aaron
Bono; pgsql adm
On 9/20/06, Tomeh, Husam <[EMAIL PROTECTED]> wrote:
Make that:
http://www.postgresql.org/docs/8.1/static/monitoring.html
8.1 docs rather.. :)
--
Husam
http://firstdba.googlepages.com
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Tomeh,
HusamSent: Wednesda
The
backend_start column in pg_stat_activity system view gives you the start
time of the backend connection which's what you see in the ps command;
however, the query_start column should give you the start time of last
query within the connection. The values of these columns may not be
nec
I wrote some slony task based documentation for Pervasive a few months
back. Now that they've decided to opt out of the postgres community I
understand they will be turning over the documentation to the community.
Hopefully we'll be able to make some use of this stuff. Unfortunately, I'm
not s
Hi All-
Hopefully someone here has some OpenSSL expertise and can help me with a
problem I'm running into...
My main goal is to build Postgres with ssl enabled - building on Windows
using MinGW; to do that I need a server.crt and server.key file generated
from OpenSSL. So here's what I've d
--
Med venlig hilsen/Kind regards
Thomas Damgaard Nielsen
http://thomasdamgaard.dk
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On Wed, Sep 20, 2006 at 03:33:18PM -0500, Jeanna Geier wrote:
> Hopefully someone here has some OpenSSL expertise and can help me with a
> problem I'm running into...
[...]
> So, I changed to the openssl-0.9.8c directory to build my keyfile and
> certificate and am having no luck and could really
19 matches
Mail list logo
