Re: createdb

hi,

On Tue, 2012-11-13 at 17:00 +0000, John McLean wrote:

> When one runs: createdb 'database'
>
> should this create a directory named 'database' in the working directory?

No.

> If not, where are the files that this command creates?

All database files are under the database data directory by default, and
the actual location depends on the OS/distro that you are using. For
example, on my Fedora box, they are under /var/lib/pgsql/9.2/data/base
directory (notice data/base, which resolves to database). You can find
out yours by connecting to database and running:

SHOW data_directory ;

Then you will see OIDs of each database under the base/ directory. You
can query them by running:

SELECT oid, datname FROM pg_database;

or use oid2name command line utility.

Hope this will be a start.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz