PostgreSQL, Perl and Ubuntu

  • Posted on December 25, 2011 at 22:59

Make it work

# apt-get install postgresql postgresql-contrib
# apt-get install libpq-dev
cpan> install DBD::Pg
$ sudo su postgres -c psql template1 template1=# ALTER USER postgres WITH PASSWORD 'password'; template1=# \q
$ sudo passwd -d postgres
$ sudo su postgres -c passwd
$ sudo su postgres -c psql < /usr/share/postgresql/8.4/contrib/adminpack.sql

Leave a Reply