sufian khan wrote:
How I decrypt any password that is store in our database table
app_users.
That would seem to strongly depend on how you encrypted it in the first
place.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
Assuming the ERP software uses MD5 hashes to protect the password:
Since MD5 is a ONE-WAY encryption algorithm, then you *might* be able to
use a reverse lookup hash table such as the one found here:
http://gdataonline.com/seekhash.php
There may be similar hash tables around for other encryption
Hi ,
Any body tell me how to kill a long running query in postgresql, is
there any statement to kill a query, and also tell me how to log slow
queries to a log file.
Regards
J Mageshwaran
** DISCLAIMER **
Information contained and transmitted by this E-MAIL is proprietary to
On Mon, 2007-04-23 at 13:31 -0500, Thomas F. O'Connell wrote:
I'm using revision 1.3 of pg_standby.c from here:
http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_standby/pg_standby.c
I don't see the %r parameter there. Is your patch not in HEAD yet, or
is there somewhere else I
On 4/25/07, Mageshwaran [EMAIL PROTECTED] wrote:
Hi ,
Any body tell me how to kill a long running query in postgresql, is
there any statement to kill a query, and also tell me how to log slow
queries to a log file.
Regards
J Mageshwaran
See if this helps:
Mageshwaran wrote:
Hi ,
Any body tell me how to kill a long running query in postgresql, is
there any statement to kill a query, and also tell me how to log slow
queries to a log file.
First. please do not cross-post like this. Pick the correct list and use it.
Second, this query
Please don't cross-post to multiple mailing lists. And pgsql-hackers is
not the correct list for basic usage questions. And long end-of-mail
disclaimers are not generally appreciated.
Mageshwaran wrote:
Any body tell me how to kill a long running query in postgresql, is
there any statement to
Hi,
I'm writing our backup procedure for using WAL and PITR, but to be
able to do a (mostly) perfect PITR, I need to find the time when a
error (DELETE FROM, DROP TABLE, etc.) was made so that I can do a
restore just before the error.
Does PostgreSQL has something similar to mysqlbinlog
On Tue, 2007-04-24 at 11:31 +0200, Alexander Staubo wrote:
On 4/24/07, Mageshwaran [EMAIL PROTECTED] wrote:
I want to do replication using WAL , please tell the methods by which
log shipping is done ie moving the wal files to slaves and executing it.
Not possible at the moment: the log
On Wed, 2007-04-25 at 11:28 -0400, Pascal Robert wrote:
I'm writing our backup procedure for using WAL and PITR, but to be
able to do a (mostly) perfect PITR, I need to find the time when a
error (DELETE FROM, DROP TABLE, etc.) was made so that I can do a
restore just before the error.
Le 07-04-25 à 11:43, Simon Riggs a écrit :
On Wed, 2007-04-25 at 11:28 -0400, Pascal Robert wrote:
I'm writing our backup procedure for using WAL and PITR, but to be
able to do a (mostly) perfect PITR, I need to find the time when a
error (DELETE FROM, DROP TABLE, etc.) was made so that I
On Wed, 2007-04-25 at 13:13 -0400, Pascal Robert wrote:
Le 07-04-25 à 11:43, Simon Riggs a écrit :
On Wed, 2007-04-25 at 11:28 -0400, Pascal Robert wrote:
I'm writing our backup procedure for using WAL and PITR, but to be
able to do a (mostly) perfect PITR, I need to find the time when
Hi,
We are using postgres 8.1.0. While installation we can tell ./configure
--with-perl. In our case, we didn't do it and we just did a ./configure.
Now we want to add perl, python and tcl module. How will I add it. Please
advise.
Regards
skarthi
BTW, the statements look like this :
0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18
tot_len 46
DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
1413 off 5
(this is for a DELETE FROM table without any WHERE clause). I see
the XID, but can you also
Le 07-04-25 à 14:49, Pascal Robert a écrit :
BTW, the statements look like this :
0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18
tot_len 46
DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
1413 off 5
(this is for a DELETE FROM table without any
On Wed, 2007-04-25 at 14:49 -0400, Pascal Robert wrote:
BTW, the statements look like this :
0/15FFE470: prv 0/15FFE440; xid 2332; HEAP info 10 len 18
tot_len 46
DELETE FROM 16612 WHERE ...delete: ts 1663 db 16384 rel 16612 block
1413 off 5
(this is for a DELETE FROM table
Dan Dan [EMAIL PROTECTED] writes:
Was this problem David D. found, fixed in v824?
http://www.mail-archive.com/[EMAIL PROTECTED]/msg17200.html
Yes it was, not sure why the release notes fail to mention it.
regards, tom lane
---(end of
Hi!
My XP was corrupted. I can no longer run the pgdump. The tablespace is
in other drive. Is it possible to restore the database using only the
data in my tablespace? What's the work-around in this problem?
thanks in advance...
Mel
---(end of
Tom Lane wrote:
Dan Dan [EMAIL PROTECTED] writes:
Was this problem David D. found, fixed in v824?
http://www.mail-archive.com/[EMAIL PROTECTED]/msg17200.html
Yes it was, not sure why the release notes fail to mention it.
I thought it was an edge case and not a general error that would be
19 matches
Mail list logo