From: | Geoff Caplan <geoff(at)productivity(dot)co(dot)uk> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Struggling to change default data location |
Date: | 2001-04-26 13:06:24 |
Message-ID: | 1986420131.20010426140624@productivity.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi folks
Having a nightmare changing the default data location in 7.1
I uninstalled and re-installed 7.1 on RedHat 6.2 from the rpms with a
clean system. With the help of this list, I have set $PGDATA in my
shell config file and exported the value.
Postgres utilities such as initdb now recognise $PGDATA and I have
setup a system at my desired location.
initdb does not write a postmaster.opt file at the new location. On
system startup, it does write the .opt file to /var/lib/pgsql/data.
Editing this file with the new datapath does not change the behaviour
below.
At this stage - here is what I get...
$ /usr/bin/pg_ctl -D /www/dbdata -l logfile start
postmaster successfully started
$ pg_ctl status
pg_ctl: postmaster or postgres is not running
$ ps ax | grep postmaster
582 ? S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
Please note:
- postmaster is running, but pg_ctl can't find it
- postmaster has started with the default datapath and is ignoring
$PGDATA
I get the same result if I launch automatically during startup.
Can anyone please help me make some sense of this? I am losing the
will to live...
Geoff Caplan
From | Date | Subject | |
---|---|---|---|
Next Message | Renaud Thonnart | 2001-04-26 13:32:05 | Messages from PostgreSQL |
Previous Message | J.H.M. Dassen Ray | 2001-04-26 12:18:50 | Re: debug logs: query: rollback |