moving /data folder (win32, pgsql 8.1.3)

From: "Alexandre Leclerc" <alexandre(dot)leclerc(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: moving /data folder (win32, pgsql 8.1.3)
Date: 2006-04-24 21:37:04
Message-ID: 1dc7f0e30604241437q4f6be061h3f1a793fc0ecd8b5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

I tried to "move" the /data folder to another HD. The service refuse
to start after that and does not raise any errors.

- Stop service
- Copy /Program Files/PostgreSQl/8.1/data folder to, let say, d:/data
- Changed /Program Files/PostgreSQl/8.1/data/postgresql.conf:
data_directory = 'd:/data/'
- Started service, but will stop without any error message

* Under XP home; I cant' tell about the security params of the files
since it looks like in xphome I can't see them. But a copy paste
should leave the things alright.
* No error in windows logs... for what it worth any-way.

I don't know what I'm missing.

Regards.

--
Alexandre Leclerc

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-04-24 21:46:55 Re: FATAL: catalog is missing attributes
Previous Message Tom Lane 2006-04-24 21:36:56 Re: Autovacuuming