Re: [HACKERS] Transaction log

2011-04-06 Thread aaronenabs
Wow sounds very complicated. Will have to try that but got to say i am new to postgresql and might find that difficult. so at the moment i would try and to the little i can to find parts in the DBMS that can be of use, as i already tried struggling to try and find a way to set the HeapTuplevisiblit

Re: [HACKERS] Transaction log

2011-04-06 Thread aaronenabs
Thanks for that information would look into the xmin and xmax columns. so its not possible to turn the HeapTupleVisiblity to true to view dead tuples by setting it to #define HeapTupleSatisfiesVisibility(tuple, snapshot, buffer)(1) -- View this message in context: http://postgresql.1045698.n

Re: [HACKERS] Transaction log

2011-04-06 Thread aaronenabs
True, i have looked at pg_dumpfile and worked around that, Seems to be a very important tool for forensic investigations. But looking for any other aspect of the DBMS that can be helpful. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Transaction-log-tp4285471p4286318.ht

Re: [HACKERS] Transaction log

2011-04-06 Thread aaronenabs
Well at the minute I am trying to find out sections of postgresql that can be helpful to carry out a database forensics analysis and thought the most useful with be the transaction log. So was actually interested in viewing it. -- View this message in context: http://postgresql.1045698.n5.nabble.

[HACKERS] Transaction log

2011-04-05 Thread aaronenabs
Hi All, I was wondering if anyone can tell me how i can access the transaction log within postgresql 9.0.3. I have carried out some updated and deletions within the database and am hoping the transaction logs have records of this. Cheers all -- View this message in context: http://postgresql.10

Re: [HACKERS] PostgreSQL sourcecode

2011-03-30 Thread aaronenabs
Sorry about that, here is the section before the make. dllwrap -o cygpq.dll --dllname cygpq.dll --def libpqdll.def fe-auth.o fe-connec t.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o fe-protocol2.o fe-protocol3.o pqexp buffer.o pqsignal.o fe-secure.o libpq-events.o md5.o ip.o wchar.o encnames.o nob

Re: [HACKERS] PostgreSQL sourcecode

2011-03-29 Thread aaronenabs
what c compiler would you suggest i use please thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-sourcecode-tp4270534p4270566.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hacke

[HACKERS] pg_dumpall

2011-03-29 Thread aaronenabs
Hi there, I have been having problems using the pg_dumpall function. I am trying to dump all the information on my database onto a file or view it. Actually what am trying to achieve is by using the pg_dumpall i can view dead rows once the db has been dumped into a file. I had a look online and tr

[HACKERS] PostgreSQL sourcecode

2011-03-29 Thread aaronenabs
Hi all i have been trying to compile the sourcecode for postgresql but keep getting an error message when running it in cygwin. it states: dllwrap: gcc exited with status 1 make[3]: *** [cygpq.dll] Error 1 make[3]: Leaving directory `/postgresql-9.0.3/postgresql-9.0.3/src/interfaces/li bpq' make

[HACKERS] How to Make a pg_filedump

2011-03-25 Thread aaronenabs
Hi All I am trying to write a pg_filedump to read dead rows in pgsql, I am relatively new to postgresql and have been trying to find out how to write and compile a pg_filedump to help display dead rows. Please can anyone help me i) Explain how i can write a pg_filedump to display dead rows or ho

[HACKERS] How to Make a pg_filedump

2011-03-25 Thread aaronenabs
Hi All I am trying to write a pg_filedump to read dead rows in pgsql, I am relatively new to postgresql and have been trying to find out how to write and compile a pg_filedump to help display dead rows. Please can anyone help me i) Explain how i can write a pg_filedump to display dead rows or ho

[HACKERS] Compiling postgre sourcecode

2011-03-24 Thread aaronenabs
Hi All I am relatively new to postgresql, have downloaded it and done some exercises on how to use postgresql and can say i have picked up on it very quicky. At the minute i have downloaded the sourcecode for version9.0.3 and trying to compile it on my computer(win xp) but cannot find any document

[HACKERS] writing a script to examine dead tuples

2011-03-22 Thread aaronenabs
Can anyone help me, i am trying to carry out an investigation which involves accessing dead tuples within the postgresql. I have been advised i could write a script that allows me to examine dead tuples and am seeking advise on how to achieve this, or pointers that can help me going in the right

[HACKERS] writing a script to examine dead tuples

2011-03-22 Thread aaronenabs
Can anyone help me, i am trying to carry out an investigation which involves accessing dead tuples within the postgresql. I have been advised i could write a script that allows me to examine dead tuples and am seeking advise on how to achieve this, or pointers that can help me going in the right