Re: Location of databases - Mailing list pgsql-novice

From Bob McConnell
Subject Re: Location of databases
Date
Msg-id 4A6E1374.7000103@lightlink.com
Whole thread Raw
In response to Re: Location of databases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tom Lane wrote:
> john shipley <johnwshipley@hotmail.co.uk> writes:
>> I have just installed PostgreSQL, with a view to using it in
>> conjunction with PSPP and also with OpenOffice Base.  I have
>> created a test database called exampledb with a table in it.  Where
>> do I locate the database, please?  A file search for the name
>> reveals nothing in the filesystem, although the database and table
>> are obviously there.
>
> "show data_directory" would tell you where it is ... although usually
>  the information is of just academic interest.

Until you run out of space on that disk drive/partition.

Bob McConnell

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Location of databases
Next
From: Lonni J Friedman
Date:
Subject: Re: total number of concurrent connections