Postgres Pro
Downloads
Home   >   mailing lists

Re: Fwd: How do I determine my data dir for a created database for pg_ctl? - Mailing list pgsql-general

From Klint Gore
Subject Re: Fwd: How do I determine my data dir for a created database for pg_ctl?
Date
Msg-id 48ABB377.9060608@une.edu.au
Whole thread Raw
In response to Fwd: How do I determine my data dir for a created database for pg_ctl?  ("Matthew Pettis" <matthew.pettis@gmail.com>)
List pgsql-general
Tree view 
Matthew Pettis wrote:
> I have a database I can psql into... How can I determine what its
> absolute path is so I can use pg_ctl on it to restart it?  Because
> when I use pg_ctl, it tells me I have to provide it in the -D flag as
> an argument.
>
show data_directory;

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: schema name in SQL statement.
Next
From: "Roshni Mani"
Date:
Subject: FW: syntax for Copy command via libpqxx