Thread: Moved database question

Bayless Kirtley 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?
>

You didn't tell us what platform you're using. What does your startup
script have for PGDATA?

On Tue, Aug 5, 2008 at 12:45 PM, Bayless Kirtley <bkirt@cox.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...