Re: Moved database question

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Bayless Kirtley" <bkirt(at)cox(dot)net>
Cc: "List, Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moved database question
Date: 2008-08-05 19:02:10
Message-ID: dcc563d10808051202h4df6d3a7q57874392c13eebb2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 5, 2008 at 12:45 PM, Bayless Kirtley <bkirt(at)cox(dot)net> wrote:
> I had to move my database to a new disk. I dropped the original after a
> pg_dump and then removed the old directory. I then ran initdb on the new
> location, created the database and restored from the pg_dump.
>
> My problem now is that I have to supply the full pathnames to start or stop
> the server. Otherwise it still wants to access the old location which no
> longer exists. What am I missing to make the new (and only existing)
> location be the Postgres default?

That very much depends on which OS / version you're on and how you
installed postgresql...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Frey 2008-08-05 19:12:05 result of UPDATE ... RETURNING not usable / "real" SELECT required?
Previous Message brian 2008-08-05 18:59:02 Re: Moved database question