Re: [ADMIN] tar, but not gnu tar

2007-09-13 Thread Bruce Momjian
Peter Eisentraut wrote: > Am Freitag, 24. August 2007 03:58 schrieb Tom Lane: > > "Tena Sakai" <[EMAIL PROTECTED]> writes: > > >> This seems to contradict what we say about GNU tar? > > >> Is this GNU tar? What version? > > > > > > Yes, it is GNU tar v1.14 > > > > FWIW, I tried this on Fedora Core

Re: [ADMIN] Moving database install to new SAN

2007-09-13 Thread Andrzej Zawadzki
Użytkownik Tino Schwarze napisał: > On Thu, Sep 13, 2007 at 01:15:34PM -0700, Abu Mushayeed wrote: > >> Can someone help me with moving a postgres database install to a new >> SAN disks. We are getting a new set of faster disk, I would like to >> find out is there a way, without reinstall to

Re: [ADMIN] Moving database install to new SAN

2007-09-13 Thread Tino Schwarze
On Thu, Sep 13, 2007 at 01:15:34PM -0700, Abu Mushayeed wrote: > Can someone help me with moving a postgres database install to a new > SAN disks. We are getting a new set of faster disk, I would like to > find out is there a way, without reinstall to move existing database > and data to t

[ADMIN] Moving database install to new SAN

2007-09-13 Thread Abu Mushayeed
Hello, Can someone help me with moving a postgres database install to a new SAN disks. We are getting a new set of faster disk, I would like to find out is there a way, without reinstall to move existing database and data to the new disks with minimal downtime. Thanks Abu

Re: [ADMIN] Installing PostgreSQL admin package

2007-09-13 Thread Shane Ambler
Ashish Karalkar wrote: Hello list, can anybody please point me to phpPgAdmin windows installation package? Thanks in advance With regards Ashish... I don't think there is a specific windows installer. phpPgAdmin is a web based admin gui, you will need to have a web server running on the wi

Re: [ADMIN] Installing PostgreSQL admin package

2007-09-13 Thread Josh Trutwin
On Thu, 13 Sep 2007 18:27:54 +0530 "Ashish Karalkar" <[EMAIL PROTECTED]> wrote: > Hello list, > > can anybody please point me to phpPgAdmin windows installation > package? http://phppgadmin.sourceforge.net/?page=download download the .zip Assuming you have a Windows web server. phpPgAdmin is

Re: [ADMIN] automatically detecting long timed locks

2007-09-13 Thread Tom Lane
Tino Schwarze <[EMAIL PROTECTED]> writes: > So I'd like to watch for transactions waiting for the lock in step 3 - I > do not care for the time it took to perform the work. Dunno if this is of any use to you, but there is a "log_lock_waits" feature in CVS HEAD that seems to be exactly what you wan

[ADMIN] Installing PostgreSQL admin package

2007-09-13 Thread Ashish Karalkar
Hello list, can anybody please point me to phpPgAdmin windows installation package? Thanks in advance With regards Ashish...

Re: [ADMIN] automatically detecting long timed locks

2007-09-13 Thread Tino Schwarze
On Wed, Sep 12, 2007 at 05:02:56PM -0500, Scott Marlowe wrote: > > is there an easy way to detect locks which are held for a very long > > time? We've got some problems with a database here where a lock is held > > for 1 or 2 hours though the operation should be very quick. A lot of > > other proc