Re: [GENERAL] Restore problem

2010-12-29 Thread Tim Bruce - Postgres
On Wed, December 29, 2010 10:59, John R Pierce wrote: On 12/29/10 4:34 AM, Leif Biberg Kristensen wrote: Back when I used Windows, my favorite editor was EditPlus (http://www.editplus.com/). It isn't free, but well worth the 35 bucks. other good choices are Notepad++ (free) and my personal

Re: [GENERAL] Who is locking me?

2010-03-18 Thread Tim Bruce - Postgres
On Thu, March 18, 2010 12:29, Bill Moran wrote: In response to Abraham, Danny danny_abra...@bmc.com: Hi, A process hangs forever. When using this query... SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_activity(s.backendid) AS current_query

Re: [GENERAL] Questions on PostGreSQL Authentication mechanism...

2010-02-02 Thread Tim Bruce - Postgres
On Tue, February 2, 2010 08:23, Alvaro Herrera wrote: dipti shah escribió: Techdb=# show hba_file; hba_file -- /etc/postgresql/8.4/main/pg_hba.conf (1 row) Moreover, is there anyway to view content of this file from stored in above

Re: [GENERAL] interface for non-SQL people

2009-10-09 Thread Tim Bruce - Postgres
On Fri, October 9, 2009 09:06, Andrew Gould wrote: On Fri, Oct 9, 2009 at 10:15 AM, Joshua D. Drake j...@commandprompt.com wrote: On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote: On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote: The #1 tool you have at your

Re: [GENERAL] High I/O writes activity on disks causing images on browser to lag and not load

2009-06-03 Thread Tim Bruce - Postgres
On Wed, June 3, 2009 12:59, Bill Moran wrote: In response to Jennifer Trey jennifer.t...@gmail.com: Hmm, I just noticed the same write behavior on my Windows Xp laptop but the values was a little less. I even created an DB with one table and column and this still happened when querying it.

Re: [GENERAL] High I/O writes activity on disks causing images on browser to lag and not load

2009-06-03 Thread Tim Bruce - Postgres
On Wed, June 3, 2009 13:44, Jennifer Trey wrote: On Wed, Jun 3, 2009 at 10:59 PM, Bill Moran wmo...@potentialtech.comwrote: In response to Jennifer Trey jennifer.t...@gmail.com: Hmm, I just noticed the same write behavior on my Windows Xp laptop but the values was a little less. I

Re: [GENERAL] How to speed up the first-time-searching in pgsql?

2009-05-28 Thread Tim Bruce - Postgres
On Thu, May 28, 2009 01:23, Richard Huxton wrote: zxo102 ouyang wrote: Hi there, Thanks for your suggestions. I do have an application running on the machine all the time. In fact, the application keeps writing real-time monitoring data into the database. Based on my understanding of your

Re: [GENERAL] Looking for advice on database encryption

2009-04-16 Thread Tim Bruce - Postgres
On Thu, April 16, 2009 13:20, Bill Moran wrote: In response to Thomas Kellerer spam_ea...@gmx.net: Bill Moran wrote on 16.04.2009 21:40: The goal here is that if we're going to encrypt the data, it should be encrypted in such a way that if an attacker gets ahold of a dump of the

Re: [GENERAL] How to know the password for the user 'postgres'

2008-10-28 Thread Tim Bruce - Postgres
On Tue, October 28, 2008 05:57, Tom Lane wrote: Sam Mason [EMAIL PROTECTED] writes: On Tue, Oct 28, 2008 at 10:42:47AM +0100, Thomas wrote: An easy trick I have found to set postgres password: $ sudo passwd postgres, and now you can type a new password. So now you can switch user with: $ su