Re: problem with maintenance script and missing pg_clog files with pg 7.2.1

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Ben Roberts <benroberts(at)runtime-collective(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: problem with maintenance script and missing pg_clog files with pg 7.2.1
Date: 2002-09-25 11:15:25
Message-ID: 20020925111525.GE31973@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 25, 2002 at 11:18:59AM +0100, Ben Roberts wrote:
> Ben Roberts benroberts(at)runtime-collective(dot)com said:
>
> Tom, Martijn,
>
> Oh dear, I feel this problem is related to us having not correctly
> implemented the move to a new data directory.
>
> I think the problem here is in postmaster.conf:

<snip>

To be honest, I don't know. What I usually do is create a symlink from the
old location to the new location so that it looks like nothing has changed.
The you don't need to change any config files at all.

So something like:

ln -s /2/var/lib/postgres/data /var/lib/postgres/

OTOH, I can't see why you'd be having any problems. If the server can start,
it should have access to everything it needs...

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Knowles 2002-09-25 12:44:35 Re: Postmaster Uptime
Previous Message Ben Roberts 2002-09-25 10:18:59 Re: problem with maintenance script and missing pg_clog files with pg 7.2.1