Hello everybody.
Is there any way to check database status, or who is currently connected
to it.
I tried to drop database and got an error saying that other users using
this database.
So I wanted to see who is connected right now to the database.
One more question is how can I see all tables in t
Hello,
I was wondering if there was a way in postgres to monitor
database sessions.
I'd like to be able to get a list of currently open sessions
with information like user id, connection time etc.
Also I'd like to be able to see a history of sessions; again
user id with session start & end tim
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
Hello everybody.
Is there any way to check database status, or who is currently connected to it.
I tried to drop database and got an error saying that other users using this database.
So I wanted to see who is connected right now
On Tuesday, January 15, 2002, at 07:08 PM, Roman Gavrilov wrote:
David Stanaway wrote:
On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:
One more question is how can I see all tables in the template1 ?
Thanks allot.
in the psql client: psql template1
\dt
\h is definat
Yes I would like to see system tables, that is correct is there any
way to see all those tables.
For example in MySQL there is mysql database where you have all system
tables.
David Stanaway wrote:
On Tuesday, January 15, 2002, at 07:08 PM, Roman
Gavrilov wrote:
David Stanaway
wrote:
On Wednesday, January 16, 2002, at 07:09 PM, Roman Gavrilov wrote:
Yes I would like to see system tables, that is correct is there any way to see all those tables.
For example in MySQL there is mysql database where you have all system tables.
Please read the documentation. I have already told y
> Hello,
>
> I was wondering if there was a way in postgres to monitor
> database sessions.
>
> I'd like to be able to get a list of currently open sessions
> with information like user id, connection time etc.
>
> Also I'd like to be able to see a history of sessions; again
> user id with ses
>> Hello,
>>
>> I was wondering if there was a way in postgres to monitor
>> database sessions.
>>
>> I'd like to be able to get a list of currently open sessions
>> with information like user id, connection time etc.
>>
>> Also I'd like to be able to see a history of sessions; again
>> user
> Good to know, but limited. to get the historical info, you'd have to continually
>spawn
> ps and either generate a lot of overhead or miss events.
>
> I think Stephen and I have roughly similar desires (ref "Logging Access" Sun, 03 Oct
>1999 23:09:06 -0400)
> It's not too hard to get the back
At 05:23 +0200 on 12/10/1999, Bruce Momjian wrote:
> The postmaster/postgres -d option can echo tons of information you many
>need.
> Postmaster -d will show connections, and postgres -d shows queries and
> other info. Postgres -E is good too.
If I may be so bold, I must say that the backend lo
On Tue, 12 Oct 1999, Herouth Maoz wrote:
> Date: Tue, 12 Oct 1999 15:22:10 +0200
> From: Herouth Maoz <[EMAIL PROTECTED]>
> To: Bruce Momjian <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: [ADMIN] Monitoring Database Sessions
>
> At 05:23 +0200 o
At 15:43 +0200 on 12/10/1999, Oleg Bartunov wrote:
> Cool ! Then we could use standard log-analyzers to produce
> any usage statistics.
Things will have to be considered before this can be done. The main problem
is that there is no way you can delimit a query and be sure the delimiter
is not in
Bruce Momjian wrote:
> > like logging to be up to modern-day quality expectations (e.g. filterable,
>routable, and securable) and to record not only basic session info, but statistical
>info to assist in tuning.
> >
> > So, returning to my own question. Is any such presently available that I'm
OK, It looks like there's at least some interest in having a
true logging facility for the PostgreSQL backend. I've
researched the source code and feel fairly certain that I
can provide a patchset that would provide information useful
to an administrator without having an unfortunate impact on
rel
hi..
> that. Having made that constraint, I see 3 contexts:
>
> 1) Server events. E.g.:
> 2) User sessions.
> 3) Transactions.
>
how about 3 different logs? pg_server.log, pg_sessions.log, pg_trans.log or
something along those lines.. that way you could parse each file as they would
each have a
> hi..
>
> > that. Having made that constraint, I see 3 contexts:
> >
> > 1) Server events. E.g.:
> > 2) User sessions.
> > 3) Transactions.
> >
>
> how about 3 different logs? pg_server.log, pg_sessions.log, pg_trans.log or
> something along those lines.. that way you could parse each file as
>
> > that. Having made that constraint, I see 3 contexts:
> >
> > 1) Server events. E.g.:
> > 2) User sessions.
> > 3) Transactions.
> >
>
> how about 3 different logs? pg_server.log, pg_sessions.log, pg_trans.log or
> something along those lines.. that way you could parse each file as they woul
Hi,
I have a query about a backup policy that I wish to implement.
Currently, we are running a PostgreSQL server with a very large database
on it. The database consists of a core of read-only tables, with tables
created by the users going by default into the user's own schemas. For
backup
On Friday 14 October 2005 06:19, Chris Jewell wrote:
> Hi,
>
> I have a query about a backup policy that I wish to implement.
> Currently, we are running a PostgreSQL server with a very large database
> on it. The database consists of a core of read-only tables, with tables
> created by the users
Hi,
Yes, diff would work and is my current plan, but it requires me to
perform the backup first. What I needed really was a system by which a
backup would only be run if there was something that needed backing up.
Thanks anyway,
Chris
--
Chris Jewell, BSc(Hons), BVSc, MRCVS
Dept of Maths a
On Fri, Oct 14, 2005 at 07:29:31PM +0100, Chris Jewell wrote:
> Hi,
>
> Yes, diff would work and is my current plan, but it requires me to
> perform the backup first. What I needed really was a system by which a
> backup would only be run if there was something that needed backing up.
I believ
Chris,
If you have a JDBC driver for pgsql, you can use SchemaCrawler.
https://sourceforge.net/project/showfiles.php?group_id=148383
SchemaCrawler is a free, open source tool that can produce database
schema metadata and/ or data output in a diff-able format.
Sualeh.
Chris Jewell wrote:
> Hi,
22 matches
Mail list logo