| From: | Bob McConnell <rmcconne(at)lightlink(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | john shipley <johnwshipley(at)hotmail(dot)co(dot)uk>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Location of databases |
| Date: | 2009-07-27 20:52:04 |
| Message-ID: | 4A6E1374.7000103@lightlink.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Tom Lane wrote:
> john shipley <johnwshipley(at)hotmail(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2009-07-27 23:18:48 | Re: total number of concurrent connections |
| Previous Message | Tom Lane | 2009-07-27 14:09:57 | Re: Location of databases |