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). On Fri, 2005-12-16 at 19:34 -0800, Jeff Frost wrote: > Then an easy way is likely to look at the init script that starts it, or use > ps auxwww |grep postmaster to have a look at how it was started. The last > command will likely yield something that looks like this: > > postgres 3026 0.0 0.3 20064 3176 ? S 08:21 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data > > Which means the data directory is /var/lib/pgsql/data. > > >>> database, but I can find the directory where the database are kept. How > >>> do I find where the postgresql database directory is from a command > >>> line? >
