[Top][All Lists]
[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:~$
- [Gnumed-devel] ok... this (postgres) is getting very annoying!,
James Busser <=