ken@xxxxxxxxxxxxxx (Ken Hill) writes: > That works nice. It shows my data directory in > '/var/lib/postgresql/7.4/main'. When I do an ls command, I get: > > $ sudo ls /var/lib/postgresql/7.4/main > base pg_clog pg_ident.conf pg_xlog postmaster.opts > root.crt > global pg_hba.conf PG_VERSION postgresql.conf postmaster.pid > > I have created two database named 'testdb' and 'csalgorithm'. How do I > find these databases? I was expecting the databases to be subdirectories > under the database directory (e.g. /var/lib/postresql/7.4/main/testdb > and /var/lib/postgresql/7.4/main/csalgorithm). They'll be in a subdirectory; the thing is, tables and databases are not named _by name_. The filenames are the OID numbers associated with either databases (see pg_catalog.pg_database) or tables (see pg_catalog.pg_class). -- let name="cbbrowne" and tld="ntlug.org" in String.concat "@" [name;tld];; http://cbbrowne.com/info/unix.html "The Linux philosophy is laugh in the face of danger. Oops. Wrong One. 'Do it yourself.' That's it." -- Linus Torvalds
