On Sun, Jun 23, 2013 at 3:17 PM, pmu <perlpetual@gmail.com> wrote:
> Any help I will be very thankful.
pg_lsclusters will tell you about what databases are setup on your
system. The Debian and Ubuntu packages support having multiple
PostgreSQL releases and multiple instances of arbitrary releases, so
the path layouts are somewhat different to other simpler setups.
pg_ctlcluster, pg_createcluster and pg_dropcluster are the other
useful tools.
With the Debian and Ubuntu packages, you can check
/etc/postgresql/9.1/main/postgresql.conf to check the port PostgreSQL
is configured to use. You can also check
/var/log/postgresql/postgresql-9.1-main.log to look for error messages
and confirm if PostgreSQL is complaining or actually running. These
two files are a good place to start.
/var/lib/postgresql/9.1/main will be the DATADIR created automatically
when you install the packages, and initdb is in
/usr/lib/postgresql/9.1/bin (but the Debian tool pg_createcluster
wraps that so you don't need it, unless you want to go oldskool and
then you are on your own).
I suspect you will find the package installer chose a non-standard
port for PostgreSQL because port 5432 was already in use, and whatever
is listening on port 5432 isn't talking to psql.
--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/