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

Active Topics

Maemo repository (5)
to Community by dredlok706 - 1 day, 18 hrs ago
Re-commissioning N9 in 2018 (127)
to MeeGo / Harmattan by smatkovi - 1 day, 21 hrs ago
Porting apps to Leste (41)
to Maemo 7 / Leste by Arno_11 - 2 days, 14 hrs ago
List of well performing apps on Leste (33)
to Maemo 7 / Leste by teroyk - 2 days, 23 hrs ago
N900 is not recognizable on any of my devices (windows 10,7, xp) What can I do? (1)
to Nokia N900 by nieldk - 4 days, 3 hrs 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??!