[PLUG] postgreSQL...

[Ian Burrell]

On 1/14/07, someone <plug_0 at robinson-west.com> wrote:
> I'm new to postgreSQL.  I'm trying to use with horde-3.0.3.
> Following the instructions to create the horde database, I'm
> wondering where on the filesystem it is located at.
>
> I figured out that psql -l lists what databases exist, but now
> how do I list the locations of all the databases that are
> created by postgres?
>

On Redhat and probably most Linux, the location for the system
PostgreSQL tablespace is /var/lib/pgsql/data.  The databases are in
subdirectories under /var/lib/pgsql/data/base named after the OID of
the database.

 - Ian