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 e
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:
http://archives.postgresql.org/pg
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 definite
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
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 erro
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 can
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
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 displ
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 WHERE
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
Hi Tom,
Was this problem David D. found, fixed in v824?
http://www.mail-archive.com/[EMAIL PROTECTED]/msg17200.html
I'm running into the same message and I'm on v823 now.
Thanks,
~DjK
_
Exercise your brain! Try Flexicon.
http://g
"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 broadc
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 broadcast)
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
19 matches
Mail list logo
