Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-15 Thread Jonel Rienton
but I know 9 computer languages. Pinoy Ako! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ottó Havasvölgyi Sent: Saturday, January 14, 2006 7:46 PM To: Pg - General Subject: Re: [GENERAL] Moving PostgreSQL data directory on Windows Jonel, I have initiali

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-14 Thread Ottó Havasvölgyi
> -- > I know not english well, but I know 9 computer languages. > Pinoy Ako! > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ottó Havasvölgyi > Sent: Saturday, January 14, 2006 7:38 AM > To: Magnus Hagander > Cc: Pg - General

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-14 Thread Jonel Rienton
ister to register a new one with the new data directory Doing this you won't hvae to reboot.. > > > Perhaps this is something we should add to pg_ctl for 8.2? "pg_ctl reconfigure" or something like that? What do others think? > > //Magnus > > > -Original Mess

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-14 Thread Ottó Havasvölgyi
g_ctl register to register a new one with the new data > directory. Doing this you won't hvae to reboot. > > > Perhaps this is something we should add to pg_ctl for 8.2? "pg_ctl > reconfigure" or something like that? What do others think? > > //Magnus > > &

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-14 Thread Magnus Hagander
x27;t hvae to reboot. Perhaps this is something we should add to pg_ctl for 8.2? "pg_ctl reconfigure" or something like that? What do others think? //Magnus > -Original Message- > From: Ottó Havasvölgyi [mailto:[EMAIL PROTECTED] > Subject: Re: [GENERAL] Moving PostgreSQ

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Rodrigo Gonzalez
Directory permissions for user the user running the service? Ottó Havasvölgyi wrote: Magnus, It's a service, and it is 8.0.6. I have fixed the registry to this value: "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N "pgsql-8.0" -D "E:\PostgreSQL\data\" The service does not start

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Ottó Havasvölgyi
Magnus, It's a service, and it is 8.0.6. I have fixed the registry to this value: "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N "pgsql-8.0" -D "E:\PostgreSQL\data\" The service does not start. This new directory definetely exists. But now there is no Event log entry about the err

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> 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

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Doug McNaught
Doug McNaught <[EMAIL PROTECTED]> writes: > Dumb question, but are you sure you exported the PGDATA variable? Is > it pointing to the directory that actually contains postgresql.conf? > > If you still have problems, post the exact error message that appears > in the logs. Duh, I didn't read the

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Magnus Hagander
> Hello, > > I would like to move the data directory to another location. > I have done this: > 1. Stop PostgreSQL > 2. Move data directory > 3. Create a PGDATA env. variable to the new location 4. Start > PostgreSQL > > And it cannot start, because it cannot find postgresql.conf. > (in Event

Re: [GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Doug McNaught
Ottó Havasvölgyi <[EMAIL PROTECTED]> writes: > Hello, > > I would like to move the data directory to another location. I have done this: > 1. Stop PostgreSQL > 2. Move data directory > 3. Create a PGDATA env. variable to the new location > 4. Start PostgreSQL > > And it cannot start, because it ca

[GENERAL] Moving PostgreSQL data directory on Windows

2006-01-13 Thread Ottó Havasvölgyi
Hello, I would like to move the data directory to another location. I have done this: 1. Stop PostgreSQL 2. Move data directory 3. Create a PGDATA env. variable to the new location 4. Start PostgreSQL And it cannot start, because it cannot find postgresql.conf. (in Event log) What should I do now