Re: How to find data directory - Mailing list pgsql-admin

From Jeff Frost
Subject Re: How to find data directory
Date
Msg-id Pine.LNX.4.64.0512161933170.28807@discord.dyndns.org
Whole thread Raw
In response to Re: How to find data directory  (Ken Hill <ken@scottshill.com>)
Responses Re: How to find data directory
List pgsql-admin
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?

--
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

pgsql-admin by date:

Previous
From: Richard Bortolucci
Date:
Subject: Moving a database
Next
From: Jeff Frost
Date:
Subject: Re: Moving a database