[ADMIN] Raw disk space used

2007-08-01 Thread Carol Walter
Hi, Guys, Is there a way to tell what the raw disk space used by a single database is? I know that databases are fluid, but if there is way to do even a snap shot view that is a "ball park" figure, I'd be happy. My user keeps clammering for this figure. Thanks, Carol Walter ---

Re: [ADMIN] Raw disk space used

2007-08-01 Thread Milen A. Radev
Carol Walter написа: > Hi, Guys, > > Is there a way to tell what the raw disk space used by a single database > is? I know that databases are fluid, but if there is way to do even a > snap shot view that is a "ball park" figure, I'd be happy. My user > keeps clammering for this figure. > Depe

Re: [ADMIN] Raw disk space used

2007-08-01 Thread Chris Browne
[EMAIL PROTECTED] (Carol Walter) writes: > Is there a way to tell what the raw disk space used by a single > database is? I know that databases are fluid, but if there is way to > do even a snap shot view that is a "ball park" figure, I'd be happy. > My user keeps clammering for this figure. Sure

Re: [ADMIN] Question about Postgres

2007-08-01 Thread Paul Linehan
NetComrade wrote: > I apologize for cross-posting, but I need some help w/o too many > advices RTFM :). After Oracle and MySQL, this becomes the third > product that I need to learn to some degree, and I need a few links > which would provide a 'quick tutorial' especially for folks with > Oracl

[ADMIN] stracing a connection

2007-08-01 Thread Peter Koczan
Hi all, I'm running into a few problems with postgres connections, specifically notify/listening connections. What program(s) should I attach to the connection using gdb or strace in order to actually get some useful data? i.e. I'll be using something like "strace -p [pid] [command]", what should

Re: [ADMIN] Raw disk space used

2007-08-01 Thread Carol Walter
Thanks so much fro the info. I've done as you suggested and I've got the correct directories. I have a second question now. There are forty-four numeric entries in the directory for the first databases that I looked at. The database in question has only eight tables. There are eight tab

Re: [ADMIN] Raw disk space used

2007-08-01 Thread Tino Schwarze
On Wed, Aug 01, 2007 at 12:34:07PM -0400, Carol Walter wrote: > I've done as you suggested and I've got the correct directories. I > have a second question now. There are forty-four numeric entries in > the directory for the first databases that I looked at. The database > in question has

[ADMIN] Deadlock

2007-08-01 Thread Benjamin Krajmalnik
My aplogies - I forgot to set the subject of the problem I am having when I got lazy and used "reply". > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Benjamin Krajmalnik > Sent: Wednesday, August 01, 2007 11:32 AM > To: pgsql-admin > Subject: Re

Re: [ADMIN] Raw disk space used

2007-08-01 Thread Carol Walter
Oh, that's way cool. Thanks for the script. Carol On Aug 1, 2007, at 12:46 PM, Tino Schwarze wrote: On Wed, Aug 01, 2007 at 12:34:07PM -0400, Carol Walter wrote: I've done as you suggested and I've got the correct directories. I have a second question now. There are forty-four numeric entr

Re: [ADMIN] stracing a connection

2007-08-01 Thread Benjamin Krajmalnik
I have ascheduled pgAgent job which runs monthly executing a stored procedure which handles some partitoned tables. Essentially, it truncated the data in a given partitio and then it changes its rules so it will be ready to accept the data for its respective next cycle. The stored procedure foll

Re: [ADMIN] stracing a connection

2007-08-01 Thread Alvaro Herrera
Peter Koczan escribió: > Hi all, > > I'm running into a few problems with postgres connections, specifically > notify/listening connections. What program(s) should I attach to the > connection using gdb or strace in order to actually get some useful data? > > i.e. I'll be using something like "st

Re: [ADMIN] Deadlock

2007-08-01 Thread Milen A. Radev
Benjamin Krajmalnik написа: > My aplogies - I forgot to set the subject of the problem I am having > when I got lazy and used "reply". [...] Do not use "Reply" to start a new thread. -- Milen A. Radev ---(end of broadcast)--- TIP 9: In versions b

Re: [ADMIN] Deadlock

2007-08-01 Thread Benjamin Krajmalnik
In case you did not read my message, it started with "My apologies" becaue I made the mistake and noticed it. Please, do not try to lecture me. If you have something substanbtive to reply concerning the issue I am having, then by all means do reply. I did not know you were the self-proclaimed lis

Re: [ADMIN] stracing a connection

2007-08-01 Thread Peter Koczan
Thank you Alvaro, it worked. I got confused when I did it before since gdb couldn't figure out half of the elements in the backtrace, and strace kept saying "I can't attach", which was only because gdb was already attached to that same process. Peter Alvaro Herrera wrote: Peter Koczan escr

[ADMIN] incrementals with pg-dump

2007-08-01 Thread David Bear
I googled a bit for an incremental or differential way to backup postgresq. I was hoping there would be switch on pg-dumpall that would backup all tupples added since some date. Doesn't look like it exists. I did find a backup method using the WAL files on the file system at http://www.oreillyn