"Jean-Yves F. Barbier" <12ukwn@gmail.com> writes:
> On Mon, 30 Jan 2012 01:26:07 -0700
> Kevin Goulding <kevingoulding@gmail.com> wrote:
>> My question is -- how do I find where on my hard drive the newly created
>> database ends up?
> In Linux, files are in:
> /var/lib/postgresql/Pg_version_Nb/main/base/OID_of_DB
That's the case for some packagings of Postgres, but not all. The more
traditional location is /var/lib/pgsql/data/base/DBOID/...
>> I have searched the names, with no luck. Could it have
>> to do with the OID number
> Yep.
If you're interested in this sort of detail, you might find it useful
to read the "Database Physical Storage" chapter of the manual:
http://www.postgresql.org/docs/9.1/static/storage.html
(adjust link in the obvious way for whichever major version you're
running, as the details move around sometimes)
regards, tom lane