Find file

[Mumia W.]

On 09/01/2008 04:40 AM, buters wrote:
> Thank you Mumia very much,
> 
>> Why do you need to find the files containing your database?
> 
> pg_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o "OPTIONS"]
> This is a restart usage for pg_ctl, if a db should be restarted.
> 
> If I try:
> **************************************
> $ pg_ctl restart
> **************************************
> 
> I get:
> **************************************
> pg_ctl: no database directory specified and environment variable PGDATA
> unset
> **************************************
> 
> There is in /var/lib/postgresql/ only a data directory, so-called data area
> (a collection of dbs), under which all data are stored. But I want to know,
> how I can only restart my db. Also I need a db directory.
> 
> Best Regards, buters.
> 

I've never used pgsql, but you might get results by specifying the 
database directory, e.g.:

pg_ctl -D /var/lib/postgresql restart