Re: Fwd: How do I determine my data dir for a created database for pg_ctl?

From: Klint Gore <kgore4(at)une(dot)edu(dot)au>
To: Matthew Pettis <matthew(dot)pettis(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Fwd: How do I determine my data dir for a created database for pg_ctl?
Date: 2008-08-20 06:02:31
Message-ID: 48ABB377.9060608@une.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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(at)une(dot)edu(dot)au

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tovo Rabemanantsoa 2008-08-20 06:33:35 Re: How do I determine my data dir for a created database for pg_ctl?
Previous Message Ow Mun Heng 2008-08-20 05:56:28 Re: schema name in SQL statement.

Browse pgsql-novice by date

  From Date Subject
Next Message Tovo Rabemanantsoa 2008-08-20 06:33:35 Re: How do I determine my data dir for a created database for pg_ctl?
Previous Message Matthew Pettis 2008-08-20 05:46:00 Fwd: How do I determine my data dir for a created database for pg_ctl?