Re: How to find data directory

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Ken Hill <ken(at)scottshill(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to find data directory
Date: 2005-12-17 03:34:43
Message-ID: Pine.LNX.4.64.0512161933170.28807@discord.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2005-12-17 03:39:22 Re: Moving a database
Previous Message Ken Hill 2005-12-17 01:47:36 Re: How to find data directory