[Gnumed-devel] Re: ok... this (postgres) is getting very annoying!

[Andreas Tille]

On Thu, 4 Sep 2008, James Busser wrote:

> To the default files in the directory
>  /etc/postgresql/8.3/main
>
> I made some backups and, in doing so, noticed that postgres did not have 
> write-permission to the files in this directory... are the permissions of 
> these files meant to stay the following way?
>
> drwxr-xr-x 2 root     root      4096 2008-09-04 10:40 .
> drwxr-xr-x 3 root     root      4096 2008-09-03 18:08 ..
> -rw-r--r-- 1 root     root       316 2008-09-03 18:09 environment
> -rw-r----- 1 postgres postgres  4309 2008-09-04 10:40 pg_hba.conf
> -rw-r----- 1 postgres postgres  1585 2008-09-04 10:43 pg_ident.conf
> -rw-r--r-- 1 postgres postgres 16682 2008-09-03 18:09 postgresql.conf
> -rw-r--r-- 1 root     root       378 2008-09-03 18:09 start.conf

It perfectly matches my installation.

> The annoying part came after I tried to reload the alterations that I had 
> made...
>
> address@hidden:~$ pg_ctl reload
> bash: pg_ctl: command not found

Hmmm, why not

   /etc/init.d/postgresql-8.3 restart

This should be always a safe way to propagate changes in the config filed.
At least it worked for me and I never tried something else.

Kind regards

        Andreas.

--
http://fam-tille.de