[SQL] To find process that lock a table

Hello , do you know how to find a process that is locking a table ? I try to run a vacuum analyze , an it take a state of waiting , I canceled it after 20 minutes , then I try to run an analyze and the same happen, take a state waiting. see youu.

Re: [SQL] Problems Pgdump

it table alwals sent me a message like i COULD NOT FIND THE NAME OF TABLE but the table exist and I use the logic for other tables and works fine . What could be the problem? thnks 2011/5/24 manuel antonio ochoa > I trying to get the next one : > > pg_dump -h 192.170.1.3 -U User -

[SQL] Problems Pgdump

I trying to get the next one : pg_dump -h 192.170.1.3 -U User --format custom --inserts --verbose --file \"/root/Desktop/$name .backup\" --table "$ESQUEMA.$Nametable" DB" my Name table is detalle_Inegra , and the problem is that it table alwals sent me a message like i COULD NOT FIND THE NAME

[SQL] FATAL: invalid cache id: 19

Good morning !! How can I solve this problem : FATAL: invalid cache id: 19 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: the database system is starting up 2011-05-01 21:28:32 CDT feria uploader11 FATAL: th

[SQL] Compare two Data bases Structure

How Can I do to compare two structures of data bases ? DBA != DBB I need wich functions and wich tables are not equals thnks

[SQL] Compare the resulta of a count sql into bash

Hello, I have the next : COUNTONE=`/var/lib/pgsql/bin/./psql -U 'Thor' -d princlocal -p 5432 -h 192.170.1.82 -c "select count(*) from monterrey.${NOMBRETB}"` COUNTTWO=`/var/lib/pgsql/bin/./psql -U 'Thor' -dprinclocal -p 5432 -h 192.170.1.82 -c "select count(*) from monterrey.$nombre where re

[SQL] pgbench tools

Hello, I run ./runtest it begin and insert some tuples like 1000 tuples done. and the i have this problem : Run set #3 of 3 with 16 clients scale=100 Running tests using: psql -h 192.170.1.82 -U postgres -p 5432 -d pgbench Storing results using: psql -h 192.170.1.82 -U postgres -p 5432 -d resu

[SQL] Benchmarking

hello do you know a tool to benchmark my dbase and the basic test that I need to do ? I found a pgbench !!! ...

[SQL] control function pgsql with script bash

Good morning I want to check if the function pgsql execute correctly into my bash script . I have something like this : /var/lib/pgsql/bin/./psql -U 'USER' -d DATABSE -p 5432 -h iphost -c "select antros.changethenames( )" how can i get the error if the function changethenames() send me

[SQL] check files .backup

Do you know if exist a function to check my file.backup created by pgdump. ? thnks