Guys, does anyone has any idea?
pginfo wrote:
Hi,
I try to reindex and reindex run ok, but the vacuum still not running.
regards,
ivan.
Antonis Antoniou wrote:
pginfo wrote:
Hi,
I am running pg 7.3.4 on linux red hat 9.0.
If I try to execute vacuum full
Hello
They (architects) told me ER is out, UML is in. And they told me also,
that something like ER can be done in UML. I think there are some
FOSS-Tools for UML (v1.0 or v.2.0)?
Regards Oli
---
Oli Sennhauser
Database-Engineer (Oracle
On Tue, 11 Nov 2003, Antonis Antoniou wrote:
Guys, does anyone has any idea?
Are you sure that vacuum is not just waiting on a lock that some other
transaction is holding? I'd suggest checking the contents of pg_locks.
---(end of broadcast)---
Hi,
I can not be sure if it is not the case.
But we are usin this system on a number of servers and it happen only by
one.
Can I with a pg_locks help detect the query that is running?
regards,
ivan.
Stephan Szabo wrote:
On Tue, 11 Nov 2003, Antonis Antoniou wrote:
Guys, does anyone has any
pginfo wrote:
Hi,
I can not be sure if it is not the case.
But we are usin this system on a number of servers and it happen only by
one.
Can I with a pg_locks help detect the query that is running?
No the pg_locks detect only which process handle a lock on a
database object.
With pg_stat_activity
Im currently on red hat 7.3 running postgres. Everything is
running fine. Obviously, Im going to have to upgrade to RHEL 3 in order to
receive updates, etc. Does anyone know of any problems with postgres running
on RHEL 2.1 or RHEL 3?
Thanks,
Darryl
On Tue, 11 Nov 2003, pginfo wrote:
Hi,
I can not be sure if it is not the case.
But we are usin this system on a number of servers and it happen only by
one.
Can I with a pg_locks help detect the query that is running?
It won't directly tell you what statement is running (although my guess
[EMAIL PROTECTED] (Gautam Saha) wrote in message news:[EMAIL PROTECTED]...
Hi:
Is there a ER diagram tool someone can recommend for PostgreSQL?
I should be able to create ER diagram from existing database also
(reverse engineering).
Any open source product would be ideal.
Thanks,
Hi,
Thanks for the help.
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
--+--+-+---+-+-
16757 |16976 | | 23169 | AccessShareLock | t
17062 |
On Tue, 11 Nov 2003, pginfo wrote:
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
--+--+-+---+-+-
16757 |16976 | | 23169 | AccessShareLock | t
Gaetano,
er, shedloads of this
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, ,
Good morning,
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.
Thank you for your help.
Danielle Cossette
---(end of broadcast)---
TIP 7: don't forget to increase your free space map
Hi,
Stephan Szabo wrote:
On Tue, 11 Nov 2003, pginfo wrote:
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
--+--+-+---+-+-
16757 |16976 |
On Tue, 11 Nov 2003, pginfo wrote:
Stephan Szabo wrote:
On Tue, 11 Nov 2003, pginfo wrote:
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
Stephan Szabo wrote:
On Tue, 11 Nov 2003, pginfo wrote:
Stephan Szabo wrote:
On Tue, 11 Nov 2003, pginfo wrote:
The result by is:
acc01=# select * from pg_locks;
relation | database | transaction | pid | mode | granted
Danielle Cossette writes:
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
Why don't you try it out?
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
I did and had too many problems and performance issues. Solaris-
PostgreSQL just doesn't gel as wel as Linux-PostgreSQL. (ouch)
If PostgreSQL were to get retooled to work with threads the way it
works between processes today for Solaris or if someone were to find
a tweak to make the Solaris
Danielle Cossette wrote:
Good morning,
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.
Seems that solaris is the worst choice for run Postgres.
Am I completely wrong ?
Regards
Gaetano Mendola
---(end of
Shane Wright wrote:
Gaetano,
er, shedloads of this
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096)
Sounds like an opportunity for someone at Sun to fund a
little research project. Any Sun/Postgresql hackers out
there? Any Sun project managers lurking out there?
Ray
On Tue, Nov 11, 2003 at 01:37:03PM -0500, Greg Spiegelberg wrote:
I did and had too many problems and performance issues.
This message was cancelled from within Mozilla.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Tue, 11 Nov 2003, pginfo wrote:
It is possible to be one not closed transaction, but in this case nobody will be
able to modify this table (tables) and
the system will stop to respond. The paradox is that the system works well
without
Not necessarily. People are going to be
On Tue, 11 Nov 2003 13:37:03 -0500
Greg Spiegelberg [EMAIL PROTECTED] wrote:
I did and had too many problems and performance issues. Solaris-
PostgreSQL just doesn't gel as wel as Linux-PostgreSQL. (ouch)
7.4 fixes a lot of hte performance problems we've seen with PG.
I had a very strong
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) = 0
read(0, , 4096) =
Hi.
We're a hot startup company in Silicon Valley looking for a PostgreSQL DBA. We're open
to talking about this as a part-time consulting position or a full time position.
Sysadmin experience with Linux/FreeBSD is a huge plus.
Please send resumes to jobs (at) everesttech (dot) net
Thanks a
ti, 2003-11-11 kello 05:08, David F. Skoll kirjoitti:
On Mon, 2003-11-10 at 16:58, Gautam Saha wrote:
Hi:
Is there a ER diagram tool someone can recommend for PostgreSQL?
DIA isn't too bad:
http://www.lysator.liu.se/~alla/dia/
This goes from DIA to PostgreSQL:
On Tue, 11 Nov 2003, Gaetano Mendola wrote:
Danielle Cossette wrote:
Good morning,
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.
Seems that solaris is the worst choice for run Postgres.
Am I completely wrong ?
I
You ought to be able to just start up Postgres pointing to the existing
data. So assuming the
data directory is /db, just doing 'postmaster -D /db' should work.
Provided, of course, you installed the exact version that was there
before, with the same user/uid
as before.
On Nov 11, 2003, at
28 matches
Mail list logo