Struggling to change default data location

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

Responses

Browse pgsql-general by date

  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