Обсуждение: How do I determine my data dir for a created database for pg_ctl?

Hi,

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.

Thanks,
matt

--
It is from the wellspring of our despair and the places that we are
broken that we come to repair the world.
-- Murray Waas

Matthew Pettis wrote:
> Hi,
>
> 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.
>
> Thanks,
> matt
>
Hello,
I use postgresql on a linux ubuntu platform and the path used by default is /etc/postgresql/8.1/main/pgdata
In reality, this path is a symbolic link to /var/lib/postgresql/8.1/main
I suppose that in the other linux distros, it's near this configuration.
Hope this helps

--
Tovo J. RABEMANANTSOA
INRA - UR1263 EPHYSE
71, Av. Edouard Bourlaux
F-33140 Villenave d'Ornon - France
Téléphone : +33 5 57 12 24 09

Matthew Pettis wrote:
> Hi,
>
> 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.
>
> Thanks,
> matt
>

Hi. I'm quite a novice, but I think I can help. In need of determining
the path to the data, I use an indirect method: since different
distributions have different paths, I try to locate the pg_hba.conf
file, which resides on the same directory as your data (with the command
"find / -name 'pg_hba.conf'" (without the double quotes) issued as root).
But since your postmaster is running, I would rather try the following:

ps auwx |grep postmaster

this tells you whether it is in fact running, and if it is, tells you
also the path where the -D flag points to.

Hope this is somehow useful. Best regards,
Barbara

Thank You, Barbara,

See Klint Gore's solution -- that's the one I used and it worked for
me quite well.

Thanks again,
Matt

On Wed, Aug 20, 2008 at 2:38 PM, Barbara Figueirido
<barbara@bariloche.com.ar> wrote:
> Matthew Pettis wrote:
>> Hi,
>>
>> 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.
>>
>> Thanks,
>> matt
>>
>
> Hi. I'm quite a novice, but I think I can help. In need of determining
> the path to the data, I use an indirect method: since different
> distributions have different paths, I try to locate the pg_hba.conf
> file, which resides on the same directory as your data (with the command
> "find / -name 'pg_hba.conf'" (without the double quotes) issued as root).
> But since your postmaster is running, I would rather try the following:
>
> ps auwx |grep postmaster
>
> this tells you whether it is in fact running, and if it is, tells you
> also the path where the -D flag points to.
>
> Hope this is somehow useful. Best regards,
> Barbara
>



--
It is from the wellspring of our despair and the places that we are
broken that we come to repair the world.
-- Murray Waas