Trouble starting postgresql

Hello!

On my FC5 server, I wanted to configure postgresql to use
/home/pgsql/data instead of /var/lib/pgsql/data. (/home partition is
huge and doesn't get formatted when system is upgraded or new system
installed.) I created the directory, ran initdb; everything seemed ok.

Research seemed to tell me that I should perform the reconfiguration in
/etc/sysconfig/pgsql. However, I could not start the service when the
new directory was specified there. Much experimentation led me to this:

[root@citadel ~]# rm -f /home/pgsql/pgstartup.log
[root@citadel ~]# cp /etc/rc.d/init.d/postgresql
/etc/rc.d/init.d/postgresql2
cp: overwrite `/etc/rc.d/init.d/postgresql2'? y
[root@citadel ~]# cp /etc/sysconfig/pgsql/postgresql
/etc/sysconfig/pgsql/postgresql2
cp: overwrite `/etc/sysconfig/pgsql/postgresql2'? y
[root@citadel ~]# cat /etc/sysconfig/pgsql/postgresql
PGDATA=/home/pgsql/data
PGLOG=/home/pgsql/pgstartup.log
[root@citadel ~]# service postgresql start
Starting postgresql service: [FAILED]
[root@citadel ~]# service postgresql2 start
Starting postgresql2 service: [ OK ]
[root@citadel ~]# service postgresql2 stop
Stopping postgresql2 service: [ OK ]
[root@citadel ~]# cat /home/pgsql/pgstartup.log
postmaster cannot access the server configuration file
"/home/pgsql/data/postgresql.conf": Permission denied
LOG: logger shutting down
[root@citadel ~]#

To sum up: I made an exact copy of the server startup script and an
exact copy of my configuration script. The copy starts, but the original
fails.

Obviously, I'm missing something fundamental here. Any help is
appreciated as I am at the end of ideas.


--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list

Relevant Pages

  • TSLSA-2005-0003 - multi
    ... Package name: bind clamav cpio cups mod_python perl postgresql python ... BIND includes a DNS server, ... Mod_python is a module that embeds the Python language interpreter within ...
    (Bugtraq)
  • Re: Re: help choosing OLAP solutions that run on/with pgsql
    ... > for MSTR ... > Application server if need be. ... > and the underlying database itself. ... > Using a combination of PostGreSQL for the warehouse and Jasper ...
    (comp.databases.olap)
  • Re: 2 x quad-core system is slower that 2 x dual core on FreeBSD
    ... We noticed the slowdown after moving PostgreSQL from 2xXeon 3.0 Apache+PostgreSQL server to dedicated PostgreSQL server. ... PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND ... r p d s w Csw Trp Sys Int Sof Flt 222 cow 16147 total ...
    (freebsd-stable)
  • Re: Python Database Apps
    ... What is your favorite python - database combination? ... make an app that has a local DB and a server side DB. ... I have had a lot of good luck with PostgreSQL. ... If an app comes already designed for mysql, oracle, sqlite, db2, dbm, ...
    (comp.lang.python)
  • Re: VB6, VB2005, or Something Else?
    ... Slashdot had a blurb yesterday about a new ... It's a book to help guide VB6 developers in the ... I then found a web host who would install PostgreSQL ... OLEDB on their W2K3 server which would give me remote access. ...
    (microsoft.public.vb.general.discussion)