[ANNOUNCE] PostgreSQL server Harmattan (N9) - maemo.org

Active Topics

How many of you still use N900 as main phone? (592)
to Community by bradvesp - 1 hr, 52 mins ago
Which is the best N95? What software modifications could be made to it? (3)
to General by Kalatti - 11 hrs, 33 mins ago
Installing CSSU Stable in year 2024 (2)
to Maemo 5 / Fremantle by teroyk - 19 hrs, 2 mins ago
Porting apps to Leste (34)
to Maemo 7 / Leste by Arno_11 - 1 day, 4 hrs ago
[ANNOUNCE] CSSU-thumb thread - stable Thumb2 on N900 (2,266)
to Maemo 5 / Fremantle by pali - 2 days, 20 hrs ago
Firefox with Leste (7)
to Maemo 7 / Leste by teroyk - 3 days ago
more...

Thread Tools

nieldk	2013-09-21 , 13:28
Guest \| Posts: n/a \| Thanked: 0 times \| Joined on	#1

So, using a load of pentest tools, nessus and metasploit being two. I needed postgres on my N9 for autopwn in metasploit, using database results imported from nessus.

Why not share with you guys!

Download:

Code:

wget https://dl.dropboxusercontent.com/u/85377542/postgres-9.3.0.deb --no-check-certificate

Install:

Code:

devel-su
develsh
dpkg -i postgres-9.3.0.deb
adduser postgres
passwd postgres
mkdir /usr/local/pgsql/data
chown postgres:postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data/

start:

Code:

 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &

test:

Code:

/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

please note, develsh privileges ARE needed for using the su - postgres command.

Last edited by nieldk; 2013-09-21 at 15:31. Reason: typo

Quote & Reply |

The Following 5 Users Say Thank You to For This Useful Post:
jcharpak, Jordi, munozferna, osk2, rcolistete

Jeffrey04	2013-09-21 , 13:37
Posts: 187 \| Thanked: 121 times \| Joined on Jun 2011 @ Subang Jaya, Selangor Darul Ehsan, Malaysia	#2

cool, now i need only php on it to do my work on my n9 hahahahahaha
just saying

Quote & Reply |

The Following User Says Thank You to Jeffrey04 For This Useful Post:

nieldk	2013-09-21 , 14:56
Guest \| Posts: n/a \| Thanked: 0 times \| Joined on	#3

Originally Posted by Jeffrey04

cool, now i need only php on it to do my work on my n9 hahahahahaha
just saying

Feel free to test this build

https://dl.dropboxusercontent.com/u/.../php-5.5.4.deb

Quote & Reply |

The Following 2 Users Say Thank You to For This Useful Post:
jcharpak, rcolistete

Jeffrey04	2013-09-22 , 20:22
Posts: 187 \| Thanked: 121 times \| Joined on Jun 2011 @ Subang Jaya, Selangor Darul Ehsan, Malaysia	#4

Originally Posted by nieldk

Feel free to test this build
https://dl.dropboxusercontent.com/u/.../php-5.5.4.deb

*salute*
now only need an easy way to toggle apache/postgresql service on/off lolol
i suppose they are all upstart scripts, so i can just call service postgresql start??!