gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: James Busser
Subject: [Gnumed-devel] ok... this (postgres) is getting very annoying!
Date: Thu, 04 Sep 2008 11:15:59 -0700

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

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
address@hidden:~$ /usr/lib/postgresql/8.3/bin/pg_ctl reload
pg_ctl: no database directory specified and environment variable PGDATA unset
Try "pg_ctl --help" for more information.
address@hidden:~$

Huh? Despite that I did not touch the default postgres data cluster initialization, am I supposed to have to specify
   -D  /var/lib/postgresql/8.3/main

and/or should I be having to set the PGDATA environment variable
and/or should I be adding to my $PATH
        /usr/lib/postgresql/8.3/bin/

I *did* run pg_lsclusters and verified that the postgres server is online: Version Cluster Port Status Owner Data directory Log file 8.3 main 5432 online postgres /var/lib/postgresql/8.3/ main /var/log/postgresql/postgresql-8.3-main.log
address@hidden:~$




reply via email to

[Prev in Thread] Current Thread [Next in Thread]