Hi Tom,
Here it is!
locktype| relation | transactionid | transaction |mode
| pid | granted
---+--+---+-+-++-
relation |16496 | | 147195029 | AccessShareLock
"Tena Sakai" <[EMAIL PROTECTED]> writes:
>> What you have not shown us is what transaction has
>> actually *got* a lock on 16496.
> Would you mind enlightening me as to how I can do so?
Are there no other rows in pg_locks that reference relation 16496?
None of the ones you showed us had granted=t
Hi Tom,
> What you have not shown us is what transaction has
> actually *got* a lock on 16496.
Would you mind enlightening me as to how I can do so?
I stared at the output from pg_locks a long time and
just can't get more than what I had gotten out of.
Regards,
Tena Sakai
[EMAIL PROTECTED]
--
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> That pid 6697 caught my interest and I fished it out of "ps -ef":
> postgres 6697 4916 0 Dec15 ?00:19:45 postgres: postgres canon
> [local] REINDEX waiting
> (and for the sake of completeness...)
> postgres 12930 4916 0 11:24 ?00:
Toad Data Modeler
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Marco Antonio
> Sent: Monday, December 17, 2007 2:02 PM
> To: Mark Steben
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Looking for an E/R tool for Postgres
>
> On Dec 17,
Hi Tom,
By a bit of poking around, I am discovering interesting
things, but I am a bit lost... (Before I go on, I should
state that I am running postgres 8.2.4 on RedHat Linux with
Dell hardware.)
Here's what I did:
I issued: select locktype, relation, transactionid, transaction, mode, pid,
gr
A.Burbello wrote:
> If doesn't have another way, how can I put the
> "header" in the begin of file without open?
> With "cat >>" command I put in the end.
Don't -- you can put the header in a separate file and do something like
(cat header-file ; cat split-1 ; cat tail-file ) | psql
lather, rin
> If doesn't have another way, how can I put the
> "header" in the begin of file without open?
> With "cat >>" command I put in the end.
After the split files are loaded on the new server file system:
cat splitfile*.txt > bigfile.txt
psql < bigfile.txt
THINK BEFORE YOU PRINT - Sa
Thank you, Tom!
> Some other session holding an exclusive lock on the table, perhaps?
That is exactly the case.
I see what I must do. Many thanks.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 12/17/2007 4:11 PM
To: Tena S
"Tena Sakai" <[EMAIL PROTECTED]> writes:
> I have a weired situation. Out of 17 tables which
> comprise a database, one of them refuses to talk to
> me. When I issue:
> select * from marker;
> it hangs.
Some other session holding an exclusive lock on the table, perhaps?
Have you looked into pg
Hi Everybody,
I have a weired situation. Out of 17 tables which
comprise a database, one of them refuses to talk to
me. When I issue:
select * from marker;
it hangs. When I replace * with amy column name, it
makes no difference. It does not respond, unless I
issue ctrl-C. I have checked wit
Thank you for your response!
I tested the split command and I got another problem
because for each file doesn't have the "COPY" header.
As well I said early, one table has more than 30G and
I need to import to another server (linux), but by dvd
media because doens't have network connection.
What
Scott Marlowe wrote:
On Dec 17, 2007 2:06 PM, A.Burbello <[EMAIL PROTECTED]> wrote:
I consider this way a good practice to transport the
files. This is because I have table that has more than
30GB.
But if the OS was windows, couldn't split the files
because postgres doesn't has this feature!
Cou
"Scott Abel" <[EMAIL PROTECTED]> writes:
> Now when I try to run it (still with 8.2.4), the CREATE DATABASE
> statement generated uses template0 and then pg_dump regurgitates every
> function in my database, including those that came from template1. I
> don't use most of the functions and don't wa
The best thing I've found is Aqua Data Studio from AquaFold.
Carol Walter
Quoting Mark Steben <[EMAIL PROTECTED]>:
Does anybody have suggestions as to what Entity_Relationship diagram tool
Is out there that'll work for Postgres?
Thank you,
Mark Steben
Senior Database Administrator
@ut
On Dec 17, 2007 2:06 PM, A.Burbello <[EMAIL PROTECTED]> wrote:
> I consider this way a good practice to transport the
> files. This is because I have table that has more than
> 30GB.
> But if the OS was windows, couldn't split the files
> because postgres doesn't has this feature!
> Could be a good
On Dec 17, 2007 12:58 PM, Mark Steben <[EMAIL PROTECTED]> wrote:
> Does anybody have suggestions as to what Entity_Relationship diagram tool
>
> Is out there that'll work for Postgres?
dbwrench: http://www.dbwrench.com/
--
Saludos y abrazos...
Marco Antonio Frias Butrón
Slackware Linux User
Lin
I consider this way a good practice to transport the
files. This is because I have table that has more than
30GB.
But if the OS was windows, couldn't split the files
because postgres doesn't has this feature!
Could be a good option if postgres had native.
Weel, I will try this:
eg: $ pg_dump postg
I was using pg_dump --create --schema-only (or so I thought) to
maintain source files for my database that I could check into my
revision control system. Now I just tried to recreate the source file
from an updated version of the DB, and I'm finding that it dumps all
the built-in stuff from templa
Hi,
> the qry running with same pid are another queries
> assined same pid, this is the reason why they are
> loking like running from two days
Given the load of this computer, that is a bit
hard for me to swallow...
I had no overwhelming reasons to kill them and I
left them alone and after 4 or
Mark Steben wrote:
Does anybody have suggestions as to what Entity_Relationship diagram tool
Is out there that’ll work for Postgres?
Case Studio?
Joshua D. Drake
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
We use Toad Data Modeler
Is not free though
http://www.quest.com/Toad-Data-Modeler/
From: [EMAIL PROTECTED]
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Looking for an E/R tool for Postgres
Date: Mon, 17 Dec 2007 11:58:21 -0500
Does anybody have suggestions as to w
Does anybody have suggestions as to what Entity_Relationship diagram tool
Is out there that'll work for Postgres?
Thank you,
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-24
Hi all,
Any of you has installed pgmemcache on Debian? I haven't found any
repository for it, Did you compiled it yourself? Is there any repository
for it?
Thanks
--
Arnau
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Aldor wrote:
> Well, the database is also showing a hint when less then 9 million
> transactions are available - and this hint is telling us to vacuum
> the whole database.
>
> If, vacuum the whole database, would take days (quite unsure how
> many days sometimes) is it possible to find out manual
Hola compañeros.. So y nuevo con PostgreSQL.. lo instale y todo ç, pero cuando
entro al pgAdmin III me da para conectar a un servidor, pero el servidor en
este caso seria mi PC, pero me pide:*NAME*HOST*PORT *y otros datos mas como
contraseñas, etc.. Alquien podria decirme que debo colocar en ca
Well, the database is also showing a hint when less then 9 million
transactions are available - and this hint is telling us to vacuum
the whole database.
If, vacuum the whole database, would take days (quite unsure how
many days sometimes) is it possible to find out manually which
tables originall
27 matches
Mail list logo