Re: [ADMIN] Help me to decrypt password
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 broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Help me to decrypt password
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 methods. On Tue, 2007-04-24 at 00:08 -0700, sufian khan wrote: Dear I am using an ERP application. I am administrator of that application. Actually I want to see the users passwords those are stored in encryption format. How I decrypt any password that is store in our database table app_users. ***Confidentiality and Privilege Notice*** The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments
[ADMIN] Kill a Long Running Query
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 Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Complete Coverage of the ICC World Cup '07! Log on to www.sify.com/khel for latest updates, expert columns, schedule, desktop scorecard, photo galleries and more! Watch the hottest videos from Bollywood, Fashion, News and more only on www.sifymax.com For the Expert view of the ICC World Cup log on to www.sify.com/khel. Read exclusive interviews with Sachin, Ganguly, Yuvraj, Sreesanth, Expert Columns by Gavaskar, Web chat with Dhoni and more! . ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN]
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 should be looking? Not in HEAD (yet?) -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [ADMIN] Kill a Long Running Query
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/pgsql-hackers-win32/2004-12/msg00039.php -- == Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ==
Re: [ADMIN] [HACKERS] Kill a Long Running Query
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 definitely does not belong on the -hackers list. Third, please find a way of posting to lists that does not include a huge disclaimer and advertisements. If that is added by your company's mail server, you should look at using some other method of posting such as gmail. Fourth, please read our excellent documentation. It contains the answers to your questions, I believe. cheers andrew ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] [HACKERS] Kill a Long Running 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 kill a query, See the user manual on administration functions, pg_cancel_backend in particular: http://www.postgresql.org/docs/8.2/interactive/functions-admin.html Basically you issue a SELECT * FROM pg_stat_activity, or plain ps to find out the pid of the backend executing the long running query, and then use pg_cancel_backend (or kill -INT) to cancel it. and also tell me how to log slow queries to a log file. Using the log_min_duration_statement configuration variable. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[ADMIN] Finding time in WAL logs
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 so that I can look at the content of a WAL archive ? I tried enabling log_min_messages at info level, but it doesn't log the date and time of a executed statement, so that's not a solution. pgsql 8.2.4 on RedHat Linux ES 4 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] [GENERAL] Regarding WAL
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 shipping facility that was introduced in 8.2 only lets you set up a so-called warm standby, which cannot be queried; it's not live replication. The warm standby system is a fairly crude hack that relies on WAL files being copied from the main server to the standby and then starting the standby in recovery mode when you want to bring it up. At this point the standby is your main database, and it can no longer WAL files. Documented here: http://www.postgresql.org/docs/8.2/static/warm-standby.html The use-case for Warm Standby is for people that want a simple, efficient mechanism for providing High Availability replication. If there are any feature requests, please let me know. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [ADMIN] Finding time in WAL logs
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. Does PostgreSQL has something similar to mysqlbinlog so that I can look at the content of a WAL archive ? I tried enabling log_min_messages at info level, but it doesn't log the date and time of a executed statement, so that's not a solution. http://pgfoundry.org/projects/xlogviewer/ I'd appreciate some feedback. I'll be looking to release a new version within next few months. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Finding time in WAL logs
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 do a restore just before the error. Does PostgreSQL has something similar to mysqlbinlog so that I can look at the content of a WAL archive ? I tried enabling log_min_messages at info level, but it doesn't log the date and time of a executed statement, so that's not a solution. http://pgfoundry.org/projects/xlogviewer/ I'd appreciate some feedback. I'll be looking to release a new version within next few months. When I look at a log with xlogdump -s /tmp/NAMEOFWAL, I always get this at the end : Unable to read continuation page? 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 display date and time in the ouput ? ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [ADMIN] Finding time in WAL logs
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 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 so that I can look at the content of a WAL archive ? I tried enabling log_min_messages at info level, but it doesn't log the date and time of a executed statement, so that's not a solution. http://pgfoundry.org/projects/xlogviewer/ I'd appreciate some feedback. I'll be looking to release a new version within next few months. When I look at a log with xlogdump -s /tmp/NAMEOFWAL, I always get this at the end : Unable to read continuation page? It's not that smart about where it stops. 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 display date and time in the ouput ? Original date/time is available only on COMMIT/ABORT records, so you'll need to search ahead/behind. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[ADMIN] question about installing perl module
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 _ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us
Re: [ADMIN] Finding time in WAL logs
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 display date and time in the ouput ? Original date/time is available only on COMMIT/ABORT records, so you'll need to search ahead/behind. Ok, so I guess that auto commited statements will never have date/time ? ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [ADMIN] Finding time in WAL logs
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 clause). I see the XID, but can you also display date and time in the ouput ? Original date/time is available only on COMMIT/ABORT records, so you'll need to search ahead/behind. Ok, so I guess that auto commited statements will never have date/ time ? Ok, I didn't see the commit line after the INSERT. How can I use the -r option ? From my understanding, I can use it to find specific DML, but I tried : -r INSERT -r INSERT -r insert without any success, even if I know that I have INSERT in the log. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Finding time in WAL logs
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 without any WHERE clause). I see the XID, but can you also display date and time in the ouput ? Original date/time is available only on COMMIT/ABORT records, so you'll need to search ahead/behind. Ok, so I guess that auto commited statements will never have date/time ? There'll be a COMMIT record for every transaction, however it was initiated, unless the server crashed/shutdown before it could be issued. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] continuous archive with v823
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 broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[ADMIN] Restoring database from Tablespace
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)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] continuous archive with v823
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 found in the field. -- Bruce Momjian [EMAIL PROTECTED] http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq