Re: Moving PostgreSQL data directory on Windows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com>, "Pg - General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Moving PostgreSQL data directory on Windows
Date: 2006-01-13 18:25:36
Message-ID: 12231.1137176736@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
>> [ changing PGDATA doesn't seem to work on Windows ]

> Are you running it as a service:? If so you need to reconfigure the service. Unfortunatly,the only way to do this is using regedit. Go to
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pgsql-8.1

Is this documented anywhere? Certainly our SGML manuals don't talk
about anything except the Unix case. Perhaps there needs to be a
chapter in the Server Administration section about managing a Windows
PG server. Or is all that in the installer docs?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rudolph 2006-01-13 18:42:26 Error when inserting millions of records
Previous Message Jaime Casanova 2006-01-13 18:19:31 Re: PostgreSQL Top 10 Wishlist