How to connect to a database psql doesn't see

From: Mick <mickg01(at)verizon(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to connect to a database psql doesn't see
Date: 2014-01-03 20:50:36
Message-ID: 1388782236.5568.9.camel@mick-desktop-64
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a database (timetrex), which is accessed via a web page, located
on an Ubuntu 12.04 Sever. I can trace all the files and it's producing a
regular .sql backup file each day (or maybe each time it is accessed via
the web page).
When I attempt to access it using the psql -l command as user Postgres
it does not show.

Over time timetrex seems to have created a Postgres 8.3 database and a
postgres 9.1 database in the /var data path and neither shows up.

Before I update timetrex to the latest version I would like to know that
in an extreme case I can run the .sql backups to restore my data but to
do that I need to be able to see the database.

Is there a way to run the postgres client pointing to the path for the
database files I have identified so it does see my timetrex database?

Thanks

Mick

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Swierczek 2014-01-03 21:39:50 Re: How to connect to a database psql doesn't see
Previous Message Sameer Kumar 2014-01-03 16:16:04 Re: Master-slave failover question