[HACKERS] writing a script to examine dead tuples
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 direction. I am relatively new to this forum and postgresql and have been assigned postgresql as a topic within my studies which as lead me to creating a script to perform this task. If anyone can help me i would be really grateful. Thanks Aaron -- View this message in context: http://postgresql.1045698.n5.nabble.com/writing-a-script-to-examine-dead-tuples-tp4257955p4257955.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] writing a script to examine dead tuples
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 direction. I am relatively new to this forum and postgresql and have been assigned postgresql as a topic within my studies which as lead me to creating a script to perform this task. If anyone can help me i would be really grateful. Thanks Aaron -- View this message in context: http://postgresql.1045698.n5.nabble.com/writing-a-script-to-examine-dead-tuples-tp4257956p4257956.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Compiling postgre sourcecode
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 documents or tutorials on how to compile it or understand sections in the sourcecode. What am trying to do is access dead tuples and have been advised i can compile the source code and set the HeapTupleSatisfiesVisibility() to true and this should show all tuples. Please can anyone advise on the best way to compile the sourcecode and also change the HeapTupleSatisfiesVisibility() to true. Thanks Aaron -- View this message in context: http://postgresql.1045698.n5.nabble.com/Compiling-postgre-sourcecode-tp4262808p4262808.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] How to Make a pg_filedump
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 how to write pg_filedump ii) Explain how to compile a pg_filedump Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-Make-a-pg-filedump-tp4264126p4264126.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] How to Make a pg_filedump
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 how to write pg_filedump ii) Explain how to compile a pg_filedump Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-Make-a-pg-filedump-tp4264125p4264125.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] PostgreSQL sourcecode
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[2]: *** [all] Error 2 make[2]: Leaving directory `/postgresql-9.0.3/postgresql-9.0.3/src/interfaces' make[1]: *** [all] Error 2 make[1]: Leaving directory `/postgresql-9.0.3/postgresql-9.0.3/src' make: *** [all] Error 2 what am trying to do is compile the sc and change the HeapTupleSatisfiesVisibility() to true. From looking at the downloaded sourcecode file within "src/include/utils/tqual.h" i cannot see anywhere it is set to false, so would appreciate it, if one could explain how i change it to true. thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-sourcecode-tp4270534p4270534.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] pg_dumpall
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 tried to run the pg_dumpall command from dos using this code: pg_dump Test > aaron.db but came up with this error: C:\Program Files\PostgreSQL\9.0\bin>pg_dump Test > aaron.db Password: pg_dump: [archiver (db)] connection to database "Test" failed: FATAL: password authentication failed for user "Enabs" test being the name of the database and aaron.db being the output file wanted it to view again am sure you might think the password authentication failed due to password, but changed the password, tried again and still no success.. If anyone can link me to a video or example on how the pgdump works or how to use it, i would be very grateful. Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dumpall-tp4270539p4270539.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] PostgreSQL sourcecode
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-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] PostgreSQL sourcecode
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 lock.o pgstrcasecmp.o thread.o -L../../../src/port -Wl,--allow-multiple-definit ion -Wl,--enable-auto-import -L/usr/local/lib -Wl,--as-needed -lcrypt -lpthr ead thread.o:thread.c:(.text+0x5c): undefined reference to `__xpg_strerror_r' collect2: ld returned 1 exit status 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[2]: *** [all] Error 2 make[2]: Leaving directory `/postgresql-9.0.3/postgresql-9.0.3/src/interfaces' make[1]: *** [all] Error 2 make[1]: Leaving directory `/postgresql-9.0.3/postgresql-9.0.3/src' make: *** [all] Error 2 Can you alos advise how i change the the HeapTupleSatisfiesVisibility() to true within the source code: /* * HeapTupleSatisfiesVisibility * True iff heap tuple satisfies a time qual. * * Notes: * Assumes heap tuple is valid. * Beware of multiple evaluations of snapshot argument. * Hint bits in the HeapTuple's t_infomask may be updated as a side effect; * if so, the indicated buffer is marked dirty. */ #define HeapTupleSatisfiesVisibility(tuple, snapshot, buffer) \ ((*(snapshot)->satisfies) ((tuple)->t_data, snapshot, buffer)) -- View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-sourcecode-tp4270534p4271359.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
[HACKERS] Transaction log
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.1045698.n5.nabble.com/Transaction-log-tp4285471p4285471.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Transaction log
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.com/Transaction-log-tp4285471p4286040.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Transaction log
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.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Transaction log
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.n5.nabble.com/Transaction-log-tp4285471p4286515.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] Transaction log
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 HeapTuplevisiblity. Cheers -- View this message in context: http://postgresql.1045698.n5.nabble.com/Transaction-log-tp4285471p4286800.html Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
