Hi,
give db visualizer a try.
best regards
Thomas
Am 04.09.2012 18:35, schrieb Craig James:
Can anyone recommend a good tool for producing a good drawing of an
existing database schema? I don't need a design tool, but rather one
that can take an existing schema and produce a nice diagram tha
Hi Craig,
thanks, that was the tip
a rollback prepared on these does the job
best regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi,
see below
Am 26.07.2012 10:25, schrieb Craig Ringer:
First, thank-you for an excellent complete question with versions,
EXPLAIN ANALYZE, and exact messages.
;)
- Do you have any uncommitted two phase transactions? Run:
SELECT * from pg_prepared_xacts ;
hm yes, i stopped all applicati
Hi,
I have 2 systems with CentOS 5.5 (2.6.18) x86_64, postgresql-9.0.6 64bit
both systems contains the same content. But one system make troubles.
some system tables (eg pg_catalog.pg_class or pg_attribute) contain much
dead rows and all simple query take much time on one system. the other
on
Hi Gnanam,
I assume your not ending your transactions with commit or rollback. When
using a connection pooler your connection is reused for next request. So
if one request does something that initiates an implizit BEGIN (like an
UPDATE/INSERT) without a COMMIT or ROLLBACK this connection remai
Hi,
thats possible. Dont forget so set another port in your postgresql.conf
Thomas
Am 13.12.2011 09:23, schrieb Selva manickaraja:
Hi All,
We are planning to create a 2nd instance of postgres db in the same
server. The reason is simple. After we added another application, the
number of WAL(
hi,
looks like a 32bit version so 4294967293 is too much (4GB). Use a 64bit
version
regards
Thomas
Am 04.01.2011 14:48, schrieb Victor Hugo dos Santos:
Hello,
Actually I use postgresql version 8.4.6-0ubuntu10.04 in bacula server
to save information about backups from bacula.
But, 2 days a
hi,
i assume you have a 32bit system so you cant set shmmax to 4gb. as a
side effect your value 4294967296 in a binary 32bit representation is
exactly 0. look for previous threads about shmmax. and use a 64bit system :)
regards
thomas
Nicolas Michel schrieb:
Hi here,
Our server had 2GB of
hi,
try
set PGOPTIONS="-c default_tablespace='pgdata'"
regards
thomas
jan-peter.seif...@gmx.de schrieb:
Hello,
without success I tried to set the default tablespace via the environment
variable PGOPTIONS.
My tries:
set PGOPTIONS="default_tablespace='pgdata'"
set PGOPTIONS=default_tablesp
beware of timezone dst offset. try
select current_timestamp AT TIME ZONE 'MEST'
thomas
Julius Tuskenis schrieb:
Hello,
I have problem with postgreSQL current_timestramp. Where does it get
its value, because it doesnt match system time. The problem appeared
after this saturday-sunday night an
Hi,
How can I speed up updates?
i try an
update tablename set datecol=null
~ 2.3 mio rows
After 6 hours, this was still not finished. selects and inserts are ok.
System is a dual xeon, 8gb ram, debian 64bit, pg 8.1.4
thanks
thomas
--
Thomas Markus
Tel:+49 30 29 36 399 - 22
Fax
check your jboss log for stack traces.
Mateus Interciso schrieb:
Thanks for your reply.
Is there any way on PostgreSQL that I can see the transaction that
haven't been commited?
This would simplify the debugging.
Thanks a lot.
Mateus.
---(end of broadcast)-
Hi,
it means that a transaction isn't finished (commit/rollback). check your
application for long running operations or programmming errors.
tm
Mateus Interciso schrieb:
Hello, it's been a while that I'm seeing that our servers running JBoss
with PostgreSQL, after some hours of work, have at
do a
select setval('sequence',max(col)+1) from tablename
for each table
tm
Uwe C. Schroeder schrieb:
Hi,
just thought I ask before I start doing it myself: Has anyone ever written a
stored procedure (or any other means) of syncing the sequence to the max #
key in the corresponding tables?
use tables/views in scheme pg_catalog/information_schema
try
select * from pg_catalog.pg_database;
select * from pg_catalog.pg_user;
select * from pg_catalog.pg_tables;
Mondi Ravi schrieb:
i can't find out command to show all databases,tables,users and
integrity constraints relationships;
you
can stop
these also only with kill -9.
Does someone have an idea where the problem is and as I this to avoid can?
thx
Thomas
Thomas Markus schrieb:
I'm running 8.2.3 on ubuntu 6.06 (2.6.15-26-server SMP i686)
sometimes i have SELECTs that never ends. Normally I drop connections
by ki
ent. I can stop
these also only with kill -9.
Does someone have an idea where the problem is and as I this to avoid can?
thx
Thomas
Thomas Markus schrieb:
I'm running 8.2.3 on ubuntu 6.06 (2.6.15-26-server SMP i686)
sometimes i have SELECTs that never ends. Normally I drop connect
a connection (produces rollback) always however this
special connection could not not be terminated. Normally I could do
this. I will observe whether the behavior again arise.
Alvaro Herrera schrieb:
Thomas Markus wrote:
thanks for your awnsers
i cant repeat the problem after increasing
thanks for your awnsers
i cant repeat the problem after increasing autovacuum_naptime to 5min. a
vacuumdb -f -a runs over night (and finished :) ) and now that blocking
statement finished after some seconds. it seems autovacuum = on is not
enough.
Thomas Markus schrieb:
I'm running
I'm running 8.2.3 on ubuntu 6.06 (2.6.15-26-server SMP i686)
sometimes i have SELECTs that never ends. Normally I drop connections by
killing the connection process (kill ). But these hanging
connections (which blocks other statements infinitly) cant be killed.
the only way is a pg_ctl -m imme
Hi,
12h is a lot. i use the copy statement with binary option. this is
faster and takes less space.
try pg_dump with schema only and export your 2 tables with 2 single
statements. in that way i can
export my db in less than 3min without downtime (pg_dump produces a 9gb
file, binary dump 4.4gb)
say pg_dump to use a copy command with option 'with
binary'? it should be possible with the custom or tar format. i searched
the docs and manpage and cant find something.
thx
Thomas
Tom Lane schrieb:
Thomas Markus <[EMAIL PROTECTED]> writes:
logfile content see http://www.
insert statements, maybe directly dbblocks)?
Marcelo Costa schrieb:
To decrease shared buffers you need restart your pgsql.
If do you make on df -h command what is the result, please send.
2006/12/15, Thomas Markus < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
Hi,
fr
memory. Not sure if that will help but try
increasing the swap space...
-
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com <http://www.enterprisedb.com>)
On 12/15/06, *Thomas Markus* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi,
logfil
the dbserver logs and syslog at the same time when
it goes out of memory...
Also how much is available RAM you have and the SHMMAX set?
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com <http://www.enterprisedb.com>)
On 12/15/06, *Thomas Markus* <[EMAIL PROTECTED]
<m
Hi,
i'm running pg 8.1.0 on a debian linux (64bit) box (dual xeon 8gb ram)
pg_dump creates an error when exporting a large table with blobs
(largest blob is 180mb)
error is:
pg_dump: ERROR: out of memory
DETAIL: Failed on request of size 1073741823.
pg_dump: SQL command to dump the contents
26 matches
Mail list logo