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,
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
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 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
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
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 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
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
>
> > 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..
>
> > 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
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
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
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
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
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 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
> 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
>> 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
> 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
19 matches
Mail list logo
