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

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 (view raw or flat)
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

pgsql-admin by date

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

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