Skip site navigation (1) Skip section navigation (2)

Re: How to find data directory

From: Ken Hill <ken(at)scottshill(dot)com>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to find data directory
Date: 2005-12-19 00:34:16
Message-ID: 1134952457.7555.5.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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
global  pg_hba.conf  PG_VERSION     postgresql.conf

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?

In response to


pgsql-admin by date

Next:From: Devrim GUNDUZDate: 2005-12-19 01:01:01
Subject: Re: How to find data directory
Previous:From: Ken HillDate: 2005-12-18 19:21:06
Subject: Re: psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group