wget -O -- http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc > ok.key

sudo apt-key add ok.key

http://www.ubuntugeek.com/how-to-install-postgresql-9-2-on-ubuntu-13-04-server.html

recovery postgres password http://www.netstorming.com.ar/2009/10/15/resetear-password-de-root-en-postgresql/

Installing PostgreSQL 9.1 on Ubuntu 10.04

PostgreSQL 9.0 final was released on 2010/09/20 which I’ve been waiting for to begin playing with it and evaluating it. The mainline Ubuntu Lucid apt repositories only have 8.4. According to the package maintainer, Martin Pitt, the postgresql-9.0 package won’t be added until Ubuntu Natty. Thankfully, he setup a backports repo for Ubuntu that we can pull from.

This is a very quick and painless process. If you have not done so already, make your life easier by installing python-software-properties:


sudo apt-get install python-software-properties

Next up is adding the backports repo and updating apt:


sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update

UPDATE: In the comments, Jason Froebe points out that if you already have an earlier version of PostgreSQL installed, you can just upgrade it:

sudo apt-get upgrade

Finally install postgresql-9.1:


sudo apt-get install postgresql-9.1 libpq-dev

The libpq-dev package is for compiling wrappers/clients against libpq.

There you’re done!

jueves, 27 de junio de 2013

web shell

https://code.google.com/p/shellinabox/

Basic HTTPS Shell In A Box

First we download and install Shell In A Box. You can download .deb file for your operating systems architecture here by visition Shell In A Box official page here.

Next thing is to install Shell In A Box:

sudo dpkg -i shellinabox*.deb

Now we need to add a few options to Shell In A Box .conf file:

sudo gedit /etc/default/shellinabox

You need to replace line:

SHELLINABOX_ARGS="--no-beep"

with line:

SHELLINABOX_ARGS="--no-beep --disable-ssl"