Re: [ADMIN] Schema diagramming tool?

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

[ADMIN] problems with access into system catalogs

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

Re: [ADMIN] problems with access into system catalogs

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

Re: [ADMIN] Very long IDLE in transaction query

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

Re: [ADMIN] Creating Multiple Instance

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

Re: [ADMIN] ERROR: invalid memory alloc request size 4294967293

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

Re: [ADMIN] Memory Problem

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

Re: [ADMIN] PGOPTIONS and default_tablespace

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

Re: [ADMIN] what is the origin of postgreSQL time

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

[ADMIN] update performance 8.1.4

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

Re: [ADMIN] Idle transactions

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

Re: [ADMIN] Idle transactions

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

Re: [ADMIN] Sequence update function?

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?

Re: [ADMIN] how to view all database,tables,users

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;

Re: [ADMIN] infinite blocking statements in 8.2.3

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 killing

Re: [ADMIN] infinite blocking statements in 8.2.3

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 killing

Re: [ADMIN] infinite blocking statements in 8.2.3

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

[ADMIN] infinite blocking statements in 8.2.3

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 PID). But these hanging connections (which blocks other statements infinitly) cant be killed. the only way is a pg_ctl -m

Re: [ADMIN] infinite blocking statements in 8.2.3

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 8.2.3

Re: [ADMIN] out of memory in backup and restore

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.rafb.net/paste/results/cvD7uk33.html

[ADMIN] out of memory in backup and restore

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

Re: [ADMIN] out of memory in backup and restore

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] mailto:[EMAIL PROTECTED

Re: [ADMIN] out of memory in backup and restore

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, logfile content see http://www.rafb.net

Re: [ADMIN] out of memory in backup and restore

(not as 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, free diskspace