Re: Problems with new data location

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Karen Ellrick" <k-ellrick(at)sctech(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with new data location
Date: 2001-05-29 14:08:21
Message-ID: 18414.991145301@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Karen Ellrick" <k-ellrick(at)sctech(dot)co(dot)jp> writes:
> ... Then I tried creating /var/pgdata fresh and doing initdb -D
> /var/pgdata, and that was okay until I tried to create the database again,
> when it said a database of that name already existed. Yes, I have changed
> my startup script to reflect the new path.

But ... um ... did you restart the postmaster with the new path argument?
Or only change the script?

BTW, it should work fine to move a data-directory tree from one place to
another (with cp -p -r or tar/untar according to preference). But you
have to shut down the old postmaster *first*.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 2001-05-29 14:09:26 Re: 7.1.2
Previous Message Ian Harding 2001-05-29 14:03:36 Re: UPDATE keyword